question Relationship table in Developer forum

Relationship table

avinash21 — Wed, 16 Nov 2016 07:29:08 GMT

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

Re: Relationship table

Rohit Sarkar1 — Wed, 16 Nov 2016 07:41:59 GMT

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

Re: Relationship table

avinash21 — Wed, 16 Nov 2016 07:57:34 GMT

where I can find details of the below

TIA

Re: Relationship table

Tee1 — Mon, 07 Aug 2017 20:17:18 GMT

Hi Avinash,

Did you ever find the answer to above?

Thanks

Re: Relationship table

HugoFirst — Mon, 07 Aug 2017 21:15:17 GMT

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"

Re: Relationship table

georgimavrodiev — Tue, 17 Jul 2018 11:43:13 GMT

Hello Avinash,

What are you interested for comes from the Reference field 'Change Request' of Problem (problem) table.
If you create a custom field from type Reference on a table -> then, in the referenced table you will be able to use a newly added Related List pointing to the table where the custom field was created.
If you would like to have a connection between two tables from type 'Many To Many' then you will require to create a new Many to Many Definition: sys_m2m.list > New;
In case, you are looking after establishing a custom relationship, then you may use what Rohit offered, by creating a respective record in Relationships table: sys_relationship.list

Best Regards,
Georgi Mavrodiev

IT Consultant
Do IT Wise, Bulgaria

You may visit us in our Web Site: www.doitwise.com