Page 1 of 1

JUST USING FILTERS

PostPosted: Mon Apr 02, 2007 6:53 pm
by eijal
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

PostPosted: Mon Apr 02, 2007 7:03 pm
by eijal
sorry :oops:
I must use " and not '
example
good
(status LIKE "NEW")

bad
(status LIKE 'NEW')

PostPosted: Fri Apr 06, 2007 7:58 pm
by chander.prakash
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