Custom related list

[ServiceNow10sun]

Hi All,

i have created a related list in change request table called agenda which is table cab_agenda_item.

I have created this customer related list using relationships table where in applies to table is change_request and queries table is cab_agenda_item . 

I need the relavant agenda item in the change record but currently it is showing all agenda item . 

[Ehab Pilloor]

Hi @ServiceNow10sun,

Write Query on Encoded Query in the Query with script field in the relationship record depending on the conditions you want to set for the records to be filtered in the related list.

Use this video as reference: https://www.youtube.com/watch?v=TPalQqFxlsA

If you found my response helpful, please mark it as Solution and Helpful.

Thanks and Regards,

Ehab

[siddharth26 · Accepted solution]

Hi Sunita,

Please add in the script

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

Try this.

thanks

sid

[ServiceNow10sun]

Thank you it worked 

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