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
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!