Configure : Parent/Child relationship for Problem table

Kingstan M · ‎09-01-2022

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?

Mahendra RC · ‎09-02-2022

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

View solution in original post

Mark Manders · ‎09-03-2022

The technical solution has been given, but why do you need that relationship? A problem is a cause, or potential cause, of one or more incidents. Problems can be raised in response to a single significant incident or multiple similar incidents. They can even be raised without the existence of a corresponding incident. There is 1 problem to investigate/fix the cause an incident (or multiple incidents) and prevent it from happening again. How can you have multiple Problems as parent/child records? In case 2 Problems are related enough to have that relation ship, because they exist, one should be closed, because it should not have been opened in the first place (there was already a problem there).

How is your (or your client) using the Problem process?

Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

Kingstan M · ‎09-04-2022

Indeed, We needed to relate IF any problem is related to x-Problem. Then when the form shows the double-way of showing the related PRB. So, That is the goal.