- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-01-2022 05:09 AM
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?
Solved! Go to Solution.
- Labels:
-
Problem Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-02-2022 11:24 PM
Hello Kingstan,
To achieve this you can go to System Definition --> Relationships. Click on New button:
Create a new record as shown below:
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
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-01-2022 05:35 AM
Try following steps:
1. Right click on header of the record and configure "Related Lists"
2. Select Problem->Parent and NOT Problem -> Parent Problem
3. Check the related list:
Please mark the answer as correct if it helped.
Thanks.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-02-2022 10:13 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-02-2022 11:24 PM
Hello Kingstan,
To achieve this you can go to System Definition --> Relationships. Click on New button:
Create a new record as shown below:
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
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-03-2022 01:13 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-04-2022 09:01 PM
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