raw.txt
No One
Actions

Authored By

	stwalkerster
	May 23 2019, 11:13 PM

Size

368 B

Referenced Files

None

Subscribers

None

raw.txt
View Options

	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);