Approver exclude table

[TeriStevenson]

I am trying to find the table that holds the package id and the security group exclude condition.  I have 165 catalog item that I need to add an exclude condition on for a particular security group and would like to use SQL to do inserts unless that's not recommended.  I'm trying to avoid manually opening each item to configure this.

[jdempsey]

Is this to exclude users from an entire approval workflow or just a specific step within an approval workflow?

[TeriStevenson]

From the entire workflow.  I need to exclude Managers and above who are in the security group

[jdempsey · Accepted solution]

Sorry for the delayed reply.  Looks like these conditions are stored in WD_PackageProperty.

PackageID_FK holds the catalog item package ID, PropertyName would be memberOf (for AD group conditions), PropertyValue would be the AD GUID of the group, Operator would be equals (=), and Visible would be 0 (Exclude).

Also, it looks like there is a MemberOfGroup column in WD_WebPackages that gets set to 1 when there is an approval condition set.

[TeriStevenson]

Thank you Jim!