Besides Raf suggestion, there are two other routes... 

The first being to export to Excel and do your action there. The https://github.com/dfinke/ImportExcel module is very handy for that. So with that PowerShell module installed, your command would look:

Find-IshPublicationOutput | Export-Excel

To stay within PowerShell, I would use:

Find-IshPublicationOutput | Sort-Object -Property IshRef,version_version_value -Unique

Hi Dave, if I would like the highest version of the available ones in my search result, is there way to do that using this line of code?

Hi Dave, if I would like the highest version of the available ones in my search result, is there way to do that using this line of code?

Hi Pia,

Just to make sure, the ISHRemote terminology is that a "Find" operator is a relational database query (think SQL Server, Oracle, etc). And a "Search" is a Full-Text-Index (think Solr, OpenSearch, Google, etc) query. I assume a "Find" because you want an exact answer. Beware that a Find-result could theoretically return your full database if you don't filter enough; which is okay on smaller CMS instances, but coudl be problematic for enterprise sizes.

The API call used behind Find-IshPublicationOutput is PublicationOutput 2.5 Find which in turn states "When filtering on version numbers in psXMLMetaDataFilter, only exact version numbers can be used.". There are API calls that allow you to use the LATEST keyword as a version filter as described on Understanding how version numbers behave.

So server-side filtering close to the data, not in the ISHRemote client, you can do

$ishObjects = Get-IshFolder -BaseFolder Data -FolderTypeFilter @("ISHPublication") -Recurse | Get-IshFolderContent -VersionFilter LATEST

So the Get-IshFolder iteratively loops your repository folder structure and only passes Publication folders to the next cmdlet. This next Get-IshFolderContent cmdlet only retrieves LATEST versions of Publications. You can also use this cmdlet to filter even further adding language or other metadata filters like

$metadataFilter = Set-IshMetadataFilterField -Level Lng -Name FISHPUBSTATUS -ValueType Element -FilterOperator In -Value VPUBSTATUSUNPUBLISHFAILED
$ishObjects = Get-IshFolder -BaseFolder Data -FolderTypeFilter @("ISHPublication") -Recurse | Get-IshFolderContent -VersionFilter LATEST -LanguagesFilter ('en-US','de-DE') -MetadataFilter $metadataFilter

Best wishes,
Dave