When a filter is applied in a report, which logic is executed first?

• A. Subfilter
• B. Filter
• C. Sorting
• D. Grouping

Answer: (A)

In this kind of report logic, the filtering process begins with subfilters, which are the initial pruning steps. Subfilters narrow the data set before the main filter criteria are applied. By evaluating these smaller, more specific conditions first, the system reduces the number of records that must be checked against the broader filter. After the subfilters have pared down the data, the remaining rows are tested against the main filter logic to determine the final result set. Once filtering is done, the system handles sorting and grouping, but those operations occur after the data has already been filtered down. For example, if you have a filter built with a subfilter that excludes inactive records, the engine first removes inactive rows, then applies the main filter conditions to the active subset.