(An Untitled Masterwork)
ActivePublic
Actions

Authored by stwalkerster on May 23 2019, 11:13 PM.

Tags

None

Referenced Files

	F151569: raw.txt
	May 23 2019, 11:13 PM

Subscribers

None

	select replace(s.vsql, '$$ID$$', r.id) from request r
	cross join (
	select 'INSERT INTO log (objectid, objecttype, user, action, timestamp) VALUES ($$ID$$, ''Request'', 7, ''Deferred to users'', current_timestamp());' as vsql from dual
	union all select 'UPDATE request SET status = ''Open'', reserved = 0 WHERE id = $$ID$$;' from dual
	) s where r.id in (1,2,3,4,5,6,7);

stwalkerster created this object with visibility "Public (No Login Required)".

(An Untitled Masterwork)ActivePublicActions