Share this link

    2.4.1. Filters

    1629 0 Created on 2020-09-21 11:30:44; Last updated on 2022-07-01 13:01:13

    In all grids, the filter bar allows you to easily filter the displayed data.

    The filters that are available depend on the type of data in this column. If you use multiple criteria, the system will display the data that satisfy ALL the criteria. You can also reset all the criteria in one click with the "Clear filters" button found inside the setting icon at the right-buttons of the grid.

    

    Clear Filters

    

    Textual data

    For textual data (columns like name, description), you will have a text-field allowing you to type your criteria. The system will search by default for all the data that contains the criteria, but you can change the operator by just clicking on it.

    Textual Filter

    

    Here is the full list of available operators :

    • ~ : contains. The system will only display the rows whose value in the field contains (ignore case) the typed value.
    • !~ : does not contain. The system will only display the rows whose value in the field does not contain (ignore case) the typed value.
    • = : equals. The system will only display the rows whose value in the field is exactly equal to the typed value.
    • ^ : begins with. The system will only display the rows whose value in the field begins with the typed value.
    • | : ends with. The system will only display the rows whose value in the field ends with the typed value.
    • ≈ : matches regex. The system will only display the rows whose value in the field matches the entered regular expression.
    • # : is empty. The system will only display the rows that have no value for this field.
    • !# : is not empty. The system will only display the rows that have a non-empty value for this field.

    

    Note: In Babelway, we're using the standard Java version of REGEX, and it's the same used all over the system.

     

    Numeric values

    For the numeric columns, the same system applies.

    The available operators are :

    • = : equals. The system will only display the rows whose value in the field is exactly equal to the entered number.
    • : greater than. The system will only display the rows whose value in the field is strictly greater than the entered number.
    • ≤ : less than or equal. The system will only display the rows whose value in the field is less or equal than the entered number.
    • ≥ : greater than or equal. The system will only display the rows whose value in the field is greater or equal than the entered number.
    • [] : range. The system will only display the rows whose value in the field is between the 2 entered limits. You must pick the 2 limits separated by a space or a dash. Ex : '12 50', or '12-50'.
    • , : is in. The system will only display the rows whose id of element in the field is in the list of entered values. ids must be separated by commas. Ex : '1234,1235'.
    • !, : is not in. The system will only display the rows whose id of element in the field is not in the list of entered values. ids must be separated by commas. Ex : '1234,1235'.

    Filter on a numeric column

    

    Auto-complete functionality in the New search operators

    The auto-complete functionality only works with certain operators. For example the "Name is" ( = ) operator will generate a dropdown menu with possible choices, as shown below.

    

    Filter using name

    List is generated

    The same search using a "contains" operator won't generate a dropdown menu due to the way this operator works.

    

    

    Filter using contain

    

    Note: If you weren't using the "name is" operator, and you could see the dropdown menu then this is the browser's auto complete function.

    For example, if the browser is Chrome then it offers you any value that you recently typed in any field named 'name', as shown below:

    

    Browser settings

    

    Such confusing behavior is generated by the browser you are using. You can disable the option by removing the check from the "Enable Autofill to fill out web forms in a single click".

    Channels, gateways, message definitions, transformations, ...

    The same system with operators applies again. By default, all elements whose name contains the entered criteria will match.

    The available operators are :

    • ~ : name contains. The system will only display the rows whose name of element in the field contains (ignore case) the typed value.
    • !~ : name does not contains. The system will only display the rows whose element name in the field does not contain (ignore case) the typed value.
    • = : name equals. The system will only display the rows whose name of element in the field is exactly equal to the typed value.
    • , : id in. The system will only display the rows whose id of element in the field is in the list of entered values. ids must be separated by commas. Ex : '1234,1235'.
    • !, : id not in. The system will only display the rows whose id of element in the field is not in the list of entered values. ids must be separated by commas. Ex : '1234,1235'.

    

    Filter on a channel

    

    

    Types with a limited number of possible values.

    When all the values of type can be enumerated, a dropdown menu shows all the possible values. If you select a specific value, the system will search for all the data that exactly include this value in the column.

    

    Filter on a date

    

    Dates and times

    A dropdown menu allows you to choose from several common periods ("Last 24 hours", "Last 7 days", "Last month")

    

    If you want to view a custom time period, you can select the "Custom" value. A pop-up will then be available enabling you to choose any time interval.

    

    

    

    

    

    0 people found this helpful.

    Related Articles