Hello, community.
I'm trying to create a query request but have some trouble.
I created a request. Added a QueryBuildDataSource with parameters and return and try to execute it on and my result differs than I expected to see.
My code below.
VendAccount partnerCode;
partnerCode = "V-001, V002";
my_List = strSplit(partnerCode, ',');
my_listEnumerator = my_list.getEnumerator();
while (my_listEnumerator.moveNext())
{
//init queryRun
Query query = new query();
QueryBuildDatasource qbds;
QueryRun queryRun;
;
qbds = query.addDataSource(tablenum(VendPackingSlipJour));
qbds.firstOnly(false);
qbds.firstFast(false);
queryRun = new QueryRun(query);
//Build query
qbds = queryrun.query().dataSourceTable(tablenum(VendPackingSlipJour));
qbds.addSortField(fieldnum(VendPackingSlipJour, PurchId));
qbds.addSortField(fieldnum(VendPackingSlipJour, createdDateTime));
if (fromDate != dateNull() || toDate != dateNull()) {
qbds.addRange(fieldNum(VendPackingSlipJour, createdDateTime)).value(SysQuery::range(fromDate, toDate));
}
qbds.addRange(fieldNum(VendPackingSlipJour, InvoiceAccount)).value(SysQuery::value(my_listEnumerator.current()));
//Build a report
while(queryRun.next())
{
queryRun.get(tableNum(VendPackingSlipJour);
//output data to report
}
}my_listEnumerator - consist of V-001, and V-002
qbds looks like:
NAME:
qbds
VALUE:
SELECT * FROM VendPackingSlipJour ORDER BY VendPackingSlipJour.PurchId ASC, VendPackingSlipJour.createdDateTime ASC WHERE ((createdDateTime>='2020-03-31T17:00:00' AND createdDateTime<='2020-04-29T17:00:00')) AND ((InvoiceAccount = N'V-001') OR (InvoiceAccount = N' V-002'))
TYPE:
QueryBuildDataSource
SQL query for SQL Management studio looks like:
SELECT * FROM VendPackingSlipJour
WHERE ((createdDateTime >= '2020-03-31T17:00:00' AND createdDateTime <= '2020-04-29T17:00:00')) AND ((InvoiceAccount = N'V-001') OR (InvoiceAccount = N'V-002'))
ORDER BY VendPackingSlipJour.PurchId ASC, VendPackingSlipJour.createdDateTime ASC;
This code fills a report only for V-001.
Why this code didn't work for V-002
I built a query on SQL management studio and query works for V-001 and V-002.
Please help to understand why this occurs on AX2009.
