Filter settings

modified:

Filters can be found everywhere in the system where some resource listing is being displayed. Filters are sdvcdvdfxb dfb df. df used to quickly filter out information and find what you are looking for.


Filters look something like this:


Sorting

Each column with filter can sort data, just click on column name - 

  • sort data in ascending order - 
  • sort data in descending order - 

There are three possible types of filters:

  • simple text input which accepts characters and numbers and it looks like this - 
  • list of pre-defined options which can be set to multiple values and it looks like this - 

on click displays a dropdown with possible values:

  • date range where you can specify from and to ranges to be more specific when looking for something and it looks like this - 

on click a date selection screen appears:


Simple text filters

Simple text filters are special, because you may use special "operators" to better define your search query. Filters are not case sensitive, you may enter the search query in all lower case characters, and after the search, it will still display possible search results even if those are containing capital letters, the same rule applies if your search query is all capital letters.

Also its very important to note that symbol "_" by default is understood as space " ", so when you want to look for specific information with "_" symbol, you need to "escape" it with symbol "\" (see example below).

Example:
You need to search for the article with the name "Product_1".

Search results return you something like this:

  • Product 131035
  • Product 101
  • Product 1xxx
  • Product_1

Only the last search result is actually what we are looking for, but we wanted to filter only this specific case, so to do that we need to: "escape" the "_" with "\"

To achieve that, you need to search for the article with the name "Product\_1".


Search results should be specific:

  • Product_1


Available operators for simple text filters

Search query join operators:

  • | - operator OR (loose)
  • - operator AND (strict)


ToBeTranslate


-

ButtonWhat does it indicate?
-Find all result, which rows are empty


PO | SPO

ButtonWhat does it indicate?
'PO' 'SPO'
Text you need
|
All text which are in search area with 'PO' and 'SPO'


PO & SPO

ButtonWhat does it indicate?
'PO' 'SPO'
Text you need
&
All text 'PO' and 'SPO' should be in search area


!SPO

ButtonWhat does it indicate?
'SPO'
Text you need
!
Do not search text, which equal text after the sign (!SPO - don't search text, which has SPO)


=SPO

ButtonWhat does it indicate?
'SPO'
Text you need
=Search text, which starts 'SPO' (Capital or small letter are important here)


=!SPO

ButtonWhat does it indicate?
'SPO'
Text you need
!
Do not search text, which equal text after the sign (!SPO - don't search text, which has SPO)
=
Search text, which does not start 'SPO' (Capital or small letter are important here)


>2 or <2

ButtonWhat does it indicate?
'2'
Value you need
>
Search text, which are bigger than value (get all values, which are bigger than 2)
<
Search text, which are less than value (get all values, which are less than 2)


>2= or <2=

ButtonWhat does it indicate?
'2'
Value you need
>=
Search text, which are equal or bigger than value (get all values, which are equal or bigger than 2)
<=
Search text, which are equal or less than value (get all values, which are equal or less than 2)


PO\_1

ButtonWhat does it indicate?
'PO'
Text you need
\_
Search only that text, which has underscore  
'1'
Text you need after underscore (get all values, which are PO_1)


PO & !SPO

ButtonWhat does it indicate?
'PO' 'SPO'
Text you need
&
All text should be in search area
!
Search text, which isn't equal text after the sign (!SPO - don't search text, which has SPO)




Compare/logical operators:

  • - operator NOT (loose)
  • = - operator EQUAL TO (strict)
  • != - operator NOT EQUAL TO
  • > - operator GREATER THAN
  • - operator LESS THAN (strict)
  • >= - operator GREATER THAN OR EQUAL TO (strict)
  • <= - operator LESS THAN OR EQUAL TO (strict)


Filters support:

  • checking entry empty values with "-" (strict) symbol
  • joining multiple filter queries with "OR" and "AND" operators
  • regular expressions


How to use simple text filters?

You can specify filter query for each column in resource listing. Each filter query can be expanded by joining multiple search queries with "AND" or "OR" operators and each joined query should contain a compare/logical operator.


Scenarios (how to?)

Search by simple word in selected column loosely


Such search query will filter out all entries by "Name" column where "Name" inside entries matches specified word "Product 1".

Possible results:
  • Product 1
  • product 1
  • Product 12
  • product 123
  • aProduct 1x
  • In dev Product 10000
Filter functionality will compare your entry to available database entries and filter out possible results where search query matches characters, so you don't need to worry about remembering whole "Name".

Search where is no data entered in selected column (-)


Such search query will filter out all entries where "Name" column is empty or in other words not defined.

Search where two or more words should match selected column loosely (|)

Such search query will filter out all entries by "Name" column where "Name" inside entries contains words "Shirt" or "Jumper" or "Jacket".

Notice that here we used "|" operator which means "OR" and we can read this search query like: find everything where "Name" column matches words "Shirt" or "Jumper" or "Jacket".

Possible results:
  • Coloured jacket with stripes
  • Blue shirts with unique logos
  • Warm jumper with zipper
  • Pack of jackets
  • Cotton jumper, shirt combo
Notice how many variations of results you may get by using "|" ("OR") operator, because the search is very loose and it can find entries by multiple matches.

Search where multiple keys should match selected column strictly (&)


Such search query will filter out all entries by "Name" column where "Name" inside entries contains words "T" and "shirt".

Notice that here we used "&" operator which means "AND" and we can read this search query like: find everything where "Name" column matches words "T" and "shirt".

Possible results:
  • T-shirt
  • transparent shirt
  • Jacket and shirt
Notice how little variations of results you may get by using "&" ("AND") operator, because the search is very strict and it can find entries by multiple matches.

Search where entered value should exactly match entries strictly (=)


Such search query will filter out all entries by "Name" column where "Name" inside entries matches exactly specified words "Product 1".

Possible results:
  • Product 1
  • product 1
Notice how it works very similarly to just simply searching for "Product 1" but the main difference is that it will look specifically for the defined words and the search is strict.

Search where entered value should not match entries loosely (!)


Such search query will filter out all entries by "Name" column where "Name" inside entries is NOT containing words "Product 1" loosely.

Search where entered value should not match entries strictly (!=)

Such search query will filter out all entries by "Name" column where "Name" inside entries is NOT containing words "Product 1" strictly.


Search where entered value should be greater than strictly (>)


Such search query will filter out all entries by "Quantity" column where "Quantity" inside entries is greater than "9" strictly.

Search where entered value should be less than strictly (<)

Such search query will filter out all entries by "Quantity" column where "Quantity" inside entries is less than "9" strictly.


Search where entered value should be greater than or equal to strictly (>=)


Such search query will filter out all entries by "Quantity" column where "Quantity" inside entries is greater than or equal to "9" strictly.

Search where entered value should be less than or equal to strictly (>=)

Such search query will filter out all entries by "Quantity" column where "Quantity" inside entries is less than or equal to "9" strictly.