News and Announcements icon

Dynamics 365 CommunityForums Finance forum How can custom made "N...

Finance forum

Unanswered

How can custom made "NotExists"-join to be used in advanced query be created?

(1) Share

Report

Report

Posted on by CU23071440-1

How can custom made "NotExists"-join to be used in advanced query be created?

What is that make "NotExists"-record appearing in "Join"-dialogue in an advanced query?

Can i create new ones related to customized tables?

Categories:

Development / Customization / SDK

All responses Img

All responses (5)

Answers Img

Answers (0)

CU23071440-1 on at

Like (1)

Report

How can custom made "NotExists"-join to be used in advanced query be created?

Actually we have now found and learnt that it depend on from which end you enter.

Our tables have a relation of type "n:1".

When entering from "1"-end the NotExist-joins are shown

But when entering from the "n"-end the NotExist-joins are not present.

It behaves in same way with pure standard tables (like CustTable and CustTrans).

So we were expecting something that would not happen.

Question is therefor resolved.
André Arnaud de Cal... 288,459 Super User on at

Like (0)

Report

How can custom made "NotExists"-join to be used in advanced query be created?

Thanks for your replies. I have moved the question to the Dynamics 365 Finance forum.

Can you tell us if you did a full model build and database sync on this environment after the table relation was added? What type of environment is it where you have this issue? Can you also share all the properties you used for the table relation in case a full model build and database sync are not solving it?
CU23071440-1 on at

Like (0)

Report

How can custom made "NotExists"-join to be used in advanced query be created?

But André we DO have an AOT-relationship between 2 tables but there is not any NotExist-relation shown in advanced query editor.
CU23071440-1 on at

Like (0)

Report

How can custom made "NotExists"-join to be used in advanced query be created?

Yes Arnauld...it is D365 F&O i am referring to.
André Arnaud de Cal... 288,459 Super User on at

Like (0)

Report

How can custom made "NotExists"-join to be used in advanced query be created?

Hi,

I do assume your question is about Dynamics 365 Finance and Operations. Can you confirm this?

When developing tables, you can create relationships between tables. In case there is a relationship defined, the advanced query editor will show options for 1:n, n:1, or NotExitst joins.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 288,459 Super User

#2

Martin Dráb 225,783 Super User

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans