Dynamics Community Forum Thread Details

D365FO On adding via x++ a new DS to dynamic query (with more than 1 DS's), the query becomes empty

Hello,

I have a dynamic query (selections entered by the user), which is stored via query.pack() in a table field. At some later point in time - this table record needs to be processed and I need to add some extra conditions to the query – e.g. adding an non-existing join clause to another (not initially available in the query) table. This seems to work if the initial query is based only on ONE table, but if the initial query is a join of multiple tables, adding a new data source to the query “clears” the initial query. For exmample, if the initial oldQuery (with CustInvoiceJour as the first data source) - consists only of the CustInvoiceJour data source - the adding of the new data source works. But if the initial oldQuery has e.g. also SalesTable joined to the CustInvoiceJour - the adding of a new data source seems to "break":

newQuery = new Query (oldQuery.pack()); // cloning of the old query
qbdsCIJ = newQuery.dataSourceTable(tableNum(CustInvoiceJour)); // data source found
qbdsNSN = qbdsCIJ.addDataSource(tableNum(NSNProcessed)); // here the newQuery gets "empty" - with only the new NSNProcessed table as a datasource
qbdsNSN.relations(true);
qbdsNSN.joinMode(JoinMode::NoExistsJoin);
qbdsNSN.addRange(fieldNum(NSNProcessed, WorkRequest)).value(queryValue(WorkReqNo));

any ideas?

Thank you!

Categories:

Dynamics 365 Finance

Quick Links