Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT taskimpl0_.id AS col_0_0_,
- taskimpl0_.name AS col_1_0_,
- taskimpl0_.subject AS col_2_0_,
- taskimpl0_.description AS col_3_0_,
- 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 DBALLO05.Task taskimpl0_
- INNER JOIN DBALLO05.PeopleAssignments_PotOwners potentialo1_
- ON taskimpl0_.id=potentialo1_.task_id
- INNER JOIN DBALLO05.OrganizationalEntity organizati2_
- ON potentialo1_.entity_id=organizati2_.id
- WHERE organizati2_.id IN (? , ? , ?)
- GROUP BY taskimpl0_.id
- ORDER BY taskimpl0_.id ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement