Dynamics 365 Community Blogs Dynamics 365 Finance and Operations Solutions Methods used in AOT Query r...

Methods used in AOT Query ranges instead of values

Vignesh.A

203

Like ( 0 )

Report

Here is a quick tip, how to add methods in an AOT query ranges instead of values. Refer standard query 'CaseListPage_MyOpenCases'

Similary, In front end forms also we can use methods o filter the data. To do this, the method we use should be part of the class SysQueryRangeUtil. If we do not find a suitable method, we can create a custom method and that can be used globally in D365 FO.

In forms, to filter the value, Use the methods within() in the filtration area as shown in the below example.

In the example, we are trying to filter with created date time value less than 10 days from today. This way, we can set the dynamic values in AOT queries or during report generation and batch job creations parameters to use the recurrence with dynamic ranges.

This was originally posted here.