Index: FOPQueue.csp =================================================================== diff -u -r20 -r38 --- FOPQueue.csp (.../FOPQueue.csp) (revision 20) +++ FOPQueue.csp (.../FOPQueue.csp) (revision 38) @@ -232,6 +232,7 @@


+

Edit the global ^Sys.FOP.Settings

@@ -286,7 +287,7 @@ /*** SQL STATEMENTS ***/ /*** ============== ***/ ; SQL-statement for FOP Queue - Set sqlFOP="SELECT Top 100 ID,Status,Priority,RunMode,Task,Task->KeyWords As Task_KeyWords,Task->ActionToString, Task->DocInfo , Created,Started,Finished,(InternePersoonInits || ' - ' || InternePersoon) As InternePersoon " + Set sqlFOP="SELECT ID,Status,Priority,RunMode,Task,Task->KeyWords As Task_KeyWords,Task->ActionToString, Task->DocInfo , Created,Started,Finished,(InternePersoonInits || ' - ' || InternePersoon) As InternePersoon " Set sqlFOP=sqlFOP_$C(13,10)_" FROM Sys_FOP.TaskQueue WHERE (ID > 1) " Set sqlFOP=sqlFOP_$C(13,10)_" ORDER BY StatusNum DESC, ID, Priority DESC " ; SQL-statement for FOP QueueArchive Index: FOPQueueMgr.csp =================================================================== diff -u -r20 -r38 --- FOPQueueMgr.csp (.../FOPQueueMgr.csp) (revision 20) +++ FOPQueueMgr.csp (.../FOPQueueMgr.csp) (revision 38) @@ -264,7 +264,7 @@ /*** SQL STATEMENTS ***/ /*** ============== ***/ ; SQL-statement for FOP Queue - Set sqlFOP="SELECT Top 100 ID,Status,Priority,RunMode,Task,Task->KeyWords As Task_KeyWords, Created,Started,Finished,(InternePersoonInits || ' - ' || InternePersoon) As InternePersoon " + Set sqlFOP="SELECT ID,Status,Priority,RunMode,Task,Task->KeyWords As Task_KeyWords, Created,Started,Finished,(InternePersoonInits || ' - ' || InternePersoon) As InternePersoon " Set sqlFOP=sqlFOP_$C(13,10)_" FROM Sys_FOP.TaskQueue WHERE (ID > 1) "_$S($L(HideStatusList):" AND (Status NOT in "_HideStatusList_") ", 1:"") Set sqlFOP=sqlFOP_$C(13,10)_" ORDER BY StatusNum DESC, ID, Priority DESC " ; SQL-statement last three IDs