Advanced search
Oct 20, 2020
VUMG-02 / VUMG-10 - July 2020 - VUSION Manager
VMG-17 - October 2020 - VUSION Manager
Concepts
In different dashboards of VUSION Manager, you can look for elements thanks to a search bar. Learn here how to perform complex searches.
Complex searches are based on each element structure. You will find here below some examples and tricks. If you wish to get the full element structure, please refer to the API documentation.
You can search information by using * (any string) and ? (any characters).
Please note that the first wildcard is ignored. If you wish to find string by the end, please use a double wildcard (e.g. type “**myendString”)
Field names & terms
You can specify fields to search in the query syntax:
where the
status
field containsactive
status:active
where the
title
field containsquick
orbrown
title:(quick OR brown)
where the
author
field contains the exact phrase"john smith"
author:"John Smith"
where the
first name
field containsAlice
(note how we need to escape the space with a backslash)where any of the fields
book.title
,book.content
orbook.date
containsquick
orbrown
(note how we need to escape the*
with a backslash):where the field
title
has any non-null value:
Operators and condition grouping
You can use: OR
, AND
and NOT
to perform queries.
By default, all terms are optional, as long as one term matches. A search for foo bar baz
will find any document that contains one or more of foo
or bar
or baz
.
Multiple terms or clauses can be grouped together with parentheses, to form sub-queries:
Groups can be used to target a particular field, or to boost the result of a sub-query:
The preferred operators are +
(this term must be present) and -
(this term must not be present). All other terms are optional. For example, this query:
states that:
fox
must be presentnews
must not be presentquick
andbrown
are optional — their presence increases the relevance
The familiar boolean operators AND
, OR
and NOT
(also written &&
, ||
and !
) are also supported but beware that they do not honour the usual precedence rules, so parentheses should be used whenever multiple operators are used together. For instance the previous query could be rewritten as:
((quick AND fox) OR (brown AND fox) OR fox) AND NOT news
This form now replicates the logic from the original query correctly, but the relevance scoring bears little resemblance to the original.
Ranges
Ranges can be specified for date, numeric or string fields. Inclusive ranges are specified with square brackets [min TO max]
and exclusive ranges with curly brackets {min TO max}
.
All days in 2012:
Numbers 1..5
Tags between
alpha
andomega
, excludingalpha
andomega
:Numbers from 10 upwards
Dates before 2012
Relative search
Escaping Special Characters
We supports escaping special characters that are part of the query syntax. The current list special characters are + - && || ! ( ) { } [ ] ^ " ~ * ? : \
To escape these character use the \ before the character. For example to search for (1+1):2 use the query:
Examples
Stores
Labels
Look for all labels matched to a product in promotion by using matching.item.inPromotion:true
Or look for unmatched labels with !matching.matchingDate:*
Items
Events
You can look for integration with invalid lines using