KQL Search with CollapseSpecification not working

Asked Nov 14 '22 at 08:05

Active Nov 14 '22 at 08:07

Viewed 40 times

I use KQL Search with CollapseSpecification to search within document libraries on several tenants without any problems, but on one tenant this does not work.

I have revised the search patterns and re-indexed the entire site collection but it is not working. Is there any functionality/configuration I need to enable to make CollapseSpecification work in KQL Search?

I tried the following query with REST Api:

https://{mySharePointSite}/_api/search/query?querytext='test'&selectproperties='RefinableDecimal01'&collapsespecification='RefinableDecimal01'

with or without CollapseSpecification I get 3 results, all items have RefinableDecimal01=34 so the expected result should be 1

The same behaviour occurs with the CSOM code below:

KeywordQuery keywordQuery = new KeywordQuery(context);
keywordQuery.QueryText = "test"
keywordQuery.CollapseSpecification = "RefinableDecimal01";
keywordQuery.SelectProperties.Add("RefinableDecimal01");

Can you help me.

THX