hi all,
what I want to do; Detecting calls forwarded to a different agent group without being transferred to IVR by entering the call's 1001,1002,1003 VDNs.
VDNs I want to track (dispvdn): 10001,10002,10003
IVR Transfer number (dispvdn):10010
Agent Transfer group number (dialed_num): 20002. Table dimensions are as follows;
calling_pty,
firstvdn,
dispvdn,
dialed_num,
start_date,
end_date,
callid(uniqueid),
anslogin,
origlogin,
transferred
dispsplit.
accordingly; 12121212 call with callid does not meet the criteria. However, the call 12131215 provides. how can i get this.
your help is appreciated
| callingpty |
firstvdn |
dispvdn |
dialed_num |
start_date |
end_date |
callid |
anslogin |
origlogin |
transferred |
dissplit |
| 9,05003E+11 |
46900 |
10001 |
5005 |
19.11.2021 13:16 |
19.11.2021 13:30 |
12121212 |
44912 |
- |
1 |
60 |
| 44912 |
10010 |
10001 |
10010 |
19.11.2021 13:18 |
19.11.2021 13:30 |
12121212 |
42802 |
44912 |
1 |
11 |
| 9,05304E+11 |
46900 |
40004 |
5004 |
19.11.2021 13:18 |
19.11.2021 13:19 |
12131214 |
44000 |
- |
0 |
20 |
| 42802 |
20002 |
48999 |
20002 |
19.11.2021 13:18 |
19.11.2021 13:30 |
12121212 |
42491 |
42802 |
0 |
6 |
| 9,05003E+11 |
46900 |
10002 |
5004 |
19.11.2021 13:18 |
19.11.2021 13:40 |
12131215 |
43300 |
- |
1 |
60 |
| 43300 |
20002 |
48999 |
20002 |
19.11.2021 13:18 |
19.11.2021 13:40 |
12131215 |
43302 |
43300 |
0 |
6 |
