QuickBooksV2 (On-Premise) Connector Guide > Data Filters > Advanced Filters
  

Advanced Filters

The advanced data filers help you to further filter data by offering more customizable and multiple filtering options at once.
In data filters, all the objects might not support certain filter fields listed. All the available filter fields are not filterable. Refer Filter-Fields to know more about the supported filter fields.
Note: When you select a filter field that is not filterable, you will know the field is not filterable only after running the DSS task.
    1. In Data Filter dialog box, click Advanced.
    2. The Advanced Data Filter dialog box appears.
    3. Enter the Filter Expression you wish.
    4. Click OK.
You can apply multiple filters at one instance, as show in the above figure.
For example, Name Like ‘%Accountant%’ AND TimeModified<=’1/25/2014’ AND ID= ‘8000002F-1390458673’
The above mentioned filter expression contains three specific filters separated by conjunction filter AND.
Note: Only “AND” conjunction filter is supported by advanced data filters.
Note: “OR” is not supported by advanced data filters.
The supported operators by advanced data filters are