Hi,
I am trying to extract the SQL query from AOT Object(smmSalesCustItemStatistics) in MS Dynamic AX 2012 R3.
Please help me by providing step by step guidance to extract it. I am new starter for Dynamics and have started a week ago,so I don't have much knowledge about this stuff. Please provide me the code which will help me to extract the SQL Query .
Thanks
*This post is locked for comments
Thanks a lot Sohaib. I figured out what was my mistake. Really appreciate your help here.
I am getting the following error when I am running the following job
static void ExecuteAOTQueryCust_5MSC(Args _args)
{
QueryRun queryRun;
;
queryRun = new QueryRun(queryStr(CustTable));
info(queryRun.query().dataSourceTable(tablenum(CustInvoiceJour)).toString());
}
Error executing code: QueryBuildDataSource object not initialized.
Stack trace
Its a job, x++ job. Create a new job in AOT and paste the code there.
Then read the code and change query name from CustTable to your needed query name such as smmSalesCustItemStatistics
Thanks for the reply.
Can you tell me where to write the following code.
static void ExecuteAOTQueryCust_1SMC(Args _args)
{
QueryRun queryRun;
;
queryRun = new QueryRun(queryStr(CustTable));//add any name of query here
info(queryRun.query().toString());
}
I have opened the CustTable and seeing Methods,DataSources,Dependent Objects and so on . But don't know where to write the above piece of code.
you may not get 100% pure sql syntax but very close picture can be taken by some x++ jobs. have a look at next post
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (