This topic applies only to the IBM Business Automation Workflow Advanced configuration.

Example: Querying escalations

Edit online
Draft comment:
This topic only applies to BAW, and is located in the BAW repository. Last updated on 2025-03-13 12:15
This example shows how to use the query method to retrieve escalations for the logged-on user.
When a task is escalated, and escalation receiver work item is created. The user, Mary Jones wants to see a list of tasks that have been escalated to her. The following code snippet shows the query method call for the query:
query( "DISTINCT ESCALATION.ESIID, ESCALATION.TKIID", 
         "WORK_ITEM.REASON = WORK_ITEM.REASON.REASON_ESCALATION_RECEIVER",  
           (String)null, (String)null, (Integer)null, (TimeZone)null )
The following actions are taken when the SQL SELECT statement is generated:
  • A condition for access control is added to the where clause. This example assumes that group work items are not enabled.
  • Constants, such as TASK.STATE.STATE_READY, are replaced by their numeric values.
  • A FROM clause and join conditions are added.
The following code snippet shows the SQL statement that is generated from the API query:

 SELECT DISTINCT ESCALATION.ESIID, ESCALATION.TKIID
   FROM   ESCALATION ESC, WORK_ITEM WI 
   WHERE  ESC.ESIID = WI.OBJECT_ID
   AND    WI.REASON  = 10                                 
   AND  
  ( WI.OWNER_ID = 'MaryJones' OR WI.OWNER_ID = null AND  WI.EVERYBODY = true )