| Revision | 2449 (tree) |
|---|---|
| Time | 2022-10-13 19:01:17 |
| Author | t_nakayama1971 |
(empty log message)
| @@ -8,7 +8,7 @@ | ||
| 8 | 8 | K.STATUS AS JOB_STS, |
| 9 | 9 | K.MESSAGE AS MSG_TXT, |
| 10 | 10 | I.CANCEL_TYPE AS CANCEL_TYPE, |
| 11 | - I.SAIKIDO_KUBUN, | |
| 11 | + I.SAIKIDO_KBN, | |
| 12 | 12 | /*?Page*/1 AS PAGE, |
| 13 | 13 | /*?Line*/20 AS LINE, |
| 14 | 14 | COUNT(K.JOB_SEQ) OVER() AS CNT |
| @@ -19,7 +19,7 @@ | ||
| 19 | 19 | ON |
| 20 | 20 | I.JOB_ID = K.JOB_ID |
| 21 | 21 | WHERE |
| 22 | - K.ENTRY_USER_ID = /*:UserIdSearch*/'nakayama' | |
| 22 | + K.ENTRY_USER_ID = /*:UserIdSearch*/'searchUser' | |
| 23 | 23 | ORDER BY |
| 24 | 24 | K.JOB_SEQ DESC |
| 25 | 25 | OFFSET ((/*?Page*/1 - 1) * /*?Line*/20 ) LIMIT /*?Line*/20 |
trunk/framework/pjSvc/src/main/resources/project/svc/job/JobQuery.sql