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"

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.

Examples of Syntax

and, and

Examples:

• Regular search:

  facetName1="value1" facetName2="value2"
  

• Advanced search:

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

or, or

Examples:

• Regular search:

  @facet="valueA OR valueB"
  

• Advanced search:

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

equal, =

Examples:

• Regular search:

  label="value"
  

• Advanced search:

  @facetName="value"
  

Conclusion

For each operator, remember to select the correct syntax based on whether you are performing a regular or advanced search.