Hi,

We're trying to do a mass approval for a bunch of files after the fact (unfortunately the 'approve' checkbox was checked for a while).

Any ideas?

Thanks,

Neal

Hi Neal,

Bunch approval in the UI would mean going to "unapproved items" and selecting all items in the grid and then on the "selection" menu selecting "approve". If you want to sweep your whole DMX and approve anything that is in there then you can do it in SQL by updating the IsApproved field to 1 for all records in DMX_Entries.

Looking at your post again I guess you also wish to remove the approval permission setting on existing entries. I.e. remove all approval workflows from your DMX. You can do that with the following bit of SQL:

DELETE FROM {databaseOwner}{objectQualifier}DMX_EntryPermissions
FROM {databaseOwner}{objectQualifier}DMX_EntryPermissions ep
INNER JOIN {databaseOwner}{objectQualifier}DMX_Permissions p ON p.PermissionId=ep.PermissionId
WHERE p.PermissionKey='APPROVE'

Note this does it for all portals. To limit by portal set p.PortalId=[your portal id]

Peter

Hi Peter,

Thanks, I think we got it figured out.

Neal