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
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...
290,252
Super User 2024 Season 2
#2
Martin Dráb
228,089
Super User 2024 Season 2
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (