IBM Maximo: SQL Queries - WORKFLOW: Difference between revisions
No edit summary |
No edit summary |
||
Line 1: | Line 1: | ||
== Historico | |||
= 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 | select to_char(STARTTIME, 'YYYY') as YEAR1, count(1) as CONT | ||
Line 26: | Line 35: | ||
= Arquivamento= | |||
Queries uteis para arquivamento/exclusao de registros em tabelas | Queries uteis para arquivamento/exclusao de registros em tabelas |
Latest revision as of 16:23, 20 December 2021
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:
YEAR1 | CNT |
---|---|
2017 | 536611 |
2018 | 12263485 |
2019 | 17314752 |
2020 | 10712313 |
2021 | 20238022 |
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