1

How can I query against multiple fields in sharepoint default search?

enter image description here

I used Department:'ADB' and it worked, now I want to add few more columns like

Department:'ADB' & Title:'Mr' & Division:"ASN"

But its not working

1

You can use + instead of & it looks like below. make sure Department,Division are created as Managed property

Department:ADB+Title:Mr+Division:ASN

I tries like this it worked for me

path:"https://domain.sharepoint.com/sites/dev/Lists/Employee"+Title:Title1+Title:Title2

you can also try by keeping filter on refiners. For this you need to attach crawl property of Department field to RefinableString01 and crawl property of Division field to RefinableString02.

refinementfilters='and(RefinableString01:equals("ADB"),RefinableString02:equals("ASN"))

use the below search query tool to develop your query to filter on multiple managed properties/fields

http://sp2013searchtool.codeplex.com/

  • I created a managed property for a column, but its not working when I try with that – Vignesh Subramanian Mar 22 '17 at 9:18
  • 1
    You need to run the full crawl after creating the managed property – Suresh Bolineni Mar 22 '17 at 9:23
  • yeah I did that I am not sure if the managed property is mapped to the column in the list I am looking for is there a way to check that? – Vignesh Subramanian Mar 22 '17 at 9:26
  • Check in crawl properties with that name, it will create like this ows_Department, for the Managed property "Department" you should map the crawl property "ows_Department" – Suresh Bolineni Mar 22 '17 at 9:33
  • did you try this in default search box? Because I am not getting results if I use + It works when I search for one column though – Vignesh Subramanian Mar 22 '17 at 9:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.