Hi,
I want to use a list of usernames in Set-IshMetadataFilterField to filter out those users from the results returned.
I have played around with versions of below but cannot arrive at the correct phrase.
$safelist = @("name1", "name2")
Set-IshMetadataFilterField -Name USERNAME -Level None -FilterOperator IN -Value $safelist
Can anyone advise the structure of filtering out based on USERNAME not appearing in a user-defined list?
Any advice appreciated,
Regards,
Ann
I figured out that I could do this using Where-Object as follows
$safelist = @("name1", "name2", "name3")
$ishUsers = Find-IshUser -IshSession $ishSession -MetadataFilter $filterMetadata | Where-Object -Property FISHEXTERNALID -CNotIn $safelist
Hi Ann,
Your Where-Object is a good solution! The only thing I want to point out is that it means that you pass more data to your client (so PowerShell.exe process). So you are actually filtering client-side.
To filter server-side, closer to the data(base) and in turn pass less information over the wire. You can use the below. Yes, the values are comma-space seperated for multi-value entries.
Translate
$metadataFilter = Set-IshMetadataFilterField -Level None -Name USERNAME -FilterOperator In -Value 'Admin, ddemeyer'
Find-IshUser -MetadataFilter $metadataFilter
# $userArray = @('Admin', 'ddemeyer')
# $userString = $userArray -join ', '
Best wishes,
Dave
PaperWriter's promo codes have been a lifesaver for my student budget. Despite the affordable prices, the quality of their work is never compromised. The writers are professionals, and the support team is quick to address any concerns. PaperWriter is a reliable option for students seeking quality essays without breaking the bank.
