Operator column
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.
- To match zero or more characters, use
- 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_nameNOT LIKE
Br%
finds all documents in which the property Last_name is not Br and does not begin with Br. - Document_Title
LIKE %
Namesfinds 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.
- To match zero or more characters, use
Feedback