Filter data in tables

You can use filters to display only the jobs or deliveries you want to see in a table.

For example, you can filter data by driver, status, or date to quickly find specific information.

Filters allow you to temporarily hide certain data without modifying your schedule.
 

In which tables can filters be used?

Filters are available in the following tables:

• Plan > Cancelled deliveries
• Plan > Deliveries basket
• Organize > List of deliveries
• Analyze > Delivery report

How to apply a filter

To filter data in a table:

1. Click the Filter button.
2. Select the column you want to filter.
3. Choose the condition and select the value you want to display.
4. Click Apply.

The table will then display only the data matching the selected filter.
 

How to apply multiple filter conditions

You can combine multiple filters to refine your search.

To add another condition:

1. Click Filter again.
2. Select the column, condition, and value you want.
3. Then choose one of the following options:

• All these conditions (AND): the data must meet all filters.
• One of these conditions (OR): the data must meet at least one filter.

Example using the AND condition

Display jobs that are planned, pending, and confirmed for the driver John Smith:

1. Add a filter State → Planned, Pending, Confirmed.
2. Add a filter Driver → John Smith.
3. Select All these conditions (AND).

The table will only display jobs that match both criteria.

Example using the OR condition

Display:

• jobs that are planned, pending, or confirmed
  or
• jobs assigned to the driver John Smith

1. Add a filter State → Planned, Pending, Confirmed.
2. Add a filter Driver → John Smith.
3. Select One of these conditions (OR).

How to save a filter

If you frequently use the same filters, you can save them for quick access later.

To save a filter:

1. Apply the desired filters.
2. Click the Save button.
3. Enter a name for the filter.
4. Click Confirm.

Your filter is now available under My Filters.

💡 You can modify a saved filter at any time.
To do this, select the filter, add or remove conditions, and save the changes.
 

Available filters

Depending on the table, you can filter data by:

Delivery information

• Open date
• Due date
• Duration
• Time slot
• State
• Cancellation reason
• Location of delivery
• Comments
• Done comment
• Delivery external ID
• Capacities

💡 The done comment corresponds to the comment added when a job or delivery is validated or cancelled.

☝️ Note: When you filter jobs by states, the “Cancelled” states also includes jobs that have been rescheduled.

Resources

• Driver
• Forced driver
• Skill
• Sector

Customer information

• Customer
• Customer external ID

Other information

• Custom fields

Need Help?

If you have any difficulty using filters or if you have a question, our support team will be happy to assist you.

You can contact AntsRoute at:
📧 contact@antsroute.com