Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Reference Qualifier not working

SandaminiM
Tera Contributor

Hi Community 😊,

I have a calls table in my PDI which is related with time_slots table. In Agent Workspace, I want to show the time slots that are added for a particular call, so that the agent can select one from them. To achieve this, I have added the following reference qualifier so that in Agent View, only the time slots that has reference to the current sys_id are displayed in the drop down list.
But it doesnt work as expected. The dropdown shows all the records in the time_slots table, not only the ones related to the currently opened call record.
Please help me to solve this !

sn_community.png
 
I have even tested the following script in Advance selection,


var customerCallSysId = current.getValue('sys_id');
if (customerCallSysId) {
return 'u_call_record=' + customerCallSysId;
}
return '';

It didn't work too 😥

Will appreciate if you can help!
Thanks in advance...

1 REPLY 1

Zach Koch
Giga Sage

You will need to add to your query, you last line would look like this

return "sys_idIN" + customerCallSysId

 

If this information helped resolve your issue, please remember to mark response correct and thumbs up to help future community members on this information, thanks!