Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / Prefilter range criter...
Finance forum
Answered

Prefilter range criteria in query used for report

editSubscribe (2) ShareShare
ReportReport
Posted on by CU09050925-0 6
This is the query filter under /Records to include/ and used in a RDP class.
How to set the criteria lookup to a small subset of items but not all items available in the system.
 
Categories:
Development / Customization / SDK
  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 223,308 Super User on at
    Prefilter range criteria in query used for report
    I don't think this is feasible, because this a generic form used for all queries in the system and the lookup gives you valid values for the field, not valid values for your particular business scenario.
     
    Consider using a dialog field instead of a query range. Then you can implement a UI builder class and use a custom lookup method there.

Helpful resources

Quick Links

Take the Community feedback survey!

Answer this brief 15-question survey about your Community experience…

Demystifying Copilot: Service Edition with Sundar Raghavan

Sundar answers more questions about Copilot for Service...

Dynamics 365 Business Central vs Finance and SCM

Take a look at the key differences between Business Central and…

more Community News

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,375 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 223,308 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,140

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans