Page History

...

...

You can build the queries of QBOE QuickBooksOE or QB QuickBooks Desktop Adapter from the Reader Section of the Process Definition. You can build the queries similar to SQL, which includes the straightforward query.

...

The following is a query to extract all Customer in batches of 100 which have been changed since the last successful run of the process.

select * from Customer where Customer.MaxReturned=500

...

Note: Refer the filters from the QBXMLQuickBooksXML, which is available in DBSync2 Conf folder. The XML Structures of all QB QuickBooks Objects are specified in this file.

...

The following is a query to extract all ItemService in batches of 100 which have been changed since the last successful run of the process.

Select * from ItemService where ItemService.MaxReturned=500

Complex query with join

select * from Invoice,Customer where Invoice.MaxReturned=500 and Invoice.ModifiedDateRangeFilter.FromModifiedDate=$last_success_run
and Invoice.IncludeLineItems=true and Invoice.OwnerID=0 join on Invoice.CustomerRef.FullName=Customer.FullName

The above query joins Invoice and Customer QBXML QuickBooksXML responses into one XML, so that the transformation engine can avoid multiple processes. This is done to optimize data flow to and from QuickBooks.