Dynamics Community Forum Thread Details

Range issue in AOT query

Hi All,

I have a data entity with data source as view.

The data source of the view is AOT Query. This query having table GeneralJournalEntry.

The query having range as AccountingDate.

We are giving range like this format with the hard code.

Range : "10/1/2021"+'..'+"10/31/2021"; - with this range of hardcode getting the correct results.

Customization:

Created custom class and one method

this method return the same message. Example

class GetQueryRangeUtil
{
[QueryRangeFunctionAttribute()]
public static str CalendarDateRange()
{
str result;
TransDate fromDate,toDate;

fromDate = FiscalCalenderStartDate;
toDate = CurrentDate
SysQueryRangeUtil::dateRange(fromDate, toDate);

return result;
}
}

Given value of range in AOT Query.

(GetQueryRangeUtil::CalendarDateRange()) - with this did not get the results.

Note: The same "10/1/2021"+'..'+"10/31/2021" values given in method as result getting the expecting results.

Need the same range("10/1/2021"+'..'+"10/31/2021") as runtime.

Can you please guide me how can i utilize the query range.

Thanks in advance.

Quick Links

Leaderboard