JUST USING FILTERS

All installation and configuration problems and questions

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

JUST USING FILTERS

Postby eijal » Mon Apr 02, 2007 6:53 pm

HI,
I WANT TO USE JUST FILTERS, BECAUSE IN THE FUTURE WILL BE EASY TO MANAGE THE WAY IN HOW I CAN CALL MY LEADS.
FOR EXAMPLE:
FIRST FILTER
((status like 'NEW') OR (status like 'NA') OR (status like 'B') OR (status like 'DROP'))

SECOND FILTER
(status like 'NA')

THIRD FILTER
(status like 'NI')

AND IF YOU SEE, IN ANY TIME I CAN SAY: OH, FOR THESE LISTS, THIS FILTER WILL BE GOOD. AND I DON'T HAVE TO DELETE OR ADD NEW dial status, OR CREATE, DEACTIVATE, ACTIVATE LEAD RECYCLING

BUT THE ISSUE IS WHEN I AM TRYING TO CREATE ONE OF THOSE FILTERS, VICIDIAL DOESN'T CREATE ANY FILTER JUST SHOWS: FILTER ADDED: Filter ID, BUT THERE ISN'T ANY FILTER CREATED.
PLEASE WHAT IS MY MISTAKE
eijal
 
Posts: 186
Joined: Thu Feb 08, 2007 6:34 pm

Postby eijal » Mon Apr 02, 2007 7:03 pm

sorry :oops:
I must use " and not '
example
good
(status LIKE "NEW")

bad
(status LIKE 'NEW')
eijal
 
Posts: 186
Joined: Thu Feb 08, 2007 6:34 pm

Postby chander.prakash » Fri Apr 06, 2007 7:58 pm

I think working with filter is not a good Idea because it restrict the User. One has to be aware of SQL syntax to write the filter were as selection of criteria can be done by any one, even a non techinical person can do that...

As far as your problem is concern you should use double qoute instead of single qoute as per the nice & neat example posted by eijal.

Thanx & Regards
Chander Prakash
chander.prakash
 
Posts: 46
Joined: Sat Feb 17, 2007 6:52 pm


Return to Support

Who is online

Users browsing this forum: Bing [Bot], hanidhakwani and 92 guests