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
