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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How to add table join ...
Finance | Project Operations, Human Resources, ...
Answered

How to add table join in advanced filter

(0) ShareShare
ReportReport
Posted on by AX Lover 315

Hi,

I have 3 tables, such as A, B, C

Table B has a field which is the key field of table C, in table B, i have create a relations for table C and with this key field

There is a test form with datasource both include table A & B, B join A, so A is header and B is line

I go into the 'Advanced filter or sort' form -> 'Joins' -> 'Add table join'

I can add table B join table A, but when i select table B and click "Add table join", in the prompt list i can't found table C in it, why?

Is there anything i am missed? or any properties i need to specify for the relation created in table B?

Thanks!

Roll

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Good Morning Roll,

    I moved this to the D365Finance forum as it seems that you use this product and not the 'old' AX2012.

    Can you share us some screenprints where this issue happens to that we can try replicating the issue you experience?

    Many thanks and best regards,

    Ludwig

  • Suggested answer
    Mea_ Profile Picture
    Mea_ 60,284 on at

    Try to enable "Use legacy mode for query relations" under system parameters, there is a bug introduced recently, so it does not sow some relations in advance filter.  

  • AX Lover Profile Picture
    AX Lover 315 on at

    Hi Ievgen,

    Thanks your reply, I'm try to enable the parameter as you metioned, after update the cross-reference system, only some system table missing in that join list, my table C still not the list...

    Can you share me the link of this bug? Was MS team working on this bug?

    We are now using Update33 (7.0.5559.35512), this should be the latest version.

  • AX Lover Profile Picture
    AX Lover 315 on at

    Hi Ludwig,

    Thank you move my post to right forum, COVID-19 is erupting in your country, take care of yourself...

  • Verified answer
    Mea_ Profile Picture
    Mea_ 60,284 on at

    I think now its time to share more details about relations you created, like what fields are there and what properties did you set. 

  • AX Lover Profile Picture
    AX Lover 315 on at

    Hi Ievgen,

    So strange, when i turn off the "Use legacy mode for query relations", i can see my 'Table C' in the join list now.

    The relation is normal type, and the properties just keep default(Only set the relation fields mapping)

    Thanks again.

    Roll

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 664 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 522 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 303 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans