I am trying to adjust AOT query during the run time by adding extra data source by it does not work , If I try to build the whole query during the run time it works , how can I adjust the AOT during the run time ?
I am trying to adjust AOT query during the run time by adding extra data source by it does not work , If I try to build the whole query during the run time it works , how can I adjust the AOT during the run time ?
Unfortunately we can't tell you what you did wrong unless your give us more information than just that "it does not work".
You can't change the AOT at runtime, but you surely can load the AOT query to a Query object and modify this object. For example:
Query query = new Query(queryStr(MyAotQuery)); QueryBuildDataSource existingDs = query.dataSourceTable(tableNum(TableA)); QueryBuildDataSource newDs = existingDs.addDataSource(tableNum(TableB)); newDs.relations(true);
By the way, which version of AX are you talking about? If it's D365FO, please ask such questions in D365FO forums (such as Dynamics 365 Finance Forum).
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156