[dbo].[e2e_wrm_wrmreporthnotrollv]
create view "e2e_wrm_wrmreporthnotrollv" AS
SELECT "e2e_wrm_wrmreport"."sourceid", DATEPART([year], timestart) AS y, DATEPART([month], timestart) AS m, DATEPART([day], timestart) AS d, "e2e_wrm_wrmreport"."identifierid", "e2e_wrm_wrmreport"."typeid", "e2e_wrm_wrmreport"."urlid"
FROM "e2e_wrm_wrmreport"
WHERE (timefactor = 1) AND (issent = 0 OR issent IS NULL) AND (typeid = 1 OR typeid = 2)
GROUP BY sourceid, transactionid, DATEPART([year], timestart), DATEPART([month], timestart), DATEPART([day], timestart), identifierid, typeid, urlid
GO
GRANT SELECT ON [dbo].[e2e_wrm_wrmreporthnotrollv] TO [apmadmin]
GO
