In certain scenarios it may be required to set the order that filtering conditions appear in the SQL WHERE clause. This can be done by rearranging the filtering definitions in the Report Filter itself. Filtering conditions higher up in the Report Filter will be placed in the SQL before filtering conditions lower down. As an example, consider the following SQL which has filtering conditions on both Year and Country:
Note that the Year filtering condition comes before the Country filtering condition in the SQL. This is because the Year filter is placed higher in the Report Filter than the Country filter as seen in the following screenshot. The order can be rearranged by right-clicking a condition and using the "Move Up" and "Move Down" options as seen in the screenshot as well.
