Where do AOT Querists modify filters（AX 2012）

(0) Share

Report

Posted on by Danzel Zuo

131

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!

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

GirishS 27,827 Moderator on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (1)

Report

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/

Was this reply helpful? Yes No

Join the conversation

Community site session details

Where do AOT Querists modify filters（AX 2012）

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Where do AOT Querists modify filters（AX 2012）

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates