For this example, let's build a query that will only show records like this:
Incidents assigned to me that are not closed or cancelled, sorted by when they were last updated (oldest first).
First, let's break this down into components:
- Assigned to is me (the current user, whoever it may be)
- State is not either closed or cancelled
- Sort by updated (high-to-low)
You should be looking at two drop-down fields and one string input field, arranged in a row, like this:
Just like in math and programming, these three fields each represent a component of a condition criteria that looks something like <Field> <Operator> <Value>.