Inbound CID lookup in specific lists

[GaD]

Hi all!

Does anybody know if it is possible to search for an inbound number in specific lists not all pertaining to the same campaign?

Here's my scenario:
I have three campaigns for the same client, these campaigns have pretty much the same proceedures. These are collections in different moratorium states (0 to 30 days, 31 to 60 days, 61 to 90 days, etc). All of these calls go out with a specific CID (same for all). I would like to have the system look for the CID of the caller (when an inbound call comes in) in the specific lists that belong to these 5 different campaigns. If the agent is logged in in campaign 0 and the lead of the caller pertains to campaign 1, how can I have the cal pop up to the agent with the information regardless if it is camp 0, 1, 2 or whatever. Currently I'm doing a system (whole system) lookup, but the leads may be the same at times than those of other campaigns.

Any ideas...??

Thanks.

[geoff3dmg]

There is a way to do this, it requires your Agents to look up the leads during the call though.

In 'Inbound -> Show DIDs -> <Your DID>' the setting is 'In-Group Call Handle Method'. Make sure you have it set to 'CID'. Then in the Campaign Settings set 'Agent Lead Search' to 'LIVE_CALL_INBOUND' and 'Agent Lead Search Method' to 'SYSTEM'.

Set this way, Inbound calls on your DID(s) will generate a new record in your Inbound list every time. Your Agents can then do a lead search during the inbound call and associate the call with the correct lead in the system.

[GaD]

Yeah, but it will still require the agents to do a lead search in the whole system to get the lead. The problem is that I kee getting table locks upon vicidial_list table and a HUGE ammount of pending queries waiting to write to vicidial_list while the lock (generated by the search) is in place. See my point?

[geoff3dmg]

How big is your vicidial_list table?

[GaD]

Almost three million records.

[geoff3dmg]

And your DB Server spec?