Filter Entries

On the Entries page of the Entries module, you can filter the table of existing entries. The elements bar includes a few filtering options, but you can create more complex filters by clicking Filter and using the Filter Entries window. This helps you locate specific groups of entries. For example, you could find entries for flooded residential properties in a specific city.

To filter entries

  1. In the Entries module, on the upper left, click Filter. The Filter Entries window opens.

    The Filter Entries window, with options to filter by status, forms, tasks, and applicants. There is also a checkbox to show entries from jurisdictions, a searchbox to search through text from entries, and a field queries section.

  2. Take any of these actions:

    Select the Show checkbox.

    Click Select Status and deselect any statuses you want to exclude from the filter.

    In the corresponding menus, select one or more forms, tasks, or applicants.

    Enter text into the Search Text box. This searches through all text within entries.

    In the Field Queries section, take these actions to create an expression.

    1. In the Select Field menu, select a field such as Zip Code, Category, and Estimated Cost.

    2. In the Operator menu, to select an operator such as Equals, Contains, or Greater Than.

    3. In the Value field, select or enter a value. For example, if you selected the Estimated Cost field and the Greater Than operator, you might enter a value of 100,000 to filter for entries with an estimated cost greater than $100,000.

    4. If you want to filter by multiple conditions, click Add Condition and select additional fields, operators, and values.

    5. Use the menu next to Conditions Met to select All or Any conditions.

    • If All is selected, the filter will only output entries that meet every condition you created.

    • If Any is selected, the filter will output any entry that meets any of the conditions you created.

  3. Near the top of the Filter Entries window, click Apply Filter. The Filter Entries window closes. The Entries page displays entries matching the filter.

    The bottom left displays the number of entries that match the filter.