Previous
8.4.4 Query reference tables
8.4.4.1 Built-in process properties
These can be used when searching for processes, tasks or timers.
|
Property name |
Data type |
Non-query |
|---|---|---|
|
process.id |
id |
|
|
process.start |
datetime |
|
|
process.end |
datetime |
|
|
process.suspended |
boolean |
|
|
process.definitionName |
string |
|
|
process.definitionVersion |
long |
|
|
process.definitionLabel |
(xml) |
X |
|
process.definitionDescription |
(xml) |
X |
8.4.4.2 Built-in task properties
These can only be used when searching for tasks.
|
Property name |
Data type |
Non-query |
Comment |
|---|---|---|---|
|
task.id |
id |
||
|
task.actor |
user |
||
|
task.description |
string |
Currently not actively used in Daisy, see the
|
|
|
task.create |
datetime |
||
|
task.dueDate |
datetime |
||
|
task.isOpen |
boolean |
||
|
task.priority |
long |
||
|
task.definitionLabel |
(xml) |
X |
|
|
task.definitionDescription |
(xml) |
X |
|
|
task.hasPools |
boolean |
X |
|
|
task.hasSwimlane |
boolean |
8.4.4.3 Built-in timer properties
These can only be used when searching for timers.
|
Property name |
Data type |
Non-query |
Comment |
|---|---|---|---|
|
timer.id |
id |
||
|
timer.name |
string |
||
|
timer.dueDate |
datetime |
||
|
timer.suspended |
boolean |
||
|
timer.exception |
string |
||
|
timer.failed |
boolean |
X |
To search failed timers, use "timer.exception is not null" |
8.4.4.4 Special conditions
These conditions only work for certain query types.
|
Query type |
Condtion name |
|---|---|
|
process |
relatedToDocument |
|
task |
tasksInMyPool |
|
timer |
processRelatedToDocument |
8.4.4.5 Operators
|
Description |
Name |
Argument |
Supported datatypes |
||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
|
id |
string |
daisy-link |
long |
date |
datetime |
user |
boolean |
actor |
|||
|
Equals |
eq |
1 |
X |
X |
X |
X |
X |
X |
X |
X |
|
|
Less than |
lt |
1 |
X |
X |
X |
X |
|||||
|
Greater than |
gt |
1 |
X |
X |
X |
X |
|||||
|
Less than or equal |
lt_eq |
1 |
X |
X |
X |
X |
|||||
|
Greater than or equal |
gt_eq |
1 |
X |
X |
X |
X |
|||||
|
Between |
between |
2 |
X |
X |
X |
X |
|||||
|
Is null |
is_null |
0 |
X |
X |
X |
X |
X |
X |
X |
X |
|
|
Is not null |
is_not_null |
0 |
X |
X |
X |
X |
X |
X |
X |
X |
|
|
Like |
like |
X |
X |
||||||||
8.4.4.6 Data types
|
Name |
Java class |
|---|---|
|
id |
java.lang.String |
|
string |
java.lang.String |
|
daisy-link |
org.outerj.daisy.workflow.WfVersionKey |
|
long |
java.lang.Long |
|
date |
java.util.Date |
|
datetime |
java.util.Date |
|
actor |
org.outerj.daisy.workflow.WfActorKey |
|
user |
org.outerj.daisy.workflow.WfUserKey |
|
boolean |
java.lang.Boolean |