Call menu and routing calls

[dzigi]

Hi there,

I have question about following scenario.
I have cities : A,B,C,D and E. Calling code for this cities are : for A ->22,B->23,C->24,D->25 and E->26(after calling code there is phone number).

I am preparing Call menu with pre-recorded messages for all of this cities.DTMF for this city press 1,for other press 3 etc.
I want also to have interception (in SQL-so, if I have call from city A(22) then route this call to group of messages for this city).This will be only for land line calls.

I read new features (upgrades from 2.4 to 2.6)...

7. Added ability to qualify callers before they go through a Call Menu by using
a SQL fragment(like in Filters) that you define in a Call Menu. Must be
enabled in System Settings. Calls must be passed from an outbound
campaign or an in-group.

I saw for Call menus that there are 2 fields :Custom Dialplan Entry and Qualify SQL .
Can I do some sql in this fields something like: if callerID like '22%' then route to 'messages for city A' ...or I miss point of this new futures,


thank you for understanding,I hope this will help others too,

Ivan



Vicibox 5.0 from .iso | Vicidial VERSION: 2.8-408a BUILD: 130711-2208 | Asterisk 1.4.21.2| Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation | Intel |

[williamconley]

sounds more like that feature will qualify/disqualify someone from entering the menu which would bounce them to a different (single) location. you could then (in theory) create a cascaded menu system where if they were "not" this city, reject to the next menu. in the end there would be one menu for each city.

but i'm guessing. have not looked at this feature yet.

[mflorell]

Yes, that's what Qualify SQL is for, but the call has to be assigned a lead_id before it will work. The easiest way to do that is to send the call through an Always Closed In-Group and set the Transfer CID field in the ingroup to CLOSERCUSTOMER, then have the after hours action go to the call menu that you want.

For a phone number prefix filter you would want something like this in your Qualify SQL:

(phone_number LIKE "22%")

[dzigi]

Thank you Matt,

I will test everything and let you know results,this should be useful for other things also...