database:functions:pears_shiftbackcolouroverride



pears.ShiftBackColourOverride

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Original SQL

CREATE FUNCTION "pears"."ShiftBackColourOverride"( IN "shiftid" CHAR(20),IN "planid" CHAR(20) ) 
RETURNS INTEGER
BEGIN
  -- return 1 to apply colour
  IF "isnull"("shiftid",'') > '' THEN
    -- shift logic
  END IF;
  IF "isnull"("planid",'') > '' THEN
    -- shiftplan logic
  END IF;
  RETURN 0
END
  • database/functions/pears_shiftbackcolouroverride.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1