A new Flexera Community experience is coming on November 18th, click here for more information.
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.
Mar 26, 2024 12:00 PM
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.
Mar 29, 2024 12:02 PM - edited Mar 29, 2024 12:04 PM
Is this to exclude users from an entire approval workflow or just a specific step within an approval workflow?
Mar 26, 2024 01:20 PM
From the entire workflow. I need to exclude Managers and above who are in the security group
Mar 26, 2024 01:51 PM
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.
Mar 29, 2024 12:02 PM - edited Mar 29, 2024 12:04 PM
Thank you Jim!
Mar 29, 2024 05:18 PM