Skip to main content
SharePoint

Return to Question

Tweeted twitter.com/StackSharePoint/status/919713142120370177
edited tags
Link
Mohamed El-Qassas MVP ♦
Mohamed El-Qassas MVP ♦
  • 45.4k
  • 9
  • 54
  • 96
Source Link
Frank
Frank
  • 241
  • 2
  • 8

Rest API Refinement Filter on Lookup Column

I am able to use the refinementfilters with the search api to refine a search for documents in a document library with this:

/_api/search/query?querytext='(Search Term)+AND+(path:https://mysite.sharepoint.com/MySite/MyDocLibrary)'&refinementfilters='Color:equals("Green")'

In this case I have a site column named Color, and I added the alias Color to the existing managed property RefinableString00 and mapped it to the Color column.

That works fine and it will refine the search to documents that contain the search term and also match the color property equal to "Green".

But is there anyway to refine a search based on values in a lookup column, if that lookup column allows multiple values?

So if the lookup column was called Skills (referencing a list called Skills), and a document might have multiple values for Skills (e.g. Javascript, Python, PHP, etc.) is there a way to use refinement filters for something like that within the Rest API?