Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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

share|improve this question
    
In SharePoint you need to configure fields the crawler indexes. Is there similar setting in FAST? –  Jussi Palo Jan 25 '12 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 '12 at 7:40

2 Answers 2

up vote 1 down vote accepted

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

share|improve this answer
    
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 '12 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 '12 at 7:39

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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