End of mainstream support for Microsoft Dynamics AX 2009, 2012, and 2012Mainstream support for Dynamics AX 2009 Service Pack 1 (SP1), Dynamics AX 2012, and Dynamics AX 2012 R2 ended Oct. 9, 2018. After that date, only security hotfixes will be provided for these three versions through the extended support period that until Oct. 12, 2021. Read more
Dynamics 365 2019 release wave 2 plan Discover the latest updates to Dynamics 365.Release Plan | Weekly Deployment Notes
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants.Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements.
ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Talent TechTalks
I've got an SQL query like below. I've to write an X++ Query for this and insert the result records in a Table. Here i can convert the SQL to X++ except the "Left Outer Join". In X++ we have "Outer Join" That too is not working with Insert_Recordset. Any suggestion would be helpful.
You can use outer join in AX for the same result.
Instead of Insert_Recordset, you can use RecordInsertList, in a while loop (executes slower in comparison, but quite effective)
Hi Crispin John Augustine,
Thank you for the quick response. Actually i showed a part of the sql query in the image, but this SQL query having four part like this and everything as a same query with Multiple Joins and Union. So if i use the While Statement then it will be "performance issue" though we use RecordInsertList. So can we have any other effective approach? without using While statement.
I can think of one last Option:
* Use the query in a View
* Try reading from the view and use it with insert_recordset. It might work.
Hi Crispin John Augustine,
Sorry for the delayed reply, Since i was working with other priorities i was unable to look into this. Now I've done this task with 'RecordInsertList' and by using AOT Query.Its working fine. Thank you for your valuable suggestions.
One question: Can we implement Direct SQL statement execution in DAX with the given SQL Query. Since i used that before for one customization, it was working fine. So my Question is
# Is this Microsoft best practice? or
# if it comes under MBP then any Performance issue will be there compared to our X++ converted ? or
# we need to convert like what I've done now?
"...Can we implement Direct SQL statement execution in DAX with the given SQL Query..." Short answer - Yes. www.artofcreation.be/.../executing-direct-sql-statements
But this requires line by line processing in AX, which is very bad Performance wise.
But if you are thinking in that direction, you can execute a SQL stored procedure /call from AX, fill an AX table from the sp. community.dynamics.com/.../execute-or-call-sql-stored-procedure-in-axapta-by-code
Once it is done, you can just use RecordList to move this data to your target table.
Business Applications communities