How to use Filter

[smead]

Is there a resource that shows example scripting, or lays out a framework? I would like to use this to customize time zone calling mainly, but it appears a little intimidating at the moment.

[williamconley]

it's a mysql query addition.

to call only the state of new jersey, for instance, you would use:

upper(state)='NJ'

or for multiple states

upper(state) IN ('NJ','WI','FL')

More complex queries can slow your system. Always check the campaign before and after for available leads. If the number goes UP instead of DOWN, you broke something. If it goes down more than you were expecting ... once again, you may have broken something.

Avoid use of "OR" unless you are very familiar with mysql and remember that the query addition you are making is NOT the only clause in use. There are already some "where" clauses in place and you are adding new ones. An "OR" could cause the system to ignore the previous where clauses and break functionality.

The system already has the ability to dial according to time zone order in the list order field of the campaign.

[smead]

Yes I've been experimenting with the list order. I thought that was my answer at first, but it ends up just calling either west coast leads all day or east coast leads all day, with the exception of 1 or 2 hours when the call times restrictions kick in. I need it to be a little more dynamic, starting with EST and tapering down to PST as the day progresses.

[smead]

My other thought would be to somehow exclude certain hours of calling. For example, no calling during local hours of 8-9, 1145-1315, 1630-. That would probably be simpler, wouldn't it?

[williamconley]

Assuming you want to apply it to the Local time of each lead, it may work. But do be careful with serverload when you begin to create seriously complex filters.