CASE SELECT

caseSelect.sql

SELECT 
   P.DESTIPOPROC
   ,COUNT(P.DESTIPOPROC) AS TOTAL
FROM PROTOCOLO.HISTORICO H 
   RIGHT JOIN PROTOCOLO.PROCESSOS P ON (P.NUMPROCESSO=H.NUMPROCESSO) 
   JOIN PROTOCOLO.INTERESSADOS I ON (I.NUMPROCESSO=P.NUMPROCESSO) 
WHERE TO_CHAR(H.DATTRAMITOU ,'DD/MON/YYYY') BETWEEN TO_DATE('{?Pm-DataIni}','DD/MM/YYYY') AND TO_DATE('{?Pm-DataFim}','DD/MM/YYYY') 
   AND
   1 = ( CASE WHEN {?Pm-CargoA} = -1 THEN 1
              WHEN H.CODORGAO = {?Pm-CargoA} THEN 1
         ELSE
         -1
         END )
   AND 
   1 = ( CASE WHEN {?Pm-CargoB} = -1 THEN 1
              WHEN TRIM(H.PARAORGAO) = TRIM((SELECT O.DESORGAO FROM PROTOCOLO.ORGAOS O WHERE O.CODORGAO = {?Pm-CargoB})) THEN 1
         ELSE
         -1
         END )
   AND 
   1 = ( CASE WHEN {?Pm-TipoProc} = -1 THEN 1
              WHEN P.CODTIPOPROC = {?Pm-TipoProc} THEN 1
         ELSE
         -1
         END )
   AND 
   1 = ( CASE WHEN {?Pm-Situacao} = -1 THEN 1
              WHEN P.CODSITUACAO = {?Pm-Situacao} THEN 1
         ELSE
         -1
         END )
   AND 
   1 = ( CASE WHEN {?Pm-Tramitou} = -1 THEN 1
              WHEN H.CODTRAMITOU = {?Pm-Tramitou} THEN 1
         ELSE
         -1
         END )
GROUP BY P.DESTIPOPROC