View source for IBM Maximo: SQL Queries - tabela WFINSTANCE

= 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:

{| class="wikitable"
|-
! YEAR1 !! CNT 
|-
| 2017 || 536611
|-
| 2018 || 12263485
|-
| 2019 || 17314752
|-
| 2020 || 10712313
|-
| 2021 || 20238022
|}


= Ver também =

* [[IBM Maximo| Artigos sobre IBM Maximo]]
* [[Tecnologias|  Mais Artigos sobre Cloud / WebDev / Tecnologias]]

[[Category:IBM Maximo]]
[[Category:ibm-maximo-sql]]
[[Category:ibm-maximo-performance]]