Hi Team,
We have the records in OCS with chain records. [Example, One Customer have 3 numbers Mobile (chain_n =0), Home (chain_n =1), and Work(chain_n =2)]. In the Calling list field, we have User defined field as “DispositionCode” and it has been updated from the AgentDesktop.
Here, we are facing the problem. The issue is,
-
The Agent has been received one of the Chain Records [i.e. chain_n=0].
-
He disposed the call as “No Answer”.
-
The OCS has been updated the record in the calling list as,
Record Type Chain_n Record_Status Call_Result DispositionCode
Mobile 0 Updated Answer NoAnswer
Home 1 Updated Answer
Work 2 Updated Answer -
We want to rechurn the No Answer disposition data on next day.
-
If we put the query as "DispositionCode IN (‘NoAnswer’), then we are getting the value of Chain_n =0 only.
We need to get the all the chain records of the particular customer. If you have any alternative suggestion for the same, please provide me.