Sql Filter

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Sql Filter

Postby davide.filippi » Thu Sep 07, 2017 9:34 am

Good day all
I'm setting up an sql filter that inhibit call to prefixes "350" or "370".
In the dialplan I have the following
...
exten => _12339X. dial ${exten:3}
...

so if I manually call 3501234567 it appears as 123393501234567
When this extension is exhamined by the sql filter, how it will be appears?
123393501234567 or 393501234567?

Thanks all
ViciBox.x86_64-4.0.1.iso from dvd | Vicidial VERSION: 2.8-403aBUILD: 130510-1350 | SVN Version: 1983 | Cluster: 4 web+dialer (2 Dell Poweredge 1950 - 1 Dell Poweredge 2950; 1 Dell Poweredge R610); 1 db on Dell Poweredge R710 | no extra hw/sw
davide.filippi
 
Posts: 85
Joined: Thu Nov 10, 2016 8:45 am

Re: Sql Filter

Postby williamconley » Thu Sep 07, 2017 10:40 pm

The sql filter will see the value as it appears in the vicidial_list table. If you modify the lead and look at the phone number field, that's what sql will see.

Good job posting your specs!
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Sql Filter

Postby davide.filippi » Sat Sep 09, 2017 3:25 am

Hi,
thank you for the reply
ViciBox.x86_64-4.0.1.iso from dvd | Vicidial VERSION: 2.8-403aBUILD: 130510-1350 | SVN Version: 1983 | Cluster: 4 web+dialer (2 Dell Poweredge 1950 - 1 Dell Poweredge 2950; 1 Dell Poweredge R610); 1 db on Dell Poweredge R710 | no extra hw/sw
davide.filippi
 
Posts: 85
Joined: Thu Nov 10, 2016 8:45 am


Return to Support

Who is online

Users browsing this forum: Google [Bot] and 62 guests