The where clause describes the filter criteria to apply to the query domain. Its syntax is the same as an SQL where-clause. If you do not want to filter a query, you must specify null for the where clause.
The where-clause syntax supports:
The LIKE operation supports the wildcard characters defined for the queried database.
The following rules also apply:
You must specify at least a date or a time value in the timestamp:
Examples of where clauses
"WORK_ITEM.WIID = ID('_WI:800c00ed.df8d7e7c.feffff80.38')"This type of where clause is usually created dynamically with an existing object ID from a previous call. If this object ID is stored in a wiid1 variable, the clause can be constructed as:
"WORK_ITEM.WIID = ID('" + wiid1.toString() + "')"
"ACTIVITY.STARTED >= TS('2002-06-1T16.00.00')"
"WORK_ITEM.REASON = WORK_ITEM.REASON.REASON_OWNER"
"PROCESS_TEMPLATE.CAN_RUN_SYNC = TRUE"