Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Unanswered

Fetch mode in aot query

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

  • Darren Yu Profile Picture
    Darren Yu on at
    Re: Fetch mode in aot query

    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

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

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

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,252 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,089 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans