User Tools

Site Tools


search_parameters

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision Both sides next revision
search_parameters [2014/10/31 11:48]
Lisa Adams
search_parameters [2014/10/31 11:57]
Lisa Adams
Line 120: Line 120:
 <WRAP todo> You can find the batch number by going to [[https://​billing.snapbill.com/​batches|Billing > Manage Debit Batches]] and check the number next to the batch you want to query.</​WRAP>​ <WRAP todo> You can find the batch number by going to [[https://​billing.snapbill.com/​batches|Billing > Manage Debit Batches]] and check the number next to the batch you want to query.</​WRAP>​
  
 +==== Search {Compound Queries ====
 +
 +SnapBill allows you to perform powerful compound search queries. A compound search makes us use more than one search parameter to generate highly detailed data. Below are a few examples of common compound searches to help you get started:
 +
 +^You want to find...^ Search Query ^
 +| All suspended clients with a fishing magazine subscription,​ USD as currency and PayPal as payment method. | state:​suspended service:"​fishing magazine subscription"​ currency:​usd payment:​paypal |
 +| All deleted clients from New York | "New York" is:dead |
 +| All active clients on debit batch number 085 with the 15th as batch day. | batch:085 data-batch_day:​15 state:​active |
 +
 +<WRAP tip> Prefixing a search with "​!"​ will exclude the parameter from the results. ​
 +Using a space in a compound search is like saying "​and"​.
 +Most SnapBill accounts have their own unique custom fields, so check with your account manager if a search does not deliver the desired result.</​WRAP>​
  
  
search_parameters.txt ยท Last modified: 2015/03/24 08:22 by Jaco van Wyk