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?
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
Below is the configuration:
Name: Name of your choice. This will appear as label on the related list.
Parent: Problem
Child: Problem
Script:
(function refineQuery(current, parent) {
// Add your code here, such as current.addQuery(field, value);
current.addQuery('sys_id', parent.parent);
})(current, parent);Open Problem form, Configure Related list and add "Custom Problem" [name of custom relations we built above].
Now the parent problems will appear on the child problem.
Please mark this helpful/correct, if applicable.
