General system-wide features > Search and sort >

How to enter keywords for each data type

 

 

Numeric data typeand date

Search method

Beetween

Data whose value is between value 1 and value 2.

When value 2 is not entered: Data is greater than value 1.

When value 1 is not entered: Data is less than value 2

Outside

Data whose value is outside of value 1 and value 2.

When value 2 is not entered: Data is less than value 1.

When value 1 is not entered: Data is greater than value 2

=

Data equals the value 1

<>

Other data value 1

 

Search content

Consists of 2 values, value 1 and value 2.

 

 

Chain typecharacters

Search method

Containers

The data contains the value 1

Not contain

The data does not contain the value 1

Start with

Data starts with the value 1

End with

Data ends with the value 1

=

Data equals the value 1

<>

Other data value 1

 

 

Search content

Consists of 1 value, called value 1.

 

 

Data is a selection list

Search method

 

Include

Find data that includes selected content

Exclude

Find the data that does not include the selected content

 

Search content

When the column information is a predefined list of data to choose from, the search object is the elements in that list. Multiple components can be selected to search.

Filter data in the list

Type keywords to find data in case the data list is long.

 

List of predefined data

 

 

Selected content

Content to search, can choose many

 

 

 

Advanced search

Find the null value

For quick search, do not type in the text box.

For detailed search, select Is null or Is not null search method

 

Search with wildcat

The character % represents any content, which can be used to search with matching conditions. For example in the picture below, is to find items with model MD 461 and Vence fabric.