Jump to content
BigMikeyVegas

R11.2 - Stored Query to show transfer from group

Recommended Posts

We are making changes to our queues and we want to provide certain end users (Upper Mgmt) a way to view calls tranferred from old queue to new queue. Is there a query that will provide this information?

Share this post


Link to post
Share on other sites

Hi,

there is no way to create a query that will do that, because the transfers only stored in the act_log as a String. There is no existing history.

In my opinion you need:

1. A counterfield (z_count_transfers)

2. Spelcode with a trigger  --> EVENT("UPDATE") && active == 1 && group { } . The code should count the transfers and incrementing z_count_transfers

3. Stored query (example):   type = \'R\' AND open_date > StartAtTime(\'TODAY\') AND z_count_transfers > 0

But that will work for transfers generally....

 

Edited by henning1518

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...