Reference Qualifier not working
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-07-2024 09:55 AM
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 !
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...

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-07-2024 10:08 AM
You will need to add to your query, you last line would look like this
return "sys_idIN" + customerCallSysId