From f4b928446cb72aa2f1c1ae8f86f5fbcf718cb2df Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Tue, 4 Sep 2018 05:59:09 -0400 Subject: [PATCH] fix bug in vivicate for stat cat entries Signed-off-by: Jason Etheridge --- sql/base/base.sql | 4 ++++ 1 files changed, 4 insertions(+), 0 deletions(-) diff --git a/sql/base/base.sql b/sql/base/base.sql index 35faab0..1e51df1 100644 --- a/sql/base/base.sql +++ b/sql/base/base.sql @@ -3346,6 +3346,7 @@ CREATE OR REPLACE FUNCTION migration_tools.vivicate_actor_sc_and_sce (TEXT,TEXT, WHERE owner = ANY ($2) AND BTRIM('||sc||') = BTRIM(name) ) AND value = BTRIM('||sce||') + AND owner = ANY ($2) ) AND NOT EXISTS ( SELECT id @@ -3356,6 +3357,7 @@ CREATE OR REPLACE FUNCTION migration_tools.vivicate_actor_sc_and_sce (TEXT,TEXT, WHERE owner = ANY ($2) AND BTRIM('||sc||') = BTRIM(name) ) AND value = BTRIM('||sce||') + AND owner = ANY ($2) ) ORDER BY 1,3;' USING org, org_list; @@ -4305,6 +4307,7 @@ CREATE OR REPLACE FUNCTION migration_tools.vivicate_asset_sc_and_sce (TEXT,TEXT, WHERE owner = ANY ($2) AND BTRIM('||sc||') = BTRIM(name) ) AND value = BTRIM('||sce||') + AND owner = ANY ($2) ) AND NOT EXISTS ( SELECT id @@ -4315,6 +4318,7 @@ CREATE OR REPLACE FUNCTION migration_tools.vivicate_asset_sc_and_sce (TEXT,TEXT, WHERE owner = ANY ($2) AND BTRIM('||sc||') = BTRIM(name) ) AND value = BTRIM('||sce||') + AND owner = ANY ($2) ) ORDER BY 1,3;' USING org, org_list; -- 1.7.2.5