Skip to main content

xSuite Archive Prism User Guide

Query syntax

The query syntax of the archive server is identical to the syntax of Elasticsearch. The syntax that must be used for a search depends on the type of search.

Full-text search

The search string only contains the text.

Example: BMW AND (automobile OR motorcycle)

AND, OR, and NOT are Boolean operators. The operators must be capitalized.

Searching in fields

The syntax for searching in fields is Fields.datatype_field_name@document_type

Fields are always prefixed with Fields.. The data type is identified by one of the following prefixes:

Prefix

Description

s_

For texts

d_

For date fields

i_

For integers

c_

For decimals

b_

For bools

Example: Fields.d_DocumentDate@Customer

The field is called document date, it is a field of the type "Date", and the document is of the type "Customer."

Example: Fields.s_Name

The field is called "Name", is not assigned to any document type, and is of the type "Text".

Searching for values

The syntax for searching for values is field:value.

You can use operators in the search. The following operators are permitted:

Operator

Description

>

Greater than the value

<

Smaller than the value

<=

Less than or equal to the value

>=

Greater than or equal to the value

Example: Field:<Value

Searching for ranges

The syntax for searching for ranges is Field:[Range1 TO Range2].

Combinations of Boolean operators

You can use multiple Boolean operators in one search.

Example: Field:Value AND Field:Value2 AND Expression

The field must contain a value. Value2 must appear in field2 and expression must appear in the full-text.

Searching for a date

The syntax for searching for a date is YYYY-mm-DDTHH:MM:ss (UTC time zone).

Example: 2025-12-31T23:00:00