Get Only one language version per item by using Find-Item

Question

I am using a PowerShell script given below

 $indexName = "sitecore_web_index"
    $criteria = @(
                    @{Filter = "Contains"; Field = "industry_sm"; Value = "{7451A225-6450-4D26-BE04-624FD2E63B76}" },
                    @{Filter = "Contains"; Field = "service_sm"; Value = "{0670EE3C-1D07-4172-9ADB-19127D90C180}" }
                )
     $list = Find-Item -Index $indexName -Criteria $criteria | Initialize-Item

It returns a list of all present language versions per item. Is it possible somehow through the script to make it return only one language version per item (English by default or other if English is not present)?

Answer 1

To achieve the desired result, the Find-Item function alone won't suffice; additional logic is required.

Here's a working example:

$indexName = "sitecore_web_index"
$criteria = @(
    @{Filter = "Contains"; Field = "industry_sm"; Value = "{7451A225-6450-4D26-BE04-624FD2E63B76}" },
    @{Filter = "Contains"; Field = "service_sm"; Value = "{0670EE3C-1D07-4172-9ADB-19127D90C180}" }
)

# Find items matching the criteria and group them by item ID
$list = Find-Item -Index $indexName -Criteria $criteria | Group-Object -Property ItemId

# Initialize only one language version per item (preferably English)
$filteredList = $list | % { $_.Group | Sort-Object { if ($_.Language -eq "en") { 0 } else { 1 } } | Select-Object -First 1 | Initialize-Item }

# $filteredList now contains one language version per item
foreach($filteredItem in $filteredList){
    Write-Host "Item ID: $($filteredItem.ID), Language: $($filteredItem.Language), Name: $($filteredItem.Name)"
}

Answer 2

Try out this code, You can filter content by language using Dynamic LINQ syntax and get results with where a condition for a single language.

$criteria = @(
    @{Filter = "Contains"; Field = "industry_sm"; Value = "{7451A225-6450-4D26-BE04-624FD2E63B76}" },
    @{Filter = "Contains"; Field = "service_sm"; Value = "{0670EE3C-1D07-4172-9ADB-19127D90C180}" }
)

$props = @{
    Index = "sitecore_web_index"
    Criteria = $criteria
    Where = "Language=@0"
    WhereValues = "en"
}

Find-Item @props

Read more details: https://doc.sitecorepowershell.com/appendix/indexing/find-item#example-1

Hope it helps!