How to customize queries ?
- Custom (Custom Queries)
By selecting the custom query you can write your own query to get data
You have to write your query in the "Custom Query" text box. Custom queries are like SQL that allows user to select specific fields and apply conditions on the result set.
A sample custom query is
SELECT * FROM Customer WHERE GivenName = 'greg' STARTPOSITION 10
Note: Our add-on also supports selecting specific fields using custom query. For example - the below query brings only Name and Classification fields from Account
SELECT Name, Classification FROM Account
Refer QuickBooks documentation for more details on custom queries.