Relationship data table name

[abhithen]

Hi All

May I know the table name where all the relationship data gets stored?

For Eg: If i link INC000001 to CHG00002, where can I get this data from if i want to run a report of all incidents to change relation?

Abhinav

[Harsh Vardhan · Accepted solution]

Hi Abhinav,

if you are creating a relationship between two tables "incident" and "Change Request". and while creating it you have selected "applies on table" as incident then it will be appear on the incident table and data will filter out based on "applies to query" script.

Coming to report query:

eg: i have one incident with multiple change request. if you want to report then below screenshot will help you.

data will store on that same table but by using relationship it can be visible to any of the table and there should be some connection between both the tables.

In report just do dot walking then you will get the result.

Hope it will help you

[sergiu_panaite]

It depends on the case. For your example, there is no special table, 'task' table (with its Task Flattening) has a field called 'parent' that's a reference field. The related list for Changes on Incident uses for example the field parent to identify which change has the parent the incident. So in this particular example all related data is done through fields of type Reference. Several other related lists use same principle.

[asit2]

In your case there is no separate table-

Go to incident table there is a column named-Change Request.

This is a reference field that holds the relationship data-

[abhithen]

Thanks all for the explanation , it is understood there is no particular table for relationship and the reference field takes care of that.

Case closed!