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.
- 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.
- 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 XT: starts with, ends
with and contains.
- 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.
If you do not use wild card characters
in your value, the Like operator functions
like the Is Equal to operator.
- 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.