glints
.analytics
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
recount_action_logs_summary()
Parameters
Name
Type
Mode
IN
Definition
BEGIN IF (NEW.flag_recount = TRUE) THEN UPDATE analytics."ActionLogSummary" SET (flag_recount, count) = ( FALSE, ( SELECT count(*) FROM public."ActionLogs" WHERE object = OLD.object AND action = OLD.action AND collection = OLD.collection ) ) WHERE object = OLD.object AND action = OLD.action AND collection = OLD.collection; END IF; RETURN NULL; END