Search help

Searches in Struct PIM can be highly customized by using specific syntax.

Operators

A number of different search operators can be used to make complex queries.

If you search for:	Search will return:
struct	all items where the value starts with struct
*struct	all items where the value contains struct
"struct"	all items where the value equals exactly struct
=struct	all items where the value equals exactly struct
!struct	all items where the value does not start with struct
!*struct	all items where the value does not contain struct
!"struct"	all items where the value is not equal to struct
!=struct	all items where the value is not equal to struct
""	all items where this value is empty
!""	all items where this value is not empty
*<	all items where the value contains the character <

Numeric fields

If you search for:	Search will return:
>5	all items where the value is larger than 5
<5	all items where the value is less than 5
>5&&<10	all items where the value is larger than 5 and less than 10

Date/date time fields

For date or datetime fields you can search for exact dates and times or distances from the current date.

The syntax for searching for date offsets is:

If you search for:	Search will return:
>-30d	all items where the date is larger than now - 30 days
<30d	all items where the date is smaller than now + 30 days

y = years, M = months, w = weeks, d = days, h = hours and m = minutes

Multiple searches in same field

The system supports following boolean operators for making multiple queries in the same field

If you search for:	Search will return:
[query1]&&[query2]	all items where the value is included in both query1 and query2
[query1]||[query2]	all items where the value is included either in query1 or query2