Friday, March 2, 2012

Advanced Search: Query with OR, Write your own SQL

If the phrases in the title, "query with OR," and "write your own SQL," sound like Greek to you, then this might not be a feature you care about.  But for the few geeks among us, this is a major upgrade.  In the lower-right corner of the Query Builder screen, you will now find a link to "Advanced Search" where you can structure your own SQL statement using plain-english to reference the fields in the AddressTwo contacts and accounts table(s). 

Now, as you may imagine, this does open the possibility for syntax errors.  If you receive errors that you do not understand, please feel free to copy what you see on screen and email it to us.  As this is a brand new feature for us, we are sure to find ways to improve it.  But at a minimum, we're pleased to give our advanced users a more detailed control over the way their searches are constructed.

No comments:

Post a Comment