Skip to main content

xSuite Helix - Help

Meta data search expression examples

All meta data search expressions must be serialized as a JSON string so DocumentType="sys_Invoice" is serialized as "DocumentType=\"sys_Invoice\"".

Expression

Description

DocumentType="sys_Invoice"

Equality search for DocumentType meta data with a value of sys_Invoice.

StorageState<>"1"

Inequality search for StorageState meta data with a value of 1.

DocumentSize >= "123941"

Greater or equal search for DocumentSize meta data with a value of 123941.

"FileSize BETWEEN "123940" AND "123942"

Range search for FileSize meta data with a value between 123940 AND 123942.

"CreateTimeStamp BETWEEN "2021-04-19 22:00:00" AND "2021-04-20 21:59:59"

Range search for CreateTimeStamp meta data with a value between 2021-04-19 22:00:00 AND 2021-04-20 21:59:59 UTC.

"DocumentType LIKE "Invoice"

Range search for DocumentType meta data matching the pattern "Invoice". Matches "sys_Invoice" and "cst_Invoice", but not "invoice".

(DocumentType LIKE "_Invoice") AND (DocumentTypeVersion >= "3")

Combined search for DocumentType and DocumentType meta data. Matches all documents having a document type containing "_Invoice" and a document type version greater or equal to 3.

(DocumentType="sys_Invoice") OR (DocumentType = "sys_Mailroom")

Combined search for DocumentType meta data. Matches all documents having a document type with a value of "sys_Invoice" or "sys_Mailroom"

In this section: