Add Range to Query.

Dynamics 365 for Finance and Operations/AX Developer Forum
1

Hi all,

I added datasources in the form and joined them through datasource properties and made link type as innerjoin. when i open the form i am getting the right query. But now i would like to add another range to that query. How can i add a range through code to the query that is being prepared automatically through the properties of the datasource.

2

Hi,

First add an executeQuery() method on your form datasource then add the following code inside the executeQuery() method before the super();

this.query().datasourceNo(1).addrange(fieldnum(yourTable,YourField)).value(‘yourRangeExpression’);

hope it helps, please verify if it solves your problem

regards,

Thomas

3

Thank you Thomas it worked.