Notifications
Announcements
No record found.
Hello.
How can I get the sql string value from a Query object? (AX 2009).
(The select statement).
Thanks :)
*This post is locked for comments
Use:
info(query.toString());
This returns something like : Query object ca0fa50
It is stored in QueryBuildDataSource object of the query. So u have to use toString() function of queryBuildDataSource.
Try to run this simple job:
query query;
queryBuildDataSource qbds;
;
query = new query();
qbds = query.addDataSource(tableNum(CustGroup));
info(qbds.toString());
U can also access this directly from query object using the dataSource functions for e.g:
info(this.query().dataSourceNo(1).toString());
Thanks,
Rachit Garg
If you are building an x++ query from scratch, info(query.toString()); would work. From a form you use: info(xxxx_DS.query().dataSourceNo(1).toString());
A full breakdown can be found on this blog: bmdax.blogspot.com/.../getting-x-sql-statement-from-aot-query.html
*Remember that this returns an x++ query and not direct SQL.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 4 Most Valuable Professional
Priya_K 4
MyDynamicsNAV 2
