How to add multiple range in this case ?

Finance and Operations/AX Developer Forum
1

In my report datasource is PurchTable inside which another datasource is there called PurchLine for line level data and relation is there. in dialog i added two filters one is for date and other for itemid.

In run method i have one range…so it’s displaying POrecords in between dates.

if( fromdate && toDate )
{

this.query().dataSourceTable(tablenum(PurchTable)).addRange(fieldnum(PurchTable,CreatedDateTime)).value(queryRange(fromDate, toDate));
}

But i want to filter item id also.

For example i have 10 POs in Feb 1 to feb 28 in which 2 PO have itemid 100002

So when i filter 100002, in report i want to display those 2 PO in those date which is having item id 100002.

How to add this itemid range to existing PO Date range (that means… how to add itemid range to this.query() which is already defined for Purchtable)

2

After your query:

if( fromdate && toDate )
{

this.query().dataSourceTable(tablenum(PurchTable)).addRange(fieldnum(PurchTable,CreatedDateTime)).value(queryRange(fromDate, toDate));
}

you can write one more query like this :

if (itemidValue)

{

this.query().dataSourceTable(tablenum(PurchLine)).addRange(fieldnum(PurchLine,CreatedDateTime)).value(queryRange(fromDate, toDate));

this.query().dataSourceTable(tablenum(PurchLine)).addRange(fieldnum(PurchLine,itemid)).value(queryvalue(itemid));

}

Please check the query again ,…

3

I tried this also the report is showing the filtered 2 POS but it also showing the other POs falling in between dates

4

Removed the datasources and redesigned the report using fetch method and the problem got solved.

5

Hey I have two optional values for query ranges here

http://www.dynamicsaxlatino.com/rangos-en-un-query-personalizados/