Search help

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

By default the system searches for results that starts with the value you have written in the search box. You are able to refine the search in different ways described below.

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 does not start with stuct
!*struct	all items where the value does not contain 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.

To swap between this you can toggle between 'Date search' and 'Date offset search' by clicking the icon to the left on the date column header.

Clicking the icon allows you to toggle between Date search and Date offset search

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, 2 = 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