my code stock.com

marcus.sacramento

QR ARS BACKLOG REABERTURA
by marcus.sacramento

Extração Diária do Backlog de Chamados Reabertos

Snippet options

Download: Download snippet as qr-ars-backlog-reabertura.sql.
Copy snippet: For this you need a free my code stock.com account.
Embed code : You will find the embed code for this snippet at the end of the page, if you want to embed it into a website or a blog!

SELECT
     A.C1 ARS_T90,
     count(B.C536870916) AS Reaberturas
FROM [email protected] A, [email protected] B
WHERE A.C536870990 LIKE 'OPERACAO_INV_%'
AND A.C536870990 NOT LIKE '%PROB%'
AND A.C536870990 NOT LIKE 'OPERACAO_INV%PROATIVO%'
AND (A.C7 < 7)
and A.C536871023 = 0
AND A.C3 < ((  TO_DATE ('11/07/2011 00:00:00', 'DD/MM/YYYY HH24:MI:SS') 
            - TO_DATE ('31/12/1969 21:00:00', 'DD/MM/YYYY HH24:MI:SS')
           )
         * 86400)         
AND B.C536870913 = A.C1
and B.C536870914 in (7,9)
GROUP BY A.C1;

Create a free my code stock.com account now.

my code stok.com is a free service, which allows you to save and manage code snippes of any kind and programming language. We provide many advantages for your daily work with code-snippets, also for your teamwork. Give it a try!

Find out more and register now

You can customize the height of iFrame-Codes as needed! You can find more infos in our API Reference for iframe Embeds.