Retrieve underlying SQL Query.

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.