create view "e2e_wrm_wrmreporttraninotrollv" AS
       SELECT "e2e_wrm_wrmreport"."sourceid", "e2e_wrm_wrmreport"."transactionid",
        DATEPART([year], timestart) AS y, DATEPART([month], timestart) AS m, DATEPART([day], timestart) AS d, DATEPART([hour], timestart) AS h,
        "e2e_wrm_wrmreport"."identifierid", "e2e_wrm_wrmreport"."typeid"
       FROM "e2e_wrm_wrmreport"
       WHERE (timefactor = 0) AND (issent = 0 OR issent IS NULL) AND (typeid = 3 OR typeid = 4)
       GROUP BY sourceID, transactionid, DATEPART([year], timestart), DATEPART([month], timestart), DATEPART([day], timestart), DATEPART([hour], timestart), identifierid, typeid


GO
GRANT SELECT ON  [dbo].[e2e_wrm_wrmreporttraninotrollv] TO [apmadmin]
GO