To display incident records on related list on a table

[Manjushree M]

Hi Community!

I need to create a related list for a table.
The related list should contain 'incident records' which has(or related to) 'configuration item' which is present in the table form.

For example, assume there is a table to collect lists of jobs where is job title would use some configuration item.

So i need to create a related list in the form for the records of this table which displays incident related to the above configuration item(configuration item used by the respected job title).

Thanks,

Manjushree

[palanikumar · Accepted solution]

Hi,

Let me know whether my understanding is correct

You have a requirement on Job table. In form view of the Jobs you need a related list. This related list to list all incidents that has same configuration item as the current Job form.

Is my understanding correct?

[Manjushree M]

Yes. That's correct.

[palanikumar]

Then you need to create realtionship

1) Goto System Definition > Relationships
2) Click New
3) Set following values:
Name: Related Incident
Applies to table: Job table
Queries from table : Incident
Query with:
current.addQuery('cmdb_ci', parent.cmdb_ci);

Note: parent object represent Job table. Replace text cmdb after parent in above code with same field name used in Job table

Thank you,
Palani