From d04fccff648c46bde3d7dd3905d73d26c55fa6ee Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Tue, 9 Jun 2026 23:28:03 +0000 Subject: [PATCH] Validate AGGRESSIONS.ExtractedBy against PEOPLE.Active --- db/schemas/lib/triggers/create/aggressions.m4 | 29 +++++++++++++++++++ 1 file changed, 29 insertions(+) diff --git a/db/schemas/lib/triggers/create/aggressions.m4 b/db/schemas/lib/triggers/create/aggressions.m4 index f65a674..31e5fe6 100644 --- a/db/schemas/lib/triggers/create/aggressions.m4 +++ b/db/schemas/lib/triggers/create/aggressions.m4 @@ -123,6 +123,35 @@ CREATE OR REPLACE FUNCTION aggressions_func () END; END IF; + changequote({,})dnl + person_active({AGGRESSIONS}, {ExtractedBy}, + {'Key (EID = (' + || NEW.eid + || '): Value (Decided) = (' + || NEW.Decided + || '): Value (MultiAggressors) = (' + || NEW.multiaggressors + || '): Value (MultiRecipients) = (' + || NEW.multirecipients + || '): Value (BadObs) = (' + || NEW.badobs + || '): Value (Bristle) = (' + || NEW.bristle + || '): Value (Display) = (' + || NEW.display + || '): Value (Chase) = (' + || NEW.chase + || '): Value (Contact) = (' + || NEW.contact + || '): Value (Vocal) = (' + || NEW.vocal + || '): Value (severity) = (' + || NEW.severity + || '): Value (CommID) = (' + || NEW.commid + || ')'}) + changequote(`,')dnl + RETURN NULL; END; $$; -- 2.34.1