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
Previous revision
search_parameters [2014/10/31 11:48]
Lisa Adams
search_parameters [2015/03/24 08:22]
Jaco van Wyk [Search {Compound Queries]
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