Hello I am fairly new to Vicidial and my boss has asked me to set up a filter that will pull Leads out after they have been dialed 7 times. We are not allowed to dial numbers from certain campaigns more that 7 times. My question is first is this possible and second i am unfamiliar with SQL and i know this is a very sensitive area to mess with a database can anyone help me out with this please?
Chris
SQL Filter Queries
Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N
4 posts
• Page 1 of 1
SQL Filter Queries
by Cj4life24 » Tue May 08, 2012 9:56 am
cj4life24
ViciBox Redux 3.1.9
VERSION: 2.4-316a
BUILD: 110531-2009
Single Server
OpenSUSE Server 11.2
Vspace from NComputing for L130 Thin Clients
Intel I5-2310 Quad Core
ViciBox Redux 3.1.9
VERSION: 2.4-316a
BUILD: 110531-2009
Single Server
OpenSUSE Server 11.2
Vspace from NComputing for L130 Thin Clients
Intel I5-2310 Quad Core
- Cj4life24
- Posts: 43
- Joined: Mon Apr 16, 2012 8:34 am
Re: SQL Filter Queries
by boybawang » Tue May 08, 2012 11:04 am
called_count > 7
Vicidial Installation + Configuration + Support + Custom Development
Download my ebook on installing vicidial for free http://download.vicidial.com/ubuntu/VIC ... 100331.pdf
skype: deodax.cordova@gmail.com
m: +639172063730
Download my ebook on installing vicidial for free http://download.vicidial.com/ubuntu/VIC ... 100331.pdf
skype: deodax.cordova@gmail.com
m: +639172063730
- boybawang
- Posts: 989
- Joined: Sat Nov 14, 2009 1:18 pm
- Location: Dumaguete City, Negros Oriental, Philippines
Re: SQL Filter Queries
by mflorell » Tue May 08, 2012 11:19 am
The new campaign feature "Call Count Limit" in svn and branch 2.4 now allows you to do this without using a filter.
- mflorell
- Site Admin
- Posts: 18387
- Joined: Wed Jun 07, 2006 2:45 pm
- Location: Florida
Re: SQL Filter Queries
by Cj4life24 » Tue May 08, 2012 3:23 pm
thank you i guess i should have posted my version and system info
VERSION: 2.4-316a
BUILD: 110531-2009
© 2011 ViciDial Group
And the called_count > 7 is great but i thought about one more thing. I can only call leads in this campaign 7 times so ultimately i need to have the leads call 7 times pulled out..the kicker now is that if in those first 7 calls if one was dispositioned as a call back then i can call them as many times as i want is there a way to take out all leads call 7 times except the ones who's status is a callback
Chris
VERSION: 2.4-316a
BUILD: 110531-2009
© 2011 ViciDial Group
And the called_count > 7 is great but i thought about one more thing. I can only call leads in this campaign 7 times so ultimately i need to have the leads call 7 times pulled out..the kicker now is that if in those first 7 calls if one was dispositioned as a call back then i can call them as many times as i want is there a way to take out all leads call 7 times except the ones who's status is a callback
Chris
cj4life24
ViciBox Redux 3.1.9
VERSION: 2.4-316a
BUILD: 110531-2009
Single Server
OpenSUSE Server 11.2
Vspace from NComputing for L130 Thin Clients
Intel I5-2310 Quad Core
ViciBox Redux 3.1.9
VERSION: 2.4-316a
BUILD: 110531-2009
Single Server
OpenSUSE Server 11.2
Vspace from NComputing for L130 Thin Clients
Intel I5-2310 Quad Core
- Cj4life24
- Posts: 43
- Joined: Mon Apr 16, 2012 8:34 am
4 posts
• Page 1 of 1
Who is online
Users browsing this forum: Google [Bot] and 92 guests