web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / Pooja Karki Blog for Microsoft Dynamics AX / Retrieve underlying SQL Query.

Retrieve underlying SQL Query.

Views (7516)
Pooja Karki Profile Picture Pooja Karki 3,045

Today I will demonstrate you that how you can retrieve underlying SQL Query in AX.


static void Sqlcodestatement(Args _args)
{
CustTable cust;
select generateonly forceliterals cust where cust.AccountNum=="1102";
info(cust.getSQLStatement());
}

generateonly:- is a keyword which allow you to find the underlying SQL query in X++ query statements.

This was originally posted here.

Comments

*This post is locked for comments