Executing sequential query in same filter SQL

[f_rojas]

Hello everybody,

I have a GoAutoDial 3.3 deployed as following:

1- Dialer server with Intel(R) Xeon(R) CPU E3-1230 V2 @ 3.30GHz x 8, 8 GB of RAM, 300 GB of HDD. GoAutoDial for 64 bits system installed from DVD.
2- Data Base server with Intel(R) Xeon(R) CPU E5-2620 v2 @ 2.10GHz x 12, 24 GB of RAM, 300 GB of HDD. GoAutoDial for 64 bits system installed from DVD.

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 in the same filter.

For better explanation I describe for you the problem:

An enterprise needs to call from a list with 500000 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 in the same filter?

Thanks in advance.

[mflorell]

You would have to use 3 lead filters because what you are trying to do is a change in order, not a filter. So use the first one and then when you run out of leads do the second and so on.

[f_rojas]

OK Matt,

Thanks in advance for your quick reply.

Then, exist any option to automatically apply multiple filters to a same campaign?

Greetings.

[williamconley]

And please do not double-post:

viewtopic.php?f=4&t=33515&p=114090#p114090

[DomeDan]

you can write multiple statements in one filter with the use of parentheses, they can get a bit complex and its easy to make mistakes.
but what matt means is that you write 3 filters and change the campaign to use them one at a time when its time to change city to call.

an other way is to split the list in 4 parts
where first list got leads with city %OGOT% and second with %EDELL%, third with %EREIR% and the forth with the reset.
then just activate list by list in the order you want

[williamconley]

you can write multiple statements in one filter with the use of parentheses, they can get a bit complex and its easy to make mistakes.
but what matt means is that you write 3 filters and change the campaign to use them one at a time when its time to change city to call.

an other way is to split the list in 4 parts
where first list got leads with city %OGOT% and second with %EDELL%, third with %EREIR% and the forth with the reset.
then just activate list by list in the order you want

right, but then the filter isn't determining order, it's happening manually. it's not a question of being able to have more than one "where" clause member, or whether they can be nested, but whether the filter can cause one group of leads to be dialed First. It can't. It only determines availability. The "where" portion of the sql statement. It's not in any way related to the "order by" portion of the sql statement.

[f_rojas]

And please do not double-post:

viewtopic.php?f=4&t=33515&p=114090#p114090

OK Willian,

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.

[williamconley]

That's a very good solution.

We've also had clients put the full name in the first name field (and relabel the field "full name") and then put a "sort order" value in the last name field (and relabel it to "Sort" and ---hide--- it), and then set the campaign list order to "last name".

Good post-back by the way