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
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.
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.).
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
#1
André Arnaud de Cal...
294,459
Super User 2025 Season 1
#2
Martin Dráb
233,066
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
