Query Filters

Query Filters are used to filter out specific data in a database. The data can be filtered by adding and deleting a filters.

open-filter-dialog

Prefer watching over reading? Check out this video for adding query filters to a dataset:

Add filters

  1. To add a filter, Click on the Add icon.

    add-field-filters

  2. Dataset fields are listed in the first drop-down list, choose the necessary field from the drop-down list.

    add-expression

  3. Operator types are listed in the second drop-down list.

    operators-in- filters

  4. In the Value, enter the value to be filtered in the dataset fields.

    pass-value-in- filters

  5. Click on Include as parameter checkbox, will include the query parameters.

    include-paramter

  6. Click on Add icon again to add the second row. You can see a dropdown on the top of the second row

    and-condition-filter

  7. Choose AND or OR condition from the dropdown and with that you can filter out data based on the query condition

    and-or-dropdown

  8. To add multiple filters, follow steps 1 - 5.

    add-with-multiple-filter

  9. Click OK and select Execute icon as shown below to view the filtered data based on the condition in the data preview.

    datapreview

  10. When save the dataset, the query parameter will automatically included in report parameter as shown below.

    report-parameter

Remove Filters

Click Delete icon in the right corner to remove the respective filters.

delete-filter