Exam MB-500 topic 1 question 5 discussion

Actual exam question from Microsoft's MB-500

Question #: 5
Topic #: 1

HOTSPOT -
You have a Dynamics 365 Finance development environment.
You must add default filters to the fleet management form. You must view only sales that occur in the current sales period and where the Customer name field contains the text Wholesales.
You need to configure filtering.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer

Suggested Answer:

by jebacbig at March 23, 2022, 10:10 a.m.

Comments

Submit Cancel

DkingNanu

7 months, 2 weeks ago

Range, daterange, *wholesales*

upvoted 2 times

love3d

2 days, 17 hours ago

Range, DayRange, *wholesales* There is only DayRange, no dateRange Ref: https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/fin-ops/get-started/advanced-filtering-query-options

upvoted 1 times

...

Prollyx

1 year, 11 months ago

SysQuery method: I actually don't think you need any of these methods, but for all the filtering you need to add range to the base data source (qbds.addRange()) and assign value to this range (qbr.value()) SysQueryRangeUtil: dateRange is correct (qbds.addRange(fieldNum(DirPartyTable, CreatedDateTime)).value(SysQueryRangeUtil::dateRange(mkDate(1,1,2021), mkDate(1,1,2022)))) Filter clause: *Wholesales* is correct [ qbr.value("*Wholesales*"); ] "*" = 0..N characters, "?" = 1 character (wildcards)

upvoted 3 times

...

jebacbig

1 year, 11 months ago

Correct