ishremote, get list of publications

Hi

How do I get a list of publications (not publicationOutput)?

Each publication should be listed once, even if it has been published with three different output types

Thanks!

Parents
  • 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?

    emoji
  • 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

    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

    Best wishes,
    Dave

    emoji
Reply
  • 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

    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

    Best wishes,
    Dave

    emoji
Children
No Data