Advertisement
Guest User

Missing statement SQL

a guest
Sep 25th, 2015
32
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.85 KB | None | 0 0
  1. SELECT taskimpl0_.id AS col_0_, taskimpl0_.name AS col_1_0_,
  2.        taskimpl0_.subject AS col_2_, taskimpl0_.description AS col_3_, taskimpl0_.STATUS AS col_4_0_,
  3.        taskimpl0_.priority AS col_5_0_, taskimpl0_.skipable AS col_6_0_,
  4.        taskimpl0_.actualOwner_id AS col_7_0_, taskimpl0_.createdBy_id AS col_8_0_,
  5.        taskimpl0_.createdOn AS col_9_0_, taskimpl0_.activationTime AS col_10_0_,
  6.        taskimpl0_.expirationTime AS col_11_0_, taskimpl0_.processId AS col_12_0_,
  7.        taskimpl0_.processSessionId AS col_13_0_, taskimpl0_.processInstanceId AS col_14_0_,
  8.        taskimpl0_.deploymentId AS col_15_0_, taskimpl0_.subTaskStrategy AS col_16_0_,
  9.        taskimpl0_.parentId AS col_17_0_
  10. FROM DBALLO06.Task taskimpl0_
  11.      LEFT OUTER JOIN DBALLO06.PeopleAssignments_BAs businessad1_
  12.          ON taskimpl0_.id=businessad1_.task_id
  13.      LEFT OUTER JOIN DBALLO06.OrganizationalEntity organizati2_
  14.          ON businessad1_.entity_id=organizati2_.id
  15.      LEFT OUTER JOIN DBALLO06.PeopleAssignments_PotOwners potentialo3_
  16.          ON taskimpl0_.id=potentialo3_.task_id
  17.      LEFT OUTER JOIN DBALLO06.OrganizationalEntity organizati4_
  18.          ON potentialo3_.entity_id=organizati4_.id
  19.      LEFT OUTER JOIN DBALLO06.PeopleAssignments_Stakeholders taskstakeh5_
  20.          ON taskimpl0_.id=taskstakeh5_.task_id
  21.      LEFT OUTER JOIN DBALLO06.OrganizationalEntity organizati6_
  22.          ON taskstakeh5_.entity_id=organizati6_.id
  23. WHERE (taskimpl0_.actualOwner_id=?
  24.          OR taskimpl0_.createdBy_id=?
  25.          OR organizati2_.id=?
  26.          OR organizati2_.id IN ()
  27.          OR organizati4_.id=?
  28.          OR organizati4_.id IN ()
  29.          OR organizati6_.id=?
  30.          OR organizati6_.id IN ()
  31.       ) AND (taskimpl0_.activationTime IN (? , ?) OR taskimpl0_.activationTime IN (? , ?))
  32. GROUP BY taskimpl0_.id ORDER BY taskimpl0_.id ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement