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.