Where do AOT Querists modify filters（AX 2012）

(0) Share

Report

Posted on by Danzel Zuo

121

Dear

I have two questions for the AOT Querists.
The first one is how to obtain the full SQL-statement of Queries, as shown in the figure. I could only see part of it. How shall I display the whole?
The second is that the far right of the figure shows ‘(TransType = 36) OR (TransType = 2)’, but I could not find the modification. How do I modify the filter here？

thank you!

All responses (2)

Answers (1)

Suggested answer

Mohit Rampal 12,558 Moderator on at

Like (1)

Report

Where do AOT Querists modify filters（AX 2012）

Hi, Check this article and you can expand Ranges node in Datasources to verify if ranges are set for those two fields.

https://www.tech.alirazazaidi.com/how-to-get-standard-sql-out-from-query-object-in-aot/
Verified answer

GirishS 27,825 Moderator on at

Like (1)

Report

Where do AOT Querists modify filters（AX 2012）

Hi Danzel.

For the 2nd question - It's the range added under CustTrans DataSource for the field TransType - Range name will be Project and Sales.

TransType is mapped to the Enum "LedgerTransType" where Project will be equal to 36 (Enum elements number) and Sales will be equal to 2 (Enum element number)

For the first point you can create Job and add the below code to get the whole query.

Query query = new Query(queryStr(CustOpenInvoicesListPage));

info(strfmt("%1",query.toString)); - //This will print the whole query in the info log.

Thanks,

Girish S.