Share
ReportHello.
How can I get the sql string value from a Query object? (AX 2009).
(The select statement).
Thanks :)
*This post is locked for comments
You’re offline. This is a read only version of the page.
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
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.
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
This returns something like : Query object ca0fa50
Use:
info(query.toString());
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (