Histórico da Página

HTML
<center><img src="http://confluence.agriness.com/download/attachments/64131649/hat.png" width=90px><font size="5000">SUPORTES ABERTOS</font></center>

SQL

dataSource	SIA
style	font-weight:bold;font-size:1.5em;
rowOrientation	horizontal
enableHighlighting	false
output	wiki
autoNumber	true

SELECT count('{column:width=100px}{html}<font size=25>' || CAST(COUNT(*) AS "TotalVARCHAR(10)) || '</font>{html}{column}' AS "{html}<font size=25>Total atual</font>{html}"
  FROM esiaProcesso p
 WHERE p.cdSituacao <> 6
       AND p.cdCategoriaEvento = 2
       AND p.cdEntidade <> 526

SQL

dataSource	SIA
style	font-weight:bold;font-size:1.5em;
rowOrientation	horizontal
enableHighlighting	false
output	wiki
heading	0

   SELECT '{html}<font size=10>' || gr.nmGrupoUsuario || '</font>{html}', count('{html}<font size=10>' || CAST(COUNT(*) AS VARCHAR(10)) || '</font>{html}'
     FROM esiaProcesso p
LEFT JOIN eanGrupoUsuario gr on gr.cdGrupoUsuario = p.cdGrupoResponsavel
    WHERE p.cdSituacao <> 6
          AND p.cdCategoriaEvento = 2
          AND p.cdEntidade <> 526
 GROUP BY p.cdGrupoResponsavel, gr.nmGrupoUsuario
 ORDER BY p.cdGrupoResponsavel

HTML
<br><font size=10>Evolução dos suportes abertos</font><br>

Gráfico

bgColor	#222222
orientation	vertical
subTitle	.
dataOrientation	vertical
borderColor	#DDDDDD
height	400
colors	#66B2FF
legend	false
width	1200
line-width	5
rangeAxisLowerBound	30
type	line

SQL

dataSource	SIA

   SELECT to_char(PRINCIPAL.SEMANA, 'DD/MM'),
          (SELECT COUNT(*)
             FROM log_esiaProcesso logp
        LEFT JOIN esiaProcesso p ON p.cdProcesso = logp.new_cdProcesso
            WHERE logp.new_cdSituacao <> 6
                  AND logp.new_cdCategoriaEvento = 2
                  AND logp.new_cdEntidade <> 526
                  AND p.cdEntidade <> 526
                  AND cdLogProcesso IN (SELECT MAX(logp.cdlogprocesso)
                                          FROM log_esiaProcesso logp
                                         WHERE logp.new_cdEntidade <> 526
                                               AND logp.dtRegistro <= PRINCIPAL.SEMANA
                                      GROUP BY logp.new_cdProcesso)
       AND logp.new_cdProcesso IN (SELECT cdProcesso FROM esiaProcesso)) 
FROM (SELECT CAST(data AS DATE) AS SEMANA FROM (select generate_series ('2018-08-10'::timestamp, '2018-12-31'::timestamp, '1 week'::interval) as data) as serie) AS Principal
WHERE PRINCIPAL.SEMANA <= date_trunc('week', current_date + 7) - interval '3 days'

Árvore de páginas

Versões comparadas

Old Version 2

Nova versão Current

Chave