{"id":767,"date":"2010-09-24T21:42:07","date_gmt":"2010-09-24T19:42:07","guid":{"rendered":"http:\/\/www.itidea.nl\/?p=767"},"modified":"2015-09-08T20:35:25","modified_gmt":"2015-09-08T18:35:25","slug":"example-of-using-the-spservices-search-web-service","status":"publish","type":"post","link":"https:\/\/www.itidea.nl\/index.php\/example-of-using-the-spservices-search-web-service\/","title":{"rendered":"Example of using the SPServices Search web service"},"content":{"rendered":"

Instead of CAML you can also use a search query by using SQL or keyword syntax to search the SharePoint environment client-side by using the Search web service. The SPServices library supports the Query operation to do this.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n

Hereby I show you a few examples of how to use it.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n

First let\u2019s start building the query. The query is based on the Microsoft.Search.Query schema, which can be found here: http:\/\/msdn.microsoft.com\/en-us\/library\/ms563775.aspx<\/a>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n

A query using keyword syntax:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n

\r\nvar queryText = "<QueryPacket xmlns='urn:Microsoft.Search.Query' Revision='1000'>"\r\nqueryText += "<Query>"\r\nqueryText += "<Context>"\r\nqueryText += "<QueryText language='en-US' type='STRING'>"\r\nqueryText += "Estonia";\r\nqueryText += "<\/QueryText>"\r\nqueryText += "<\/Context>"\r\nqueryText += "<\/Query>"\r\nqueryText += "<\/QueryPacket>";\r\n<\/pre>\n
To fire this query by the Query operation of the Search web service via SPServices the following code can be used:<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 var title, url = "";\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $().SPServices({\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 operation: "Query",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 queryXml: queryText,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 completefunc: function(xData, Status) {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$(xData.responseXML).find("QueryResult").each(function() {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/let's see what the response looks like\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $("#result").text($(this).text());\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 });\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 });\r\n<\/pre>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n
#results<\/em> is a div element with the id results<\/em> to show the response of the query web service. The response format returned by the query web service for the Query operation is described by the Microsoft.Search.Response schema (http:\/\/msdn.microsoft.com\/en-us\/library\/ms578335.aspx<\/a>)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n
The result of running the above example:<\/p>\n
<ResponsePacket xmlns="urn:Microsoft.Search.Response">\r\n\u00a0 <Response>\r\n\u00a0\u00a0\u00a0 <Range>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 <StartAt>1<\/StartAt>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 <Count>1<\/Count>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 <TotalAvailable>1<\/TotalAvailable>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 <Results>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <Document relevance="428" xmlns="urn:Microsoft.Search.Response.Document">\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <Title>Estonia<\/Title>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <Action>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <LinkUrl size="0" fileExt="aspx">http:\/\/your_url\/Lists\/Country\/DispForm.aspx?ID=24<\/LinkUrl>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/Action>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <Description \/>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <Date>2010-04-08T13:45:47+02:00<\/Date>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/Document>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 <\/Results>\r\n\u00a0\u00a0\u00a0 <\/Range>\r\n\u00a0\u00a0\u00a0 <Status>SUCCESS<\/Status>\r\n\u00a0 <\/Response>\r\n<\/ResponsePacket>\r\n<\/pre>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n
One result is returned here to show a simple and small piece of xml. The results element contains the actual result of the query, the document element contains a single content item in the search results.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n
A query using SQL syntax:<\/p>\n
\r\nvar queryText = "<QueryPacket xmlns='urn:Microsoft.Search.Query' Revision='1000'>"\r\nqueryText += "<Query>"\r\nqueryText += "<Context>"\r\nqueryText += "<QueryText language='en-US' type='MSSQLFT'>"\r\nqueryText += "SELECT Title, Rank, Size, Description, Write, Path FROM portal..scope() WHERE CONTAINS ('Estonia') ORDER BY \\"Rank\\" DESC"\r\nqueryText += "<\/QueryText>"\r\nqueryText += "<\/Context>"\r\nqueryText += "<\/Query>"\r\nqueryText += "<\/QueryPacket>";\r\n<\/pre>\n
And the result:<\/p>\n
\r\n<ResponsePacket xmlns="urn:Microsoft.Search.Response">\r\n\u00a0 <Response>\r\n\u00a0\u00a0\u00a0 <Range>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 <StartAt>1<\/StartAt>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 <Count>1<\/Count>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 <TotalAvailable>1<\/TotalAvailable>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 <Results>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <Document xmlns="urn:Microsoft.Search.Response.Document">\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <Action>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <LinkUrl fileExt="aspx">http:\/\/your_url\/Lists\/Country\/DispForm.aspx?ID=24<\/LinkUrl>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/Action>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <Properties mlns="urn:Microsoft.Search.Response.Document.Document">\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <Property>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <Name>TITLE<\/Name>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <Type>String<\/Type>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <Value>Estonia<\/Value>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/Property>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <Property>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <Name>RANK<\/Name>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <Type>Int64<\/Type>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <Value>1000<\/Value>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/Property>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <Property>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <Name>SIZE<\/Name>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <Type>Int64<\/Type>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0<Value>0<\/Value>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/Property>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <Property>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <Name>WRITE<\/Name>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <Type>DateTime<\/Type>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <Value>2010-04-08T13:45:47+02:00<\/Value>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/Property>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <Property>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <Name>PATH<\/Name>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <Type>String<\/Type>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Value>http:\/\/your_url\/Lists\/Country\/DispForm.aspx?ID=24<\/Value>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/Property>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/Properties>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/Document>\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 <\/Results>\r\n\u00a0\u00a0\u00a0 <\/Range>\r\n\u00a0\u00a0\u00a0 <Status>SUCCESS<\/Status>\r\n\u00a0 <\/Response>\r\n<\/ResponsePacket>\r\n<\/pre>\n
The results of the keyword and SQL syntax are slightly different. Keep this in mind while traversing the xml and getting the title for instance.
\nBy using the SQL syntax and getting the title in the resulting xml, the Property element is involved:<\/p>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $().SPServices({\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 operation: "Query",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 queryXml: queryText,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 completefunc: function(xData, Status) {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $(xData.responseXML).find("QueryResult").each(function() {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 var x = $("<xml>" + $(this).text() + "<\/xml>");\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/let's see what the response looks like\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/$("#result").text($(this).text());\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/traverse the xml to get the items\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 x.find("Document").each(function() {\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/when using SQL syntax\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 url = $("Action>LinkUrl", $(this)).text();\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $(this).find("Property").each(function() {\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0if ($("Name", $(this)).text() == "TITLE") {\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 title = $("Value", $(this)).text();\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 });\r\n                        \/\/end SQL syntax\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $("#result").text("title: " + title + " - LinkUrl: " + url);\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 });\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 });\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 });\r\n<\/pre>\n
By using the keyword syntax and getting the title, it\u2019s just a direct child element of the Document element and this code can be used:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n
\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $().SPServices({\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 operation: "Query",\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 queryXml: queryText,\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 completefunc: function(xData, Status) {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0$(xData.responseXML).find("QueryResult").each(function() {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 var x = $("<xml>" + $(this).text() + "<\/xml>");\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/let's see what the response looks like\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/$("#result").text($(this).text());\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/traverse the xml to get the items\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 x.find("Document").each(function() {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 url = $("Action>LinkUrl", $(this)).text();\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/when using keyword syntax\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 title = $("Title", $(this)).text();\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/end keyword syntax\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $("#result").text("title: " + title + " - LinkUrl: " + url);\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 });\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 });\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 });\r\n\r\n<\/pre>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n
The examples described here give just one result for demonstration purposes. This can be seen at the elements count<\/em> and totalavailable<\/em> in the result xml. Count<\/em> is the actual number of items returned, while totalavailable<\/em> is the total number of results returned by the query web service. When getting real life results please mind the number of items returned by default is 10. Of course the query can be adjusted with a custom count:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n
\r\nvar queryText = "<QueryPacket xmlns='urn:Microsoft.Search.Query' Revision='1000'>"\r\nqueryText += "<Query>"\r\nqueryText += "<Range><Count>50<\/Count><\/Range>";\r\nqueryText += "<Context>"\r\nqueryText += "<QueryText language='en-US' type='STRING'>"\r\nqueryText += "Estonia";\r\nqueryText += "<\/QueryText>"\r\nqueryText += "<\/Context>"\r\nqueryText += "<\/Query>"\r\nqueryText += "<\/QueryPacket>";\r\n<\/pre>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n
To fully optimize the query to your needs please check out the Microsoft.Search.Query schema for a lot of useful options.<\/p>\n","protected":false},"excerpt":{"rendered":"
Instead of CAML you can also use a search query by using SQL or keyword syntax to search the SharePoint environment client-side by using the Search web service. The SPServices library supports the Query operation to do this.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Hereby I … Read More »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12,8],"tags":[11,33],"class_list":["post-767","post","type-post","status-publish","format-standard","hentry","category-sharepoint-2007","category-sharepoint-2010","tag-jquery","tag-spservices"],"_links":{"self":[{"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/posts\/767","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/comments?post=767"}],"version-history":[{"count":8,"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/posts\/767\/revisions"}],"predecessor-version":[{"id":775,"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/posts\/767\/revisions\/775"}],"wp:attachment":[{"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/media?parent=767"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/categories?post=767"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itidea.nl\/index.php\/wp-json\/wp\/v2\/tags?post=767"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}