Relationship table

[avinash21]

Hi All

Which table holds the relationship data between problem and change and what is the mechanism used to insert data in this table.

TIA

[Rohit Sarkar1]

Hello,

"sys_relationship.list" is the table name where all the relationship hold.

So now suppose you want to show Problem records under a Change request in the related list then all you have to do is define the relationship like this

Applies to table - Change

Queries from table - Problem

and the "query with" script will contain this

Lets say u_youdesiredfield is a reference field which refers to the Problem record

var abc = parent.u_yourdesiredfield;

var queryString='sys_idIN'+abc;

current.addEncodedQuery(queryString);

Thanks

Rohit

[avinash21]

Hi

where I can find details of the below

TIA

[Tee1]

Hi Avinash,

Did you ever find the answer to above?

Thanks

[HugoFirst]

You might also check the table named task_rel_task.   It shows relationships between any of the various task related records.

To see it type the following text in the filter for the navigation pane (not the quotes):     "task_rel_task.list"