Genesys CTI User Forum
Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: knupf on May 15, 2018, 01:36:26 PM
-
hi,
i try to add metricsto the GIM RAA QUEUE QUERY with the patch-agg.ss file.
we have two KVP's which are needed for my new metrics, R_KVP1 and R_KVP2. these KVP's are visible and populated in the IRF_USER_DATA_1 table.
my configuration in the patch-agg.ss looks like:
(alter-query QUEUE
(add (inner-join IRF_USER_DATA_CUST_1 irfuc "irf.INTERACTION_RESOURCE_ID = irfuc.INTERACTION_RESOURCE_ID"))
(add (~metric ACCEPTED_ex1 (sum(case when is-not-exists-irf then 0 when is-cust-handled-irf and is-agent-ans-td and irfuc.R_KVP1 = "'value1'" then 1 else 0 end))))
(add (~metric ACCEPTED_ex2 (sum(case when is-not-exists-irf then 0 when is-cust-handled-irf and is-agent-ans-td and irfuc.R_KVP2 = "'value1'" and not(irfuc.R_KVP2 = "'value2'") then 1 else 0 end))))
)
The metric ACCEPTED_ex1 works the metric ACCEPTED_ex2 not
does anyone have an idea?
Regards
knupf