web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Fetch mode in aot query

(0) ShareShare
ReportReport
Posted on by 4,730

I am not sure what is the use of fetch mode in Aot query . What difference it makes when set to 1:n and 1:1.  I have 2 tables , have a One to one relationship logically but when I use them in queriy as outer join and set the fetch mode to 1:1. Then query behave abnormally. Have some one experienced the same issue ...????

*This post is locked for comments

I have the same question (0)
  • Darren Yu Profile Picture
    Microsoft Employee on at

    never understand the fetch mode completely.  However, follow this

    "The child data source %1 that is outer joined must have fetch mode set to 1:n."

    "The child data source %1 that is inner joined must have fetch mode set to 1:1."

    here is some other post as well.

    axdaily.blogspot.com/.../magical-fetchmode-property.html

    www.crazy-club.de/.../fetchmode

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Sagar Suman Profile Picture

Sagar Suman 2 Super User 2026 Season 1

#1
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#1
Pratik Bhosle Profile Picture

Pratik Bhosle 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans