IBM Maximo: SQL Queries - tabela WFINSTANCE

From Wiki
Revision as of 21:03, 12 April 2022 by Ebasso (talk | contribs) (Criou a página com "= SQL Queries= = Historico = select to_char(STARTTIME, 'YYYY') as YEAR1, count(1) as CNT from wfinstance where active=0 and deletable=1 group by to_char(STARTTIME,...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

SQL Queries

Historico

select to_char(STARTTIME, 'YYYY') as YEAR1, count(1) as CNT
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


Ver também

Retrieved from "https://ebasso.net/wiki/index.php?title=IBM_Maximo:_SQL_Queries_-_tabela_WFINSTANCE&oldid=7597"