Page 1 of 1

VICIdial List filter based on 'status' field.

PostPosted: Mon Apr 27, 2015 4:52 pm
by 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.

I've performed several list filters based on some fields and this's running perfectly. But when I create a filter based on 'status' field, this not flings any data after to clic on TEST ON CAMPAIGN. However, when I do the query directly on the database, this results in 11 leads.

For example:

This is the code in the Filter SQL canvas:

phone_code in('57') and status in('PROSP')

When I do clic on TEST ON CAMPAIGN this is the result:

Show Dialable Leads Count -

CAMPAIGN: cc151
LISTS: '101090'
STATUSES: N NA PROSP XDROP DROP B NEW -
FILTER: PROSPECTOS
CALL LIMIT: 0 CALL TIME: LV-8am-5pm

With Filter:
This campaign has 0 leads to be dialed in those lists

Without Filter:
This campaign has 2345 leads to be dialed in those lists
==============================================================================================
==============================================================================================
However, this is the result for the query directly from the database:

mysql> select count(*) from asterisk.vicidial_list where list_id='101090' AND phone_code in('57') AND status in('PROSP');
+----------+
| count(*) |
+----------+
| 11 |
+----------+
1 row in set (0.00 sec)

==============================================================================================
==============================================================================================
This is my question:

How do I to create a list's filter based on 'status' field?

Thanks in advance.

Re: VICIdial List filter based on 'status' field.

PostPosted: Wed Apr 29, 2015 10:09 am
by f_rojas
Hello,

I've tried making the filter as follows:

status like 'PROSP'

but the response is same:

With Filter:
This campaign has 0 leads to be dialed in those lists

Without Filter:
This campaign has 2345 leads to be dialed in those lists

Any sugestion please?

Thanks in advance.