IBM Maximo: SQL Queries - WORKFLOW

= Lista todas as condições em workflow ativos para examinar onde as cláusulas=

select WFCONDITION.PROCESSNAME, WFCONDITION.NODEID, WFCONDITION.PROCESSREV, WFCONDITION.CONDITION, WFNODE.TITLE, WFNODE.NODETYPE from WFCONDITION join wfprocess on (WFPROCESS.PROCESSNAME = WFCONDITION.PROCESSNAME and WFPROCESS.ACTIVE = '1') join wfnode on (WFCONDITION.nodeid = WFNODE.NODEID and WFCONDITION.PROCESSREV = WFNODE.PROCESSREV and WFCONDITION.PROCESSNAME = WFNODE.PROCESSNAME and wfnode.processrev = wfprocess.processrev) order by WFCONDITION.PROCESSNAME, WFCONDITION.NODEID;

= Historico =

select to_char(STARTTIME, 'YYYY') as YEAR1, count(1) as CONT from wfinstance where active=0 and deletable=1 group by to_char(STARTTIME, 'YYYY') order by to_char(STARTTIME, 'YYYY')

result:

= Arquivamento=

Queries uteis para arquivamento/exclusao de registros em tabelas

select count(1) from wfinstance where active=0 and deletable=1

select count(1) from wfinstance where active=0 and deletable=1 and starttime < sysdate -90

select count(1) from wftransaction where wfid in  (select wfid from wfinstance where active=0 and deletable=1 and starttime < sysdate -90)

select count(1) from wfcallstack where wfid in  (select wfid from wfinstance where active=0 and deletable=1 and starttime < sysdate -90)

Dica de Delete Workflow History for Inactive Records

= Ver também =


 * Artigos sobre IBM Maximo
 * Mais Artigos sobre Cloud / WebDev / Tecnologias