Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 87 Next »

Filtering is a way to limit the number of lineitems shown in the list. At any given point the database contains potentially thousands of records of lineitems so in order to make tracking more efficient, it is necessary to apply one or more filters to make it easier to find the right lineitems.

📚 CONTENT:

Understanding filters

Simple and complex filters

Filters can be very simple, ie. to show lineitems with a certain status. They can also be extended to include two or even more parameters such as linetimes with a certain status and a deadline tomorrow.

Filter can also be combined so two filters actually work as one.

Filtering lingo

When creating filters, it can be useful to think of these as a structured way to tell the database what you want to see.

So in a human language at statement like “show me all lineitems that have the status “booked” would translate into filter lingo as “Status equals Booked”.

Extending the statement to “show me all lineitems that have the status “booked and the deadline is tomorrow” would, in filter terms, look something like “Status equals Booked” AND “Deadline is tomorrow”.

Filtering logic

The last sentence above is an example of a filter that combines to individual statements. In this case the connector is the “AND” meaning that both filters apply to the lineitems shown in the list.

It is also possible to define a filter where either the first “OR” the second statement apply to the found lineitems. “AND” and “OR” are the so-called logical operators that define how filters can be combined.

There are more ways to apply filtering logic, and these are presented to the user as the filters are being created.

Field types

Data in the X1 database is organised in fields and each field has a certain type. When creating filters, X1 automatically suggest filter options based on the field type:

Field type

Field name (example)

Filter options

Text fields

Customer name

“Equals” (exact match), “Contains” (contains the text), “Starts with” (text starts with) etc.

When entering text in the filter field, X1 automatically suggest possible hits.

Date fields

Publication date

A calendar to select a specific date or options for relative dates, date intervals or specific weekdays.

Number fields

Width

Numeric operators like “Equals”, “Greater than”, “Smaller than” etc.

Saving filters

Filters can be saved, modified and shared with member of other groups. This is handy if you have created a great filter that more users will need. We’ll discuss how filters are saved and shared below.

Filtering by chips

In X1 filters are represented by one or more chips in the search bar above the list. Filters are color coded as follows:

Chip color

Purpose

(blue star) Orange

Advanced searches

(blue star) Blue

Saved filters

(blue star) Purple

Filters inherit from a Workbench

(blue star) Black

System created filters (filter that automatically created by the system depending on workspace, selection etc.

(blue star) Grey

Quick searches

X1 Filter Chips multiple colors.png

HINT: Filter on this value
Most fields in the list offer the possibility to create a advanced filter easily. Simply right click on the data you want to filter by and chose search by this value from the context menu.

Shortcut: PC: ALT + mouse click MAC: OPTION + mouse click

X1 filter from context menu or shorcut.mov

Working with filters

Advanced Search ( orange chip (blue star) )

When clicking once in the search bar you’ll see a drop down menu with a list of saved filters (if any) and all other possible advanced searches (orange chips) which can be added separately into the search bar:

advanced filter drop down.png

HINT: Press ESC to close 'Advanced Search” drop down menu.

Advanced searches are added to the search bar as orange chips and can have multiple functionality and search operators depending on which advanced search that is selected.

Two examples:

X1 Advanched Search ex1.pngX1 Advanched Search ex2.png

INFO: If you use multiple advanced searches they are applied with an “AND” operator between them. Therefore it is only possible to add one specific advanced search pr. workspace. If you want to use “OR” as an operator you have to create a saved filter for this purpose.

Saved filters ( blue chip (blue star) )

A saved filter is shown in the search bar as a blue chip and can contain a combination of multiple advanced searches. This can be a benefit when ie. filtering doesn’t take to much space up in the search bar and/or they can contain complex conditions by using “OR” as an logical operator instead of the default “AND”.

How to create a saved filter

Go to the ‘Filters’ menu from the three dots menu to the right:

X1 Filters menu.png

Chose ‘Add new’ to create and name a new saved filter and click on the blue arrow to add it into the Filters list:

X1 filter add new.pngX1 filter naming.png

and then add the advanced searches into it:

X1 filter adding advance searhes.png

When you’re done you will need to click ‘Publish’ to save it:

X1 filter publish.pngX1 Create new filter.mov

INFO: If you use multiple advanced searches, they are applied with an “AND” operator between them. Therefore it is only possible to add more than one specific advanced search pr. search field in the filter. If you want to use “OR” you’ll need to add a condition.

HINT: The height of the filter menu drawer can be adjusted to make it possible to see the user interface in the background. This way you can see the filter results on the fly when creating a new saved filter.

If you want to make changes to a saved filter you can either go back to the filter menu or simply just double click the blue chip in the search bar on the saved filter you want to change. The chip opens in a drawer displaying only that saved filter. After you’ve made the changes you click ‘Publish' and the filter is updated.

X1 make changes to a saved filter.mov

HINT: To add one or more saved filters to the search bar, click in the check mark field to the left of the filter name from the filter menu:

X1 add saved filters to search bar.png

It is also possible to add saved filters from the drop down menu directly in the search bar by clicking once when in advanced search mode:

advanced filter drop down.png

How to create a saved filter by adding one or more conditions

A saved filter can contain complex conditions by using a combination of advanced searches but with different logical operators, that is using “OR” instead of the default “AND” as the logical operator.

To create a condition click on the three dots menu to the right of the filter search field:

X1 filter conditions menu.png

A new filter search field will appear below and you can see a light blue “AND” to the left of the search fields:

X1 filter conditions added.png

You can now decide if the logical operator should be a “AND” or a “OR” condition by clicking once on the light blue vertical“AND” connector to the left and it will change to a ‘OR’ condition. Now you can add more advances searches to the filter and for instance end up with a filter like this:

X1 filter conditions example.png

INFO: To save the filter, click ‘PUBLISH' in the black bar to the top right.

How to create a saved filter by adding a condition group

If you have a filter with one or more advanced searches that should match a other specific advanced search with different values it’s possible to add that into a condition group like this as an example:

X1 filter conditions group example.mov

INFO: To save the filter, click ‘PUBLISH' in the black bar to the top right.

How to share saved filters with other users

It is possible to share a saved filter with other user by adding user groups to the saved filter:

X1 filter adding user groups.mov

WARNING: When a saved filter is shared with one or more user groups, all users in the groups can edit and publish the filter.

From the list of filters it is possible to see which user who last savedthe filter including the the time and date.

X1 filter modicfication date_time.png

How to delete saved filters

If you want to delete a saved filter you must either have access to it by being part of a user group that it is shared with or be the creator of a saved filter.

You can only delete one saved filter a time and it is done by clicking on the three dots to the right in the end of each saved filters:

Screenshot 2024-04-23 at 10.16.08.png

Once you have selected ‘Delete’ on one of more saved filters you want to delete then they will get a red marking with a purple stroke around it:

Screenshot 2024-04-23 at 10.22.38.png

When done with the deleting you will need to click on ‘Publish’ in the upper corner to the right in the black beam.

INFO: You’re a not able to delete a saved filter if it is used as an access filter in a specific user group from the Admin Panel.

Inherit advanced searches and saved filters ( purple chip (blue star) )

Purple chips indicates that they are inherited from a Workbench either as advanced searches (which can be edited) or as saved filters (which cannot be edited, unless the user has specific access to it as part of a user group membership).

X1 filter inherit purple chips .png

HINT: To temporarily deactivate a filter, click it once. The color will dimm and the filter will not impact the result in the list. To activate it again, simply click it again.

Default system searches ( black chip (blue star) )

In different workspaces - for instance Ad tracking and DAM (Digital Asset Management) - you will see black chips which are added to the search bar by the system.

Black chips are locked and cannot be removed or disabled. However they may offer varios settings that can be toggled on an off using the switch mechanism in the chip.

The purpose is to enable functionality that is required for the purpose of the workspace. In the Ad tracking workspace, for example, the black chips enable users to toggle creatives that have or have not yet been assigned to a lineitem. Ih this case, the black chip offers a switch that toggles Assigned vs. Unassigned modes.

X1 filter black chip excample Ad tradking.pngX1 filter black chip example.png

Quick search ( grey chip (blue star) )

A quick search in the search bar is represented by a grey chip. A quick search can be added simply by typing directly in the search bar followed by pressing ENTER and then selecting the various filtering options suggested. X1 helps to complete the filter by suggesting the various options available in each step of the creation of the filter. If you are creating a filter on a date, a calendar will be shown, if you want to filter on a list, the list options are shown and so on.

HINT: It’s possible to edit a quick search by a double clicking the chip and use left/right arrows and/or backspace to modify the search.

  • No labels