Property search conditions use any of the following operators depending on
whether they are appropriate for the selected property.
- In retrieves documents with multi-value properties (set up as
a list) when the value you enter is in that list.
- Is Defined retrieves documents with an object-value property
value that points to another object. You cannot enter a value for this operator. For an object-value property, this means the object is not null.
- Is Not Defined retrieves documents with an object-value property
value that has not been defined. You cannot enter a value for this operator. For an object-value property, this means the object is null.
- Is Equal to retrieves documents with a property value that
matches what you enter in the Value column. For an object-value property, this operator means two objects have the same GUID in the object stores. You can add two objects with same GUID across object stores by doing an export and import task.
- Is Not Equal to retrieves documents whose property values do
not match what you enter in the Value column. This operator does not find
documents in which the property value is blank (or null). To find such documents,
use the Is Null operator.
TIP The
Is Not Equal to operator is time-consuming because every item must be accessed
sequentially. For best results, limit
the search to a folder name.
- Is Greater Than specifies that the value of the property must
be greater than (or, for date properties, after) what you enter in the Value
column. It excludes documents with a property value matching the comparison
value.
For example, if you enter a condition such as
name greater than Brown
you get all values that follow Brown alphabetically (in ASCII order), but
you do not get the value Brown.
- Is Less Than specifies that the value of the property must
be less than (or, for date properties, before) what you enter in the Value
column. It excludes documents with a property value matching the comparison
value.
For example, If you enter a condition such as
name less than Brown
you get all values that precede Brown alphabetically (in ASCII order),
but you do not get the value Brown.
- Is Null specifies that there is no value for this property
in the object store.
- Is Not Null specifies that the property has a value.
- Is Greater than or Equal to specifies that the value of the
property must be the same as, greater than, or after what you enter in the
Value column.
For example, if you enter a condition such as
name greater than or equal to Brown
you get the name Brown and all names that follow Brown alphabetically (in
ASCII order).
- Is Less Than or Equal to specifies that the value of the property
must be the same as, less than, or before what you enter in the Value column.
For example, if you enter a condition such as
name less than or equal to Brown
you get the value Brown and all values that precede Brown alphabetically
(in ASCII order).
- Is Like With the LIKE operator you can use wild
card characters in a search condition to test a text property.
The LIKE operator requires using the % wildcard in the search definition.
- To match zero or more characters, use
%.
For example
Last_name LIKE Br%
finds all documents in which the property Last_name is Br or begins with
Br.
- When you use LIKE in conjunction with the % wildcard, that operator is converted into the following operators in Search in Workplace: starts with, ends with and contains.
NOTE Be aware that, in Workplace, the starts with operator behaves differently than the ends with and contains operators. If the user does not enter a value for a property, the starts with operator does not return any results; conversely, the ends with and contains operators return many results.
- To match one (required) character, use _. For example: Last_name
LIKE
Brow_
finds all documents in which the property Last_name has exactly five letters
beginning with Brow.
- You cannot use the LIKE operator to test dates, numeric values,
or multi-value properties. You can use more than one wild card in a test. See
the Value column for more examples.
- Is Not Like With the NOT LIKE operator
you can use wild card characters in a search condition to test a text property.
You can use more than one wild card in a test.
- To match zero or more characters, use
%
. For example: Last_name NOT LIKE
Br%
finds all documents in which the property Last_name is not Br and does
not begin with Br.
- Document_Title
LIKE %
Names
finds documents like Names, MoreNames, etc.
- To match one (required) character, use _. For example
Last_name NOT LIKE
Brow_
finds all documents in which the property Last_name is anything other than
five letters beginning with Brow.
- If you do not use wild card characters in your value, the Not Like operator functions like the Is Not Equal to operator.