Filter multi select list based on another list

Question

Hi, 
 
 I&rsquo;ve got a project object with two properties: &ldquo;project team&rdquo; and &ldquo;project lead&rdquo;. Both properties are from an &ldquo;employee&rdquo; list. 
 I would like to filter the selection for the &ldquo;project lead&rdquo; list to only show people already chosen as members of the project team. I tried &ldquo;filtering based on another property&rdquo;, but this didn&rsquo;t achieve the expected outcome. Is there anyway to filter a list more dynamically (specifically telling it HOW to filter from a different property)? 
 
 Cheers, 
 matt

MattG · Accepted Answer

I ended up implementing this as a validation on the "project lead" property, so although it won't filter it will throw an error if the project lead isn't found in the project team. 
 Option Explicit

Dim oPropVals : Set oPropVals = Vault.ObjectPropertyOperations.GetProperties (ObjVer,False)

Dim lead, member, leads, projectTeam, match

' get all members of project team
Set projectTeam = oPropVals.SearchForProperty(1185).TypedValue.GetValueAsLookups()

Set leads = PropertyValue.TypedValue.GetValueAsLookups()

' check whether each lead is a member of the project team
For Each lead in leads
	match = false
	For Each member in projectTeam
 if member.DisplayValue = lead.DisplayValue then
 match = true
 Exit For
 end if
	Next

	if not match then
 Err.Raise MFScriptCancel, "All technical leads must be members of the project team, please either add " + lead.DisplayValue + " to the project team or remove them as a technical lead."
	End If
Next

Filter multi select list based on another list

Top Replies