I have a ready-made SQL query that made the user retrieve data from AX2012. How can I do the same thing in D365? Is it possible to put the SQL query as datasource in data entity and make it available to the user? Or is there some other way? What is the best way to approach solving this problem?
No, it's not possible. You'll have to identify the relevant tables and add them as data sources, set up appropriate joins, decide whether the entity will support data import and so on.
There is a place where you can use SQL. If you need to calculate a value by SQL, you can use a computed column. This means that you'll write X++ code generating SQL code and this piece of SQL code will be used as a definition of a field of the entity. Of course, this doesn't allow data import, but that's something you can handle by X++ code inside the entity.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
843
Share
Report
All responses (
Answers (
