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