How to apply custom range on AOT query in D365 Finance and Operations

Vijay Yelmame VY

448

07 Jan 2023

Like(0)

Report

Hi All,

Here in this blog will see how to apply custom range on AOT query.

Requirement: Add range on AOT query to get the records created before given days (createdDateTime - PriorDays)

Steps 1 - Add new field in the parameters. Please refer below screen shot.

Step 2 - Create new class and use attribute for range method. Refer below screen shot.

internal final class TestQueryRangeUtil
{
 
  [QueryRangeFunctionAttribute()]
  public static str greaterThanDateByParameter()
  {
        int relativeDays = SalesParameters::find().TestPriorDays;
        utcdatetime currentDateTime;

        currentDateTime = DateTimeUtil::applyTimeZoneOffset(DateTimeUtil::getSystemDateTime(),      DateTimeUtil::getUserPreferredTimeZone());

        return '> '   SysQueryRangeUtil::value(DateTimeUtil::date(DateTimeUtil::addDays(currentDateTime,relativeDays)));
  }

}

Step 3:Create range on AOT query and add below given expression as value.

(TESTQueryRangeUtil::greaterThanDateByParameter())