DQL to update acl of only unlocked Objects inside a folder

can any one suggest how to update same ACL to only unlocked objects inside a particular folder.

Thanks in advance.

Find more posts tagged with

update ... where r_lock_owner = ''

If you need to, you can also unlock locked objects before updating ACL on all the docs in the folder:

update my_type object set r_lock_owner = '' where r_lock_owner <> ' ' and folder('/cabinet1/folder1')