The functionality of filters in AtroCore system consists of:

  • General filters – default boolean filters that are added to an entity by default
  • Saved filters – public or private filters created by the user
  • Query Builder – advanced filter which allows you to build queries of any complexity to filter entity records.

The Search, General and Saved filters are located in the page header, and the Advanced Filter is in the right sidebar of the entity list view.

Searching works on the current entity records, while filtering works also on the related records, which are configured by the administrator.

Use the global search if you wish to search globally across all the entities in the system.

Search allows you to quickly focus on the records you want to see. These sections are automatically available on each entity list view page:

Search panel

To perform a search operation, enter your search query into the corresponding field and hit the Enter key on your keyboard or click the Apply button (magnifying glass). To reset search click the Search reset button.

By default, the search works on all text fields (partial matches are allowed), as well as on fields of the Integer and Float types (only full matches). In order to use special characters, you need to enable the Use ‘contains’ operator when filtering varchar fields checkbox in the System Settings

Wildcards can be used for search, at any place in the search string, separately or in any combination.

Character Use
% or * Matches any number of characters, including zero
_ Matches only one character

Text search can be used alone or in combination with a filter.

General and Saved filters

General filters are default boolean filters available for each entity (e.g., Active, Deleted, Bookmarked).

Saved filters are custom boolean filters created and saved by users, and can be marked as Public or Private.

Both General and Saved filters are displayed:

  • In the header panel next to the Search bar.
  • In the right sidebar under the Filters section.

To apply a boolean filter, check the corresponding box in either panel. Changes are applied immediately. To reset all filters:

  • Use the Reset Filter button in the Header Bar, or
  • Click Unset All in the right sidebar.

To remove a specific filter, uncheck its box — this change is also applied instantly.

Boolean filters can be used together with the Search or Advanced Filter, or on their own.

Reset Filter

Advanced Filter

The Advanced Filter is available in the list view for all Basic and Hierarchical entities. Entities of the Reference Data type only support Search, not filtering.

Advanced Filter lets you find specific records by applying rules to fields or attributes of an entity. You can:

  • Add multiple rules
  • Combine them using "AND" or "OR" operators
  • Group rules together for complex queries
  • Save your filter configurations for future use

Filter settings are stored in local storage. This means that the filter remains active even when switching between entities, until it's manually disabled.

Advanced filter configuration

To filter records by certain fields or attributes, click the Add Rule button in the "Advanced Filter" section of the the right sidebar. A window for selecting a rule for the field or attribute appears. If you click the button again, another window will be added. Add as many rules as you want to use for filtering.

Advanced Filter

Click inside the Select Field/Attribute field and start typing the name of the desired Field or select from the drop-down list. If the entity has attributes, the "Attributes" section will exist in the drop-down list for it. Click [Add Attribute] and select one of the entity's Attributes to create a rule for it.

Several rules can be combined with the "AND" or "OR" operators. You can also add a group of rules and combine it with another rule or group.

Advanced Group Filter

The Filter in the example above consists of two groups joined by the "OR" operator. It allows to find all Products from the Electronics Category whose EAN number contains "38" or products from the Footwear Category whose EAN number contains "39".

Once you've configured the filter, click Apply. The toggle next to "Advanced Filter" will indicate if the filter is active. You can disable the filter using this toggle — the configuration will remain saved in local storage. Click Clear to remove all rules.

How to save a filter

You can save the configured filter for your user (Private) and for all users of the system (Public). To save a filter, create it in the Advanced Filter panel by adding one or more rules, apply and click the Save button.

Save Filter

In the appeared modal window, set the name of the filter and whether it should be public or not.

Save Filter

Saved filters will appear in the Filters panel for the entity. You can:

  • Edit – Modify the filter rules.
  • Copy – Duplicate the configuration into the Advanced Filter panel for further editing.
  • Rename – Change the name or visibility of the filter.
  • Delete – Remove the filter.

Save Filter options

Available Filtering Criteria

Depending of the field/attribute type, you can apply the following filtering criteria:

Field Type Filtering Criteria Input Value
Array, List, Multi-value list, Link, Link Multiple In/Not In Value list, multiselect
Is Empty/Is Not Empty
Boolean Checkbox
Integer, Float Is Not Empty
Is Null/Is Not Null
Equals Input field
Not Equals Input field
Greater Input field
Less Input field
Greater or Equals Input field
Less or Equals Input field
Between 2 Input fields
Date, DateTime Is Null/Is Not Null
Current Month
Last Month
Next Month
Current Year
Last Year
Last X Days Input field
Next X Days Input field
Less Date picker
Less or equal Date picker
Greater Date picker
Greater or equal Date picker
After X Days Input field
Equal Date picker
Not Equal Date picker
Between 2 Input fields
String, Text, URL, HTML Contains Input field
Equals Input field
Not Contains Input field
Not Equals Input field
Is Empty
Is Not Empty

Subfilters

When adding filters to your search you can add additional sub-filters. For example, if you want to filter products by specific Files (main filter), and also limit those files to a certain type — such as only Image Files — you'll need to apply a sub-filter within the main filter. This sub-filter refines the main filter criteria to include only the desired File types.

To create such filter you need:

  • Add a rule for Files with the criteria set to "In", then click Select to open a modal window for selecting files.
  • Filter data in the popup window according to the needed criteria and apply filter inside the modal window
  • Check all filtered records using the Select All checkbox and click Select button.

Subfilters

The modal window will close and the main filter will be shown as on the picture below:

Subfilters

This way is more accurate then selecting all appropriate results to subfilter because:

  • it is faster, especially when you have a lot of results
  • whenever database is updated you do not have to manually update the filter - it is automatically updated according to new information

When using select all results option, all additional data that fit the filters will be automatically added if you reuse this filtering.

For all entities there is additional panel where you can search and filter records by Link or Link Multiple fields. For example, for the Product entity, these can be Categories, Brands, Classifications, Catalogs, etc.

Hierarchy options

User can see the entity by its hierarchy, as a tree. Press arrows to proceed down by hierarchy and Show more to get more records to see. Selecting a record here is opens details menu. In the details menu hierarchy panel shows the way to the record. If you are showing by, for example, category - it will show you the category the product is in. If there is no such it will show you the general tree.

Hierarchy panel

If you select the same entity in the left panel as the page you're on, you'll see the "Apply main search and filter" toggle below the search. It is enabled by default. Unset the toggle if you don't want the main filter and search to apply to the record list in the left sidebar. If the toggle is enabled, the text search in the left sidebar will be applied in addition to the main filter.

Search in the tree panel

In addition to relative fields, there is a Bookmarks link at the top of the left sidebar.

You can filter bookmarked records by any filter and use Search for them both in the left sidebar and on the main page.

Automatic Search Mask Recognition (in development)

AtroCore has automatic search mask recognition. This can be considered as a quick search function, i.e. when you start typing, AtroPIM automatically determines the search mask type of your search string. Automatic search mask recognition is available for the following field types: Text, Number, Date, and Time.

Depending on the search mask type, the system searches through all entity fields of the appropriate field type. A pop-up with auto-suggestions appears with the information about field name and amount of search results for this field, i.e. "Address: 3 results", and the text link(s) to show the results.

If nothing is chosen from the auto-suggesting pop-up, click the magnifier icon to perform normal search (only through the fields listed in the metadata for this entity).

After clicking on the search results, the appropriate filter will be set automatically and the search field will be left empty.

Search Mask Type Field Types to Be Searched Applied Filter Criteria
Text, e.g. "atro 123" Address, Number, Varchar, Text, URL, Wysiwyg Starts with
%Text, e.g. "%atro 123" Address, Number, Varchar, Text, URL, Wysiwyg Consists
Numbers, e.g. "123" Address, Number, Varchar, Text, URL, Wysiwyg Starts with
Numbers, e.g. "123" Auto-increment, Currency, Integer, Float Is
Date, e.g. "12.12.2018" Date, DateTime On