Hi,

The idea of "Language Applicability" is a powerful concept on single-sourcing content objects in the repository. In essence you are marking an image Logical-Version-Language entity with multiple languages so that it can be repurposed in all kinds of completion operations, status, workflow... this all without actual metadata and image file (and resolutions) duplication saving quite some governance and disk space.

The "in" clause ishoperator is in essence an OR among "zh_CN" and "en_US" and "es" as you noticed.

If you want an AND expression, then you need to offer more filter criteria. So every object has to pass all given filters with success. So can you try:

$metadataFilter = Set-IshMetadataFilterField -Name 'DOC-LANGUAGE'-level 'Lng' -ValueType 'Value' -FilterOperator 'Equal' -Value 'zh_CN' |
                  Set-IshMetadataFilterField -Name 'DOC-LANGUAGE'-level 'Lng' -ValueType 'Value' -FilterOperator 'Equal' -Value 'en_US' |
                  Set-IshMetadataFilterField -Name 'DOC-LANGUAGE'-level 'Lng' -ValueType 'Value' -FilterOperator 'Equal' -Value 'es'

If you need to go through a lot of material, I would advise to recursively iterate the folder structure to have bite-size chunks of information. The one call Find-IshDocumentObj could theoretically pull a full copy of your repository in memory which is for sure not advised. Some inspiration is on https://github.com/RWS/ISHRemote/blob/master/Doc/ReleaseNotes-ISHRemote-0.13.md#sample---custom-actions-across-folder-and-subfolders 

Best wishes,
Dave

Hi,

The idea of "Language Applicability" is a powerful concept on single-sourcing content objects in the repository. In essence you are marking an image Logical-Version-Language entity with multiple languages so that it can be repurposed in all kinds of completion operations, status, workflow... this all without actual metadata and image file (and resolutions) duplication saving quite some governance and disk space.

The "in" clause ishoperator is in essence an OR among "zh_CN" and "en_US" and "es" as you noticed.

If you want an AND expression, then you need to offer more filter criteria. So every object has to pass all given filters with success. So can you try:

$metadataFilter = Set-IshMetadataFilterField -Name 'DOC-LANGUAGE'-level 'Lng' -ValueType 'Value' -FilterOperator 'Equal' -Value 'zh_CN' |
                  Set-IshMetadataFilterField -Name 'DOC-LANGUAGE'-level 'Lng' -ValueType 'Value' -FilterOperator 'Equal' -Value 'en_US' |
                  Set-IshMetadataFilterField -Name 'DOC-LANGUAGE'-level 'Lng' -ValueType 'Value' -FilterOperator 'Equal' -Value 'es'

If you need to go through a lot of material, I would advise to recursively iterate the folder structure to have bite-size chunks of information. The one call Find-IshDocumentObj could theoretically pull a full copy of your repository in memory which is for sure not advised. Some inspiration is on https://github.com/RWS/ISHRemote/blob/master/Doc/ReleaseNotes-ISHRemote-0.13.md#sample---custom-actions-across-folder-and-subfolders 

Best wishes,
Dave

Thanks Dave, the code you provided works well.

I had tried to performed a solr query before receiving your reply.

curl -o result.csv "">127.0.0.1:8078/.../select

then search for the "result.csv", to filter out image objs with multiplue values of LNG_DOC-LANGUAGE_STRMV

Hi ... Perhaps best to avoid direct Solr calls as you in turn skip business logic, security and more

But what about :) 

$xmlQuery = @"
    <ishquery>
      <and>
        <ishfield name='DOC-LANGUAGE' level='lng' ishoperator='equal'>en</ishfield>
        <ishfield name='DOC-LANGUAGE' level='lng' ishoperator='equal'>de</ishfield>
      </and>
      <ishsort>
        <ishsortfield name='ISHSCORE' level='none' ishorder='d'/>
        <ishsortfield name='FTITLE' level='logical' ishorder='d'/>
      </ishsort>
      <ishobjectfilters>
        <ishversionfilter>AllVersions</ishversionfilter>
        <ishtypefilter>ISHIllustration</ishtypefilter>
        <ishlanguagefilter>en</ishlanguagefilter>
      </ishobjectfilters>
    </ishquery>
"@
(Search-IshDocumentObj -XmlQuery $xmlQuery -MaxHitsToReturn 100).doclanguage