TStevenson asked a question.
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.
Is this to exclude users from an entire approval workflow or just a specific step within an approval workflow?
From the entire workflow. I need to exclude Managers and above who are in the security group
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.
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.