Configure : Parent/Child relationship for Problem table

Kingstan M
Kilo Sage

Hello SNC,

I have an requirement that - To add Parent/Child relationship for Problem table.

I.e., When i add list of problems in the related list problem tab then all those will be considered as child problem and thus when i open any child problem record then the parent problem number should be published in the related records >> parent problem.

Any advice?

find_real_file.png

1 ACCEPTED SOLUTION

Mahendra RC
Mega Sage

Hello Kingstan,

To achieve this you can go to System Definition --> Relationships. Click on New button:

Create a new record as shown below:

find_real_file.png

Put the below script in Query with field on your record :

(function refineQuery(current, parent) {
	var parentProblemID = parent.getValue("parent");
	current.addQuery("sys_id", parentProblemID);
})(current, parent);

Go to the problem table and open any child problem record. Right click on form header go to Configure --> Related Lists

Search Parent Problem under Available section and move it to selected section and click on Save

find_real_file.png 

You will now see the Parent Problem related list which will show the Parent Problem.

Please mark my respsone as helpful/correct, if it answer your question.

Thanks

View solution in original post

11 REPLIES 11

H_9
Giga Guru

Try following steps:

1. Right click on header of the record and configure "Related Lists"

find_real_file.png

 

2. Select Problem->Parent and NOT Problem -> Parent Problem

find_real_file.png

3. Check the related list:

find_real_file.png

 

Please mark the answer as correct if it helped.

Thanks.

 

Thanks. 🙂

Hi, Your correct. But my objective is to have child problem relationship as you can see, The parent problem relationship is already established in the related list.

Mahendra RC
Mega Sage

Hello Kingstan,

To achieve this you can go to System Definition --> Relationships. Click on New button:

Create a new record as shown below:

find_real_file.png

Put the below script in Query with field on your record :

(function refineQuery(current, parent) {
	var parentProblemID = parent.getValue("parent");
	current.addQuery("sys_id", parentProblemID);
})(current, parent);

Go to the problem table and open any child problem record. Right click on form header go to Configure --> Related Lists

Search Parent Problem under Available section and move it to selected section and click on Save

find_real_file.png 

You will now see the Parent Problem related list which will show the Parent Problem.

Please mark my respsone as helpful/correct, if it answer your question.

Thanks

Hello Kingstan,

Just wanted to check with you, if the my above response answered your question. If yes, then please do close this thread/question by marking the appropriate response as correct.

If you still need any further help or guidance on this then please update those on this question.

Thanks

Hello Kingstan,

Just wanted to check with you, if the above response answered your question. If yes, then please do close this thread/question by marking the appropriate response as correct.

If you still need any further help or guidance on this then please update those on this question.

Thanks