Running multiple SQL queries on the same filter.

[f_rojas]

Hello everybody,

I have a VICIdial VERSION: 2.9-441a, BUILD: 140612-1628, © 2014, deployed as following:

Dialer and Data Base server with Intel(R) Xeon(R) CPU E3-1230 V2 @ 3.30GHz x 8, 8 GB of RAM, 300 GB of HDD. VICIdial for 32 bits system installed from scratch.

This is my question:

I need to know how do i to build a "Filter SQL" with two or more queries and do that these run sequentially one after other (or one by one) in the same filter.

For better explanation I describe for you the problem:

An enterprise needs to call from a list with 5000 leads, but requires automatically dial all the leads which city field contains %OGOT% at first, then dial the leads which city field contains %EDELL%, and finally dial the leads which city field contains %EREIR%.

For example:

city LIKE "%OGOT%"
city LIKE "%EDELL%"
city LIKE "%EREIR%"

How do I to build a Lead Filter with two or more queries and do that these run sequentially one after other (or one by one) in the same filter?

Thanks in advance.

[williamconley]

You don't. The order is controlled by a different field of the campaign (outside the filter). So you could set the filter to allow ALL of the cities (that's the job of the filter, to make them available or hide them) and then look at the List Order setting for options for depleting one city before starting the next.

Please remember to post your installation method with version (ie: full name of the install cd).

[f_rojas]

OK William,

Thanks in advance for your quick reply.

In respect to installation method, I've installed VICIdial from scratch but no from CD or DVD.

Now, In respect to your answer, can you give me an example please?

It would be:

city
in("%OGOT%","%EDELL%","%EREIR%")

My goal is that all the leads refered by city field are strictly dialed in this order: "%OGOT%" at first, "%EDELL%" in second place and "%EREIR%" at last.

Thanks and Greetings.

[williamconley]

If you installed from scratch, you still began with an .iso image for an OS (which has a version) and likely used instructions for the rest from a web page. Include those two items in your system description as your installation method. And (just to be funny), it may be a good idea to explain why you did NOT use Vicibox 6.0 (or another .iso installer) to perform your installation. Sometimes it helps to understand your situation.

As i said: ORDER is not controlled by the filter. You can not control the order of the calls in the filter.

Also, I don't believe you can use "like" patterns in an "IN" for mysql. But a little mysql research should resolve that issue.

[f_rojas]

OK William,

Excuse me please, but it wasn't my intention, I've deployed 2 call centers with similar drawbacks.

However, I found an alternative solution which consist of organizing by city then by rank (by adding a secuential number here) and then dial phone numbers by the rank field up.

This solution was the better in my humble concept.

Thanks in advance.