Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Adding data source to AOT query by code

(0) ShareShare
ReportReport
Posted on by

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  ?

  • Martin Dráb Profile Picture
    231,925 Most Valuable Professional on at
    RE: Adding data source to AOT query by code

    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).

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.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,245 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,925 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans