How to write script on catalog,category ,item,request,requested item,task

[Sonali16]

Hi Expert,

Thanks in advance and sorry for my english.

My question is while writing the script on ,sc_catalog, sc_category, sc_cat_item ,sc_request, sc
_req_item, sc_task table how to apply add query .

how to match the query between to table.

For EG:

var grItem = new GlideRecord('sc_req_item');

grItem.addQuery('sys_id',current.parent);

or

 var gr = new GlideRecord('sc_cat_item');
        gr.addQuery('sys_id', current.sys_id);

in this script grItem.addQuery('sys_id',current.parent);  and gr.addQuery('sys_id', current.sys_id);

 I dont understand how to apply this

Please explain me , I will really appreciate .

[shloke04]

Sure. Say for example let us take Incident and Incident task as Two form shown below:

Incident Record: 

Incident task:

So look at above screenshot, in Incident task you will see Incident field highlighted in Red which is holding the value of Incident record, so this way you can identify on child record by going to child table and see which field is referring back to Parent table.

In this case it is Incident. There can be possibility that the field which is referring to Parent record is not added to form layout of child table form , so this does not mean that it will not exist.

Navigate to the Dictionary module and give filter as Table contains Child Table Name and then check if there are any reference field which referrs back to parent table or not. Look at screenshot below:

So these are ways to identify. Let me know if you are stuck.

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

[Sonali16]

Thank you so much shloke, for valuable time and effort.