Filters and the query builder

Filters narrow a grid to the rows you care about, and pplCRM never hides what it is doing: a small funnel marks the filter row above the grid, every active filter appears as a chip there with a count of how many rows match, and dashed entry pills sit inline. Remove one chip, or Clear all at once.

Quick filters: the dashed pills

• + Add filter: pick a field, an operator, and a value; the condition lands as one removable chip.
• Tags: check one or more tags; checked tags combine with OR (match any) and land as a single removable chip.
• Issues: same mechanics as tags, for issue interests.
• Lists: show only the members of one list.

Per-column filters

Advanced Filters opens a filter row under the column headers: type a condition per column (a name fragment here, a city there), and the grid narrows to rows matching all of them.

The query builder

When per-column matching is not expressive enough, the Advanced Query Builder composes full conditions with and/or groups: “city is Springfield AND (donated this year OR volunteers)”. It is the same builder that powers dynamic lists, so a query you like can become a list that maintains itself.