一堆你看不懂的SQL

最新推荐文章于 2026-05-03 05:27:00 发布

最新推荐文章于 2026-05-03 05:27:00 发布 · 174 阅读

标签

#sql SAP BPM TASK inactive

db 专栏收录该内容

21 篇文章

订阅专栏

本文介绍了一种复杂的SQL查询方法，用于从多个表中选择特定条件的任务及其相关信息，包括任务组ID和作业ID等。该查询涉及到多表连接、子查询及条件筛选。

/*ID2*/
SELECT  o.GROUP_ID  FROM GLX_C_OBJECTS o, GLX_C_CLASSES c WHERE c.CLASS_ID = o.class_id and o.object_id in
(sELECT LOWER( hex( t.ID)) FROM BPEM_IDX_OBJ o, BPEM_IDX_TASK t WHERE t.ID = o.ID AND o.LIFECYCLE_STATUS = 10)
/*ID6*/
SELECT OBJECT_ID  FROM GLX_C_OBJECTS WHERE CLASS_ID  in (
SELECT CLASS_ID  as newContext FROM GLX_C_CLASSES WHERE NETWORK_ID in (SELECT c.NETWORK_ID FROM GLX_C_OBJECTS o, GLX_C_CLASSES c WHERE c.CLASS_ID = o.class_id and o.object_id in
(sELECT LOWER( hex( t.ID)) FROM BPEM_IDX_OBJ o, BPEM_IDX_TASK t WHERE t.ID = o.ID AND o.LIFECYCLE_STATUS = 10))	AND        cast(CONTENT as varchar(32000)) like '%ActivationDeadlineIntermediateTimerE%'  )
 AND GROUP_ID in(
SELECT o.GROUP_ID  FROM GLX_C_OBJECTS o, GLX_C_CLASSES c WHERE c.CLASS_ID = o.class_id and o.object_id in
(sELECT LOWER( hex( t.ID)) FROM BPEM_IDX_OBJ o, BPEM_IDX_TASK t WHERE t.ID = o.ID AND o.LIFECYCLE_STATUS = 10))


SELECT JOB_ID FROM GLX_C_JOBS WHERE OBJECT_ID in
(
SELECT OBJECT_ID  FROM GLX_C_OBJECTS WHERE CLASS_ID  in (
SELECT CLASS_ID  as newContext FROM GLX_C_CLASSES WHERE NETWORK_ID in (SELECT c.NETWORK_ID FROM GLX_C_OBJECTS o, GLX_C_CLASSES c WHERE c.CLASS_ID = o.class_id and o.object_id in
(sELECT LOWER( hex( t.ID)) FROM BPEM_IDX_OBJ o, BPEM_IDX_TASK t WHERE t.ID = o.ID AND o.LIFECYCLE_STATUS = 10))	AND        cast(CONTENT as varchar(32000)) like '%ActivationDeadlineIntermediateTimerE%'  )
 AND GROUP_ID in(
SELECT o.GROUP_ID  FROM GLX_C_OBJECTS o, GLX_C_CLASSES c WHERE c.CLASS_ID = o.class_id and o.object_id in
(sELECT LOWER( hex( t.ID)) FROM BPEM_IDX_OBJ o, BPEM_IDX_TASK t WHERE t.ID = o.ID AND o.LIFECYCLE_STATUS = 10))
)