Manual > Control Reference > Basics > Grid control > Functionality Description > Grid Paging and Filtering

Grid Search Format

The following search formats can be specified in the search filter and field filter of Grid control.

Format

explanation

Contains all keywords

Specify keywords separated by spaces.

Example: Servo motor Emergency valve

Contains any of the keywords

Specify keywords separated by "or".

Example: Servo motor or emergency valve

Specify the keywords you want to exclude

Specify keywords separated by "not".

Example) not null

Begins with

Specify the keyword by adding an asterisk (*).

Example: Servo*

Left match

Specify the keyword by adding an asterisk (*).

Example: *Valve

Exact match

Specify keywords enclosed in double quotation marks.

Example: "emergency valve"

Range Search

The format for specifying the search range is a combination of ":" (a half-width colon) and "." (a half-width period).

x::	x or more
x..	Greater than x
..x	Less than x
x::y	Greater than or equal to x, less than or equal to y
x..y	Greater than x and less than y
x:.y	Greater than or equal to x and less than y
x.:y	Greater than x and less than or equal to y

Numeric range search *Searches numeric fields only.

Example: 1::4 1:: ::1 1..4 1.. ..4 1:.4

Date and time range search *Searches time type fields only.

Date and time specification) "2019/3/1 0:0:0".."2019/4/1 23:59:59" "2019/3/1 0:0:0".. *When specifying a date and time, enclose it in double quotation marks.

Date specification) 2019/3/1..2019/4/1 2019/3/1..

Time specification) 12:30:00..15:00:00

　　Time and minute specification) 12:30..15:00

Empty Cell

The keyword "null" searches for empty cells.

Example) null / not null