SpitFire Help Desk



SQL Statements

Query List Max Retry- After defined call count has been reached, records in the list will no longer rework/ redialed in assigned campaign only.
 and CallCount < 3

Query By State- Dial by defined state.
and State = ‘TX’

Query States- Dial by multiple states.
and State in ('TX', 'CA')

Query Eliminate States-  No Dial multiple states.
and State not in ('TX', 'CA')

Query Blank Records- Do not dial blank records.
and Voicephone <> ‘’

Query Custom Field Alpha:
and (convert(varchar(10),(convert(xml, XMLData)).query('for $f in /Fields/Field
where data($f/@Name)="CustomFieldName"
return data($f/@Value)'))) = 'CustomField'

Example: Search for custom field name "Gender" Looking for "Female"
and (convert(varchar(10),(convert(xml, XMLData)).query('for $f in /Fields/Field
where data($f/@Name)="Gender"
return data($f/@Value)'))) = 'Female'

Query Custom Field Numeric:
and (convert(float,(convert(varchar(10),(convert(xml, XMLData)).query('for $f in /Fields/Field
where data($f/@Name)="CustomFieldName"
return data($f/@Value)'))))) > Amount

Example: Search for Custom field "Salary" looking for "27000"
and (convert(float,(convert(varchar(10),(convert(xml, XMLData)).query('for $f in /Fields/Field
where data($f/@Name)="Salary"
return data($f/@Value)'))))) > 27000



Related Articles

No related articles were found.

Attachments

No attachments were found.

Visitor Comments

Article Details

Last Updated
15th o September, 2015

Would you like to...

Print this page  Print this page

Email this page  Email this page

Post a comment  Post a comment

 Subscribe me

Subscribe me  Remove from favorites

Remove Highlighting Remove Highlighting

Edit this Article

Quick Edit

Export to PDF


User Opinions

No users have voted.

How would you rate this answer?




Thank you for rating this answer.

Continue