SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I use below query for people search in sharepoint 2010 using jquery

 SELECT PREFERREDNAME,FirstName,LastName,JobTitle,Department,Email,WorkEmail,WorkPhone,Skills,PictureUrl,Path,Rank,MobilePhone FROM scope() where \"SCOPE\"='People' AND ((\"JobTitle\" LIKE '%" + lastName + "%') OR (\"Skills\" LIKE '%" + lastName + "%') OR (\"LastName\" LIKE '%" + lastName + "%') OR (\"FirstName\" LIKE '%" + lastName + "%') OR (\"Department\" LIKE '%" + lastName + "%') OR (\"Email\" LIKE '%" + lastName + "%')  OR (\"WorkEmail\" LIKE '%" + lastName + "%')  OR  (\"PreferredName\" LIKE '%" + lastName + "%'))

But when i add workphone in where condition like that

          (\"WorkPhone\" LIKE '%" + lastName + "%')

It stop return results and Display error No result Found. I also apply change according to following link.
Please Help me. Thanks in Advance.

share|improve this question
up vote 1 down vote accepted

I got My solution from following site

this Link follow us how we use custom property of user in search service.

But for default property U use in your searching U have to check following thing

go to Central Admin>Search Service>Metadata Properties> Find your properties Edit them and select option Allow this property to be used in scope and start full crawls .

Happy searching .....

share|improve this answer

Your Answer


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.