Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT taskimpl0_.id AS col_0_, taskimpl0_.name AS col_1_0_,
- taskimpl0_.subject AS col_2_, taskimpl0_.description AS col_3_, taskimpl0_.STATUS AS col_4_0_,
- taskimpl0_.priority AS col_5_0_, taskimpl0_.skipable AS col_6_0_,
- taskimpl0_.actualOwner_id AS col_7_0_, taskimpl0_.createdBy_id AS col_8_0_,
- taskimpl0_.createdOn AS col_9_0_, taskimpl0_.activationTime AS col_10_0_,
- taskimpl0_.expirationTime AS col_11_0_, taskimpl0_.processId AS col_12_0_,
- taskimpl0_.processSessionId AS col_13_0_, taskimpl0_.processInstanceId AS col_14_0_,
- taskimpl0_.deploymentId AS col_15_0_, taskimpl0_.subTaskStrategy AS col_16_0_,
- taskimpl0_.parentId AS col_17_0_
- FROM DBALLO06.Task taskimpl0_
- LEFT OUTER JOIN DBALLO06.PeopleAssignments_BAs businessad1_
- ON taskimpl0_.id=businessad1_.task_id
- LEFT OUTER JOIN DBALLO06.OrganizationalEntity organizati2_
- ON businessad1_.entity_id=organizati2_.id
- LEFT OUTER JOIN DBALLO06.PeopleAssignments_PotOwners potentialo3_
- ON taskimpl0_.id=potentialo3_.task_id
- LEFT OUTER JOIN DBALLO06.OrganizationalEntity organizati4_
- ON potentialo3_.entity_id=organizati4_.id
- LEFT OUTER JOIN DBALLO06.PeopleAssignments_Stakeholders taskstakeh5_
- ON taskimpl0_.id=taskstakeh5_.task_id
- LEFT OUTER JOIN DBALLO06.OrganizationalEntity organizati6_
- ON taskstakeh5_.entity_id=organizati6_.id
- WHERE (taskimpl0_.actualOwner_id=?
- OR taskimpl0_.createdBy_id=?
- OR organizati2_.id=?
- OR organizati2_.id IN ()
- OR organizati4_.id=?
- OR organizati4_.id IN ()
- OR organizati6_.id=?
- OR organizati6_.id IN ()
- ) AND (taskimpl0_.activationTime IN (? , ?) OR taskimpl0_.activationTime IN (? , ?))
- GROUP BY taskimpl0_.id ORDER BY taskimpl0_.id ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement