Filters

Prev Next

Introduction

Filters in TeamTracks are a powerful way to narrow down and focus on the data that matters most. You can filter based on conditions like states, system fields, dates, or custom fields. These filters are reusable and can be applied across lists, reports, views, charts, and even buttonsโ€”making your data work smarter for you.

Creating a Filter

To create a Filter:

  • Navigate to Filters:

    • Go to the Admin Interface.

    • Open the desired Track> Filters.

    • Click "Create New" to create a new Filter, or click "Clone" to duplicate an existing one and modify it as needed.

  • Provide Filter Details:

    • Name: Enter a unique name for the filter.

    • Description: Add a brief description to explain the purpose of the filter.

  • Add Filter Rules (Clauses):

    • Click โ€œAdd New Clauseโ€ to begin.

    • A new section will appear where you can:

      • Select a Field you want to apply the filter on.

      • Choose a Condition Operator (based on the field type).

  • Set the Value Type: Once you've selected the field and condition, choose how to apply the value:

    • Literal: Manually enter a fixed value.

    • Field: Compare the selected field against another field's value.

    • Lookup by Logged-in User: Special option used to filter data relevant to the current user. Example: To show only records assigned to the logged-in user, use this type.

  • Add Multiple Rules:

    • Use โ€œAdd New Clauseโ€ or + the icon next to a rule to insert more conditions.

  • Use AND/OR Logic and Grouping:

    • Combine rules with AND / OR operators to define logical flow.

    • To group rules:

      • Check the boxes beside the rules you want to group.

      • Click โ€œParenthesisโ€ at the top to apply grouping.

    • To remove a group, click on the applied parenthesis to remove it.

  • Manage Rules:

    • Use the X icon next to any rule to delete it from the filter expression.

History Tab

All configuration changes are recorded in the History tab with detailed logs and timestamps for tracking.

Conditional Operators

Operators

Text

Date/

DateTime

Int/

Float

Choice/ Label

Multichoice

Formula/

Calculation

Relationship

Signoff

Image/

File

Equals

โœ”๏ธ

โœ”๏ธ

โœ”๏ธ

โœ”๏ธ

โœ”๏ธ

โœ”๏ธ

Not Equals

โœ”๏ธ

โœ”๏ธ

โœ”๏ธ

โœ”๏ธ

โœ”๏ธ

โœ”๏ธ

In

โœ”๏ธ

โœ”๏ธ

Not In

โœ”๏ธ

โœ”๏ธ

Contains Text

โœ”๏ธ

Not Contains Text

โœ”๏ธ

Greater Than

โœ”๏ธ

โœ”๏ธ

โœ”๏ธ

Less Than

โœ”๏ธ

โœ”๏ธ

โœ”๏ธ

Between

โœ”๏ธ

Less than or equals

โœ”๏ธ

โœ”๏ธ

โœ”๏ธ

Greater than or equals

โœ”๏ธ

โœ”๏ธ

โœ”๏ธ

Contains Option

โœ”๏ธ

Not Contains Option

โœ”๏ธ

Count Equals

โœ”๏ธ

โœ”๏ธ

Count Not Equals

โœ”๏ธ

โœ”๏ธ

Count Less Than

โœ”๏ธ

โœ”๏ธ

Count Greater Than

โœ”๏ธ

โœ”๏ธ

Contains Reviewer

โœ”๏ธ

Contains Object

โœ”๏ธ

Not Contains Object

โœ”๏ธ