Finance | Project Operations, Human Resources, ...

How to identify/find the relation between parent and child data sources in queries

(0) Share

Report

Posted on by Community Member

Hi Team,

Ca you please suggest any code snippet or logic to identify the relation between the parent and child data sources for queries in AOT.

Using xpo file we unable to find the relation ship for the parent and child data sources and the relations as well.

Thanks in advance,

Phani

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

zhifeng Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Phani,

You can use Cardinality /RelatedTableCardinality property to verify relationship. Below article has some samples:

docs.microsoft.com/.../cardinality-in-valid-time-state-table-relationships

Was this reply helpful? Yes No
Suggested answer

ergun sahin 8,826 Moderator on at

Like (0)

Report
Copy link

Link copied!

You say xpo, so you're using one of the older versions.
Apart from Cardinality (FetchMode), you first need to determine the relationship itself. If you look at the relationship tab of the child datasource, you can see through which filds the relationship is established.

In some cases, automatic relations is used. In these cases, you can see the relationship name in child ds.

In these cases, you need to go to the table of child ds and examine the relationship with the same name in order to see between fields.

Of course, in order to fully understand the relationship, you need to examine the concepts such as join type, cardinality, fetchmode(etc.).

Was this reply helpful? Yes No
Suggested answer

ergun sahin 8,826 Moderator on at

Like (0)

Report
Copy link

Link copied!

If you want to determine the relationship with the code, it is actually possible. I'm not sure if the query has such a feature, but you can determine the relationships on the tables with the dictrelation.

stackoverflow.com/.../how-can-i-get-and-show-the-fields-that-are-part-of-a-table-relation

You need some luck. You can determine the tables by using Query and see if there is a relationship between them. However, there are situations that need to be considered.

There may be more than one relationship between tables.

There may be no relationship between the tables.

There may be a different relationship defined in the query than in the table.

Was this reply helpful? Yes No