IF NEW.status = 'present' AND (OLD.status IS NULL OR OLD.status != 'present') THEN -- Use the session_duration from NEW (which should be set explicitly) -- Check if session_duration is NULL or 0, if ...
server=tcp:sql-server,1433;IntegratedSecurity=true;TrustServerCertificate=true;User ID=${arg.default-sql-server-user};Password=${arg.default-sql-server-password} EXEC ...