• R/O
  • SSH
  • HTTPS

Commit

Tags
No Tags

Frequently used words (click to add to your profile)

javac++androidlinuxc#windowsobjective-ccocoa誰得qtpythonphprubygameguibathyscaphec計画中(planning stage)翻訳omegatframeworktwitterdomtestvb.netdirectxゲームエンジンbtronarduinopreviewer

Commit MetaInfo

Revision2449 (tree)
Time2022-10-13 19:01:17
Authort_nakayama1971

Log Message

(empty log message)

Change Summary

Incremental Difference

--- trunk/framework/pjSvc/src/main/resources/project/svc/job/JobQuery.sql (revision 2448)
+++ trunk/framework/pjSvc/src/main/resources/project/svc/job/JobQuery.sql (revision 2449)
@@ -8,7 +8,7 @@
88 K.STATUS AS JOB_STS,
99 K.MESSAGE AS MSG_TXT,
1010 I.CANCEL_TYPE AS CANCEL_TYPE,
11- I.SAIKIDO_KUBUN,
11+ I.SAIKIDO_KBN,
1212 /*?Page*/1 AS PAGE,
1313 /*?Line*/20 AS LINE,
1414 COUNT(K.JOB_SEQ) OVER() AS CNT
@@ -19,7 +19,7 @@
1919 ON
2020 I.JOB_ID = K.JOB_ID
2121 WHERE
22- K.ENTRY_USER_ID = /*:UserIdSearch*/'nakayama'
22+ K.ENTRY_USER_ID = /*:UserIdSearch*/'searchUser'
2323 ORDER BY
2424 K.JOB_SEQ DESC
2525 OFFSET ((/*?Page*/1 - 1) * /*?Line*/20 ) LIMIT /*?Line*/20