I'm trying to query SharePoint using jQuery and SPServices. When I run the code below, I get the error Your query is malformed. Please rephrase your query.
var searchq = "Write=02/27/2014..05/27/2014";
var q = "SELECT Size, Rank,Path,Title,Write FROM scope() WHERE " + searchq + " AND ( (\"SCOPE\" = 'Contracts') ) ORDER BY Rank DESC";
var queryText = "<QueryPacket xmlns='urn:Microsoft.Search.Query' Revision='1000'>"
queryText += "<Query>"
queryText += "<Context>"
queryText += "<QueryText language='en-US' type='MSSQLFT'>"
queryText += q;
queryText += "</QueryText>"
queryText += "</Context>"
queryText += "<IncludeSpecialTermResults>true</IncludeSpecialTermResults>"
queryText += "</Query>"
queryText += "</QueryPacket>";
$().SPServices({
operation: "Query",
queryXml: queryText,
completefunc: function(xData, Status) {
$(xData.responseXML).find("QueryResult").each(function() {
//let's see what the response looks like
$("#hcg_expiring_contracts").html("<p>" + $(this).text().replace(/</g,"<") + "</p>");
});
}
});
When I remove searchq
from the query, the query succeeds. I've also tried writing searchq
as
var searchq = "(Write>=" + strBeginDate + " AND Write<=" + strEndDate + ")";
But still get the same error. I've tried several different date fields, but they all return the same error. How do I limit my query using these dates?