AnsweredAssumed Answered

xog to update odf_ca_resource srm_resources tables

Question asked by tnestor on Oct 16, 2013
Latest reply on Oct 16, 2013 by another_martink
I need to be able to update the odf_ca_resource table
for specific IDs I want to set the column lock_account = 1

The sql would be like
udpate odf_ca_resource
SET lock_account = 1
where ID in(111,222,333);

And I want to update the srm_resources table also

The SQL is
UPDATE srm_resources
SET is_active = 0
where ID in(111,222,333)

Can I do these both from XOG?

Outcomes