FuseQL Search Operators

FuseQL search operators enable both regular and advanced log search (after you choose the Advanced Search option). The language specifies the following syntactical rules:

• The search operator must appear before the first pipe (|) symbol in the query expression.
• All other operators must follow a valid search expression.

Operators

and

Intersection operator (AND logic) between two search operators. Selects results that satisfy both conditions.

or

Union operator (OR logic) between two search operators. Selects results that satisfy either or both conditions.

equal, =

Searches for specified value; exact match.

not equal, !=

Searches for values other than the specified value; exact match.

greater than, >

Searches for values that are greater than the specified number.

greater than or equal, >=

Searches for values that are greater than or equal to the specified number.

less than, <

Searches for values that are less than the specified number.

less than or equal, <=

Searches for values that are less than or equal to the specified number.

regex, =~

Searches for results that match a specific character pattern.

not regex, !~

Searches for results that do not match a specific character pattern.

terms exist, term

Searches to match a specific term; limited to one word.

not terms exist, !term

Searches to exclude a specific term; limited to one word.

grep, "grep"

Searches for a specific expression (multi-word string) in the log message body.

[not grep, `!"grep"](https://docs.kloudfuse.com/platform/3.3.6/fuseql-search-operators/#not-grep)

Searches to exclude a specific expression (multi-word string) in the log message body.

facet terms exist, ==

Searches to match a specific facet and its value.

facet terms not exist, !==

Searches to exclude a specific facet and its value.

starts with, *~

Searches for labels or facets where the value begins with the specified string.

ends with, ~*

Searches for labels or facets where the value ends with the specified string.

contains, **

Searches for labels or facets where the value contains the specified string.

key exists

Searches for the presence of a specific facet, regardless of its value.

Example Syntax

and, and

Intersection operator (AND logic) between two search operators. Selects results that satisfy both conditions.

Syntax

Regular search:

facetName1="value1" facetName2="value2"

Advanced search:

@facetName1="value1" and @facetName2="value2"

or, or

Union operator (OR logic) between two search operators. Selects results that satisfy either or both conditions.

Syntax

Regular search:

@facet="valueA OR valueB"

Advanced search:

@facet="valueA" or @facet="valueB"

equal, =

Searches for specified value; exact match.

Syntax

label="value"
@facetName="value"

not equal, !=

Searches for values other than the specified value; exact match.

Syntax

label!="value"
@facetName!="value"

greater than, >

Searches for values that are greater than the specified number.

Syntax

@facetName>number

greater than or equal, >=

Searches for values that are greater than or equal to the specified number.

Syntax

@facetName>=number

less than, <

Searches for values that are less than the specified number.

Syntax

@facetName<number

less than or equal, <=

Searches for values that are less than or equal to the specified number.

Syntax

@facetName<=number

regex, =~

Searches for results that match a specific character pattern.

Syntax

label=~"value"
@facetName=~"value"

not regex, !~

Searches for results that do not match a specific character pattern.

Syntax

label!~"value"
@facetName!~"value"

terms exist, term

Searches to match a specific term; limited to one word.

Syntax

term

not terms exist, !term

Searches to exclude a specific term; limited to one word.

Syntax

!term

grep, "grep"

Searches for a specific expression (multi-word string) in the log message body.

Syntax

"expression"

not grep, !"grep"

Searches to exclude a specific expression (multi-word string) in the log message body.

Syntax

!"expression"

facet terms exist, ==

Searches to match a specific facet and its value.

Syntax

@facet=="value"

facet terms not exist, !==

Searches to exclude a specific facet and its value.

Syntax

@facet!=="value"

starts with, *~

Searches for labels or facets where the value begins with the specified string.

Syntax

label*~"value"
@facet*~"value"

ends with, ~*

Searches for labels or facets where the value ends with the specified string.

Syntax

label~*"value"
@facet~*"value"

contains, **

Searches for labels or facets where the value contains the specified string.

Syntax

label**"value"
@facet**"value"

key exists

Searches for the presence of a specific facet, regardless of its value.

Syntax

Regular search:

key exists = "facet"

Advanced search:

@facet