0

I have a requirement for FQL search on SharePoint User Profile (SharePoint 2013). I can't use KQL since it doesnt do 'contains' searches.

I created a copy of the 'Local People Results' result source and set the Query Transform as:

{?andnot({searchTerms},filter(contentclass:"urn:content-class:SPSPeople*"))}

Fast search seems to be working.

I set the 'Type' field in the result source as 'SharePoint Search Results' and I am getting results for content in SharePoint site. But the results don't contain people. The query I used is Author:string("shaju").

But I set the Type to 'People Search Results' and don't get any results at all. The query I am using here is FirstName:string("shaju"). Firstname is a userprofile property.

I removed the QueryTransform tried a query in KQL(FirstName:shaju) and it works.any ideas on why FAST search is not providing results for people(user profile)?

Improve this question

1 Answer 1

Reset to default
1

People results are stored in the SharePoint index, not in the FS4SP index. Hence FQL will not work for people queries.

And KQL does do contains. Property:value is contains while Property=value is equals.

Author:Mikael

will return both "Mikael Svenson" as well as "Mr Mikael". Should work for FirstName as well I believe.

Improve this answer
4
  • Thanks for the reply Mikael. But from my testing, KQL does contains searches when the query contains a full word in the property . So 'FirstName:Mikael' would return both. But 'FirstName:ikae' wouldn't return any results.Do you have any ideas on overcoming this?
    – shajumohamed
    May 21, 2014 at 9:40
  • 1
    ikae would not work, as it's term by term contains, not letters contained in a word. What you want is pre/postfix wild cards, which is not supported by the SP index afaik.
    – Mikael Svenson
    May 21, 2014 at 13:23
  • 1
    You can do suffix wildcards only. Author:Mik* not Author:*ael.
    – Matthew McDermott
    May 21, 2014 at 16:49
  • 1
    True.. I meant at the same time :) It's wildcards at the beginning which are not supported.
    – Mikael Svenson
    May 21, 2014 at 20:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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