Hi community,
I'm working on a new view object to create custom dasboards for my customer based on Bulk Email stats. I noticed that Creatio has an OOTB View object called "VwBulkEmailAudience" which is based on "BulkEmailTarget", "BETArchiveFirstGeneration" and "BETArchiveSecondGeneration".
Does anybody knows what the least two tables are used for? I have checked both the local-dev and the production site, and those tables are empty.
I enclose the script for the OOTB View in case you'd like to gain a better understanding of what I'm talking about.
Thank you in advance guys and girls! Have a nice day :)
-- View: public."VwBulkEmailAudience"
-- DROP VIEW public."VwBulkEmailAudience";
CREATE OR REPLACE VIEW public."VwBulkEmailAudience" AS
SELECT "BET"."MandrillId" AS "Id",
"BET"."CreatedOn",
"BET"."ModifiedOn",
"BET"."BulkEmailId",
"BET"."ContactId",
"BET"."EmailAddress",
"BERR"."DCReplicaId" AS "ReplicaId",
"BET"."LinkedEntityId",
"BET"."BulkEmailResponseId",
"BET"."Clicks",
"BET"."Opens",
"BET"."ProviderName",
NULL::text AS "SessionId",
0 AS "IsSent"
FROM "BulkEmailTarget" "BET"
LEFT JOIN "BulkEmailRecipientReplica" "BERR" ON "BERR"."RecipientId" = "BET"."MandrillId"
UNION ALL
SELECT "FG"."MandrillId" AS "Id",
"FG"."CreatedOn",
"FG"."ModifiedOn",
"FG"."BulkEmailId",
"FG"."ContactId",
"FG"."EmailAddress",
"BERR"."DCReplicaId" AS "ReplicaId",
"FG"."LinkedEntityId",
"FG"."BulkEmailResponseId",
"FG"."Clicks",
"FG"."Opens",
"FG"."ProviderName",
NULL::text AS "SessionId",
0 AS "IsSent"
FROM "BETArchiveFirstGeneration" "FG"
LEFT JOIN "BulkEmailRecipientReplica" "BERR" ON "BERR"."RecipientId" = "FG"."MandrillId"
UNION ALL
SELECT "SG"."MandrillId" AS "Id",
"SG"."CreatedOn",
"SG"."ModifiedOn",
"SG"."BulkEmailId",
"SG"."ContactId",
"SG"."EmailAddress",
"BERR"."DCReplicaId" AS "ReplicaId",
"SG"."LinkedEntityId",
"SG"."BulkEmailResponseId",
"SG"."Clicks",
"SG"."Opens",
"SG"."ProviderName",
NULL::text AS "SessionId",
0 AS "IsSent"
FROM "BETArchiveSecondGeneration" "SG"
LEFT JOIN "BulkEmailRecipientReplica" "BERR" ON "BERR"."RecipientId" = "SG"."MandrillId";
ALTER TABLE public."VwBulkEmailAudience"
OWNER TO puser;