2

I am new in sharepoint 2010 and I want to make a FQL query For People search

One other thing in sharepoint search MSSQLFt works fine But in fast-search Some fields are not search.Like Department and WorkPhone

Here is my MSSQLFT query demo.

  <QueryPacket Revision='1000'><Query><SupportedFormats><Format>urn:Microsoft.Search.Response.Document:Document</Format></SupportedFormats><ResultProvider>SharepointSearch</ResultProvider><Context><QueryText type='MSSQLFT' language='en-us'>SELECT PREFERREDNAME,FirstName,AboutMe,LastName,JobTitle,Department,Email,WorkEmail,WorkPhone,Skills,PictureUrl,Path,Rank,MobilePhone,Title FROM scope() where \"SCOPE\"='"+scope+"' AND ((\"JobTitle\" = '" + lastName + "') OR (\"WorkPhone\" = '" + lastName + "') OR (\"Skills\" = '" + lastName + "') OR (\"LastName\" LIKE '%" + lastName + "%') OR (\"FirstName\" LIKE '%" + lastName + "%') OR (\"Department\" = '" + lastName + "') OR (\"WorkEmail\" LIKE '%" + lastName + "%')  OR  (\"PreferredName\" LIKE '%" + lastName + "%') OR (\"AboutMe\" = '" + lastName + "'))</QueryText></Context><Range><StartAt>1</StartAt><Count>10</Count></Range><EnableStemming>true</EnableStemming><TrimDuplicates>true</TrimDuplicates><IgnoreAllNoiseQuery>true</IgnoreAllNoiseQuery><ImplicitAndBehavior>true</ImplicitAndBehavior><IncludeRelevanceResults>true</IncludeRelevanceResults><IncludeSpecialTermResults>true</IncludeSpecialTermResults><IncludeHighConfidenceResults>true</IncludeHighConfidenceResults></Query></QueryPacket>

So please help me what is the difference between fast-search and sharepoint search. If possible give me some FQL query Example

Improve this question
2
  • In SharePoint you need to configure fields the crawler indexes. Is there similar setting in FAST?
    – Jussi Palo
    Jan 25, 2012 at 14:05
  • Jussi palo thanks for your reply I found My solution. I found my solution just go to central admin>Services>search service>menaged Property find your field Edit them and select option "Reduce storage requirements for text properties by using a hash for comparison"
    – Vishal_Sharepoint
    Jan 27, 2012 at 7:40

2 Answers 2

Reset to default
1

FAST is not used for People Search (it's queried through the normal SPS SSA), so you cannot use FQL in this case.

Improve this answer
2
  • hi Wictor-Now my query is works fine. My other problem is I am not able to query in where clause Like where (\"AboutMe\" = '%" + lastName + "%') but (\"AboutMe\" = '" + lastName + "') it works fine for me This problem i face in other fields Department,jobtitle,Skills
    – Vishal_Sharepoint
    Jan 26, 2012 at 9:11
  • I found my solution just go to central admin>Services>search service>menaged Property find your field Edit them and select option "Reduce storage requirements for text properties by using a hash for comparison"
    – Vishal_Sharepoint
    Jan 27, 2012 at 7:39
0

There is a tool for composing FQL queries: FAST search form SharePoint And there is the reference of FQL.

Improve this answer

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.