Conditions on Object Characteristics
Indicates that the characteristic is not entered. Comparisons are done on an alphanumeric basis. For example, 2 is greater than 10 or 02.
Wildcards
In the "like" condition, the "# " symbol matches any number of characters. The "!" is the wildcard that matches one character, and can be repeated. For example:
• #x matches all the values beginning with x.
• #x matches all the values ending with x.
• #x# matches all the values containing x.
• !x# matches all the values that have x as the second character.
• x#x matches all the values beginning and ending with x.
• "!!" matches all the values that have two characters.
Examples:
select Org-Unit where Name = “Account Manager”
Here we give an example of a query on a precise name ("Account Manager"). In practice, querying the name of a calculated object can be tedious. It is recommended that a setting be called to write the query. For example: "select Org-Unit where Name = &ManagerName" You then specify the object name when you run the query.select Org-Unit where Name like "#count#"
select Org-Unit where Name like "!!!!!!! Manager#"
select Org-Unit where Name like "Ac#"
select Diagram where Nature null