IBM Maximo: SQL Queries - WORKFLOW

From Wiki
Revision as of 16:23, 20 December 2021 by Ebasso (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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

Ver também