Update property patterns values with powershell

Question

Hi team,

I would like to update allowed values of a property pattern and found this script: https://www.adaxes.com/script-repository/add-new-allowed-property-value-to-a-property-pattern-s585.htm

However this will only work for one new value. How can I add multiple new values? I tried already a foreach around it, but not working properly :/

Comments

Hello,

How exactly are you going to specify the values? Is it going to be in a custom command parameter? If so, how exactly are the values going to be specified? Please, describe the desired workflow in all the possible details with live examples.

---

Morning,

it is working now, I needed to remove one break command

Here is the script

$propertyName = "adm-CustomAttributeText1"
$propertyPatternDN = "xxxx" 
$namesDomains = @("Value1","Value2")

foreach($parameterValue in $namesDomains) {        
    # Bind to the Property Pattern
    $userPattern = $Context.BindToObject("Adaxes://$propertyPatternDN")
    $values = New-Object System.Collections.ArrayList
    $isPropertyRequired = $False
    foreach ($item in $userPattern.Items) {
        if ($item.PropertyName -ne $propertyName) {
            continue
        } 

        $constraints =  $item.GetConstraints()
        $constraint = $constraints.GetConstraint("ADM_PROPERTYCONSTRAINTCATEGORY_VALUEFORMAT")

        # Check if new value exists
        if ($constraint.Values -contains $parameterValue) {
            continue
        }

        # Get current values
        $constraint.Values | %%{[void]$values.Add($_)}
        $isPropertyRequired = $item.IsPropertyRequired

        # Remove Property Pattern item
        $userPattern.Items.Remove($item)
    }

    # Add new value
    [void]$values.Add($parameterValue)

    # Sort values
    $values.Sort()

    # Update Property Pattern
    $item = $userPattern.Items.Create()
    $item.PropertyName = $propertyName
    $item.IsPropertyRequired = $isPropertyRequired

    $constraints = $item.GetConstraints()
    $constraint = $constraints.Create("ADM_PROPERTYCONSTRAINTTYPE_VALUERANGE")
    $constraint.AreValuesDenied = $False
    $constraint.Values = $values.ToArray()
    $constraints.Add($constraint)
    $item.SetConstraints($constraints)

    # Save the changes
    $item.SetInfo()
    $userPattern.Items.Add($item)
}

Answer 1

Hello,

Your approach cannot be used in the UI as the values must be entered directly in the script. In this case, it is probably easier to just use the Administration console to add the required values. Also, your script will make a lot of extra work including the binding to the property pattern separately for each value in the predefined array. If that is the approach you want to use, here is the updated script that will do the trick.

$propertyName = "company" # TODO: modify me
$propertyPatternDN = "CN=My Pattern,CN=Property Patterns,CN=Configuration Objects,CN=Adaxes Configuration,CN=Adaxes" # TODO: modify me
$valuesToAdd = @("value1", "value2")

# Form new values list
$values = New-Object System.Collections.ArrayList
foreach ($valueToAdd in $valuesToAdd)
{    
    [void]$values.Add($valueToAdd)
}

# Bind to the Property Pattern
$userPattern = $Context.BindToObject("Adaxes://$propertyPatternDN")
$isPropertyRequired = $False
foreach ($item in $userPattern.Items)
{
    if ($item.PropertyName -ne $propertyName)
    {
        continue
    }

    $constraints =  $item.GetConstraints()
    $constraint = $constraints.GetConstraint("ADM_PROPERTYCONSTRAINTCATEGORY_VALUEFORMAT")

    # Get current values
    $constraint.Values | Where-Object { $values -notcontains $_ } | %%{[void]$values.Add($_)}
    $isPropertyRequired = $item.IsPropertyRequired

    # Remove Property Pattern item
    $userPattern.Items.Remove($item)
    break
}

# Sort values
$values.Sort()

# Update Property Pattern
$item = $userPattern.Items.Create()
$item.PropertyName = $propertyName
$item.IsPropertyRequired = $isPropertyRequired

$constraints = $item.GetConstraints()
$constraint = $constraints.Create("ADM_PROPERTYCONSTRAINTTYPE_VALUERANGE")
$constraint.AreValuesDenied = $False
$constraint.Values = $values.ToArray()
$constraints.Add($constraint)
$item.SetConstraints($constraints)

# Save the changes
$item.SetInfo()
$userPattern.Items.Add($item)

Comments

Thank you so much for this! Working!

---

One more question. I noticed the "Hint & Help" area is overwritten also and empty after script was excecuted. Can I add this as well via Script?

---

Hello,

The behavior is expected similarly to the option making the property required. You can retrieve the hint and help tests into variables and then add them to the new property item being created. The following article should be helpful: https://adaxes.com/sdk/IAdmPropertyPatternItem.

---

Thanks, working like a charm now.

Updates script for reference

$propertyName = "company" # TODO: modify me
$propertyPatternDN = "CN=My Pattern,CN=Property Patterns,CN=Configuration Objects,CN=Adaxes Configuration,CN=Adaxes" # TODO: modify me
$valuesToAdd = @("value1", "value2")

# Form new values list
$values = New-Object System.Collections.ArrayList
foreach ($valueToAdd in $valuesToAdd)
{    
    [void]$values.Add($valueToAdd)
}

# Bind to the Property Pattern
$userPattern = $Context.BindToObject("Adaxes://$propertyPatternDN")
$isPropertyRequired = $False
foreach ($item in $userPattern.Items)
{
    if ($item.PropertyName -ne $propertyName)
    {
        continue
    }

    $constraints =  $item.GetConstraints()
    $constraint = $constraints.GetConstraint("ADM_PROPERTYCONSTRAINTCATEGORY_VALUEFORMAT")

    # Get current values
    $constraint.Values | Where-Object { $values -notcontains $_ } | %%{[void]$values.Add($_)}
    $isPropertyRequired = $item.IsPropertyRequired
    $hint = $item.Hint
    $customHelpText = $item.CustomHelpText
    $propertyInfoMode = $item.PropertyInfoMode

    # Remove Property Pattern item
    $userPattern.Items.Remove($item)
    break
}

# Sort values
$values.Sort()

# Update Property Pattern
$item = $userPattern.Items.Create()
$item.PropertyName = $propertyName
$item.IsPropertyRequired = $isPropertyRequired
$item.Hint = $hint
$item.CustomHelpText = $customHelpText
$item.PropertyInfoMode = $propertyInfoMode

$constraints = $item.GetConstraints()
$constraint = $constraints.Create("ADM_PROPERTYCONSTRAINTTYPE_VALUERANGE")
$constraint.AreValuesDenied = $False
$constraint.Values = $values.ToArray()
$constraints.Add($constraint)
$item.SetConstraints($constraints)

# Save the changes
$item.SetInfo()
$userPattern.Items.Add($item)