Customise query

How to customise queries ?

  • Custom(Custom Queries) Source Type

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.