Apply range on DOMQuery

(1) Share

Report

Posted on by FI-03060655-0

Hi Community,

I am trying to apply the range on DOMQuery during the DOMProcess Batch Job. I copied the post event handler of getsalesOrderquery method and applying range on salestable. but it did not work.

[PostHandlerFor(classStr(DOMProcessingHelper), staticMethodStr(DOMProcessingHelper, getSalesOrderQuery))]
public static void DOMProcessingHelper_Post_getSalesOrderQuery(XppPrePostArgs args)
{
SalesTable salesTable = args.getThis() as SalesTable;
Query query = new Query(queryStr(DOMQuery));
QueryBuildDataSource qbdsSalesTable;
QueryBuildRange qbr;

qbdsSalesTable = query.dataSourceTable(tableNum(salesTable));
qbdsSalesTable.fields().addField(fieldNum(SalesTable, SalesId));
qbr = qbdsSalesTable.addRange(fieldNum(SalesTable, RetailChannelTable));
qbr.value(/5632076/);

QueryRun queryRun = new QueryRun(query);
while (queryRun.next())
{
SalesTable salesTableResult = queryRun.get(tableNum(SalesTable));
info(strFmt(/Retail Channel : %1/, salesTableResult.RetailChannelTable));
}

}

I have the same question (0)

All responses (1)

Answers (0)

Martin Dráb 240,055 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Your extension doesn't change the query used by DOMProcessingHelper class. You just created a completely new query, ran it, added something to infolog... and then let the system continue with its originally query.

Instead of creating a new query, you'd need to ranges to the query returned by getSalesOrderQuery(). But I see that the whole class is internal, therefore you shouldn't be extending it all. Otherwise it would look like this (let's use CoC instead of PostHandlerFor, because it's both easier to use and safer).

[ExtensionOf(classStr(DOMProcessingHelper))] { public static Query getSalesOrderQuery(DOMExecutionContext _domExecutionContext, RecId _softRunSalesRecId) { // Get the standard query Query query = next getSalesOrderQuery(_domExecutionContext, _softRunSalesRecId); // Modify the query QueryBuildDataSource qbdsSalesTable = query.dataSourceTable(tableNum(SalesTable)); ... // Return the modified query return query; } }

(Moved from Dynamics AX forum.)

Was this reply helpful? Yes No