AnsweredAssumed Answered

Alfresco 4 greater (>) and lesser (<) operator not working

Question asked by namoo on Nov 8, 2011

I&#39;m migrating Alfresco Community 3.4.d to Alfresco 4.0.b.
The following Web Script, which has greater operator with query, was working with Alfresco Community 3.4.d

var docquery = "SELECT * FROM cmis:document WHERE cmis:creationDate >= TIMESTAMP &#39;2011-11-04T16:09:58.438-07:00&#39;";
var def = {
   query: docquery,
   language: "cmis-alfresco"

var results = search.query(def);

But, when I tried with Alfresco Community 4.0.b. It&#39;s not working. So I tried RESTful service on Alfresco Community 4.0.b:*%20FROM%20cmis:document%20WHERE%20cmis:creationDate%20%3E=%20TIMESTAMP%202011-11-04T16:09:58.438-07:00

and it returns following response:

<?xml version="1.0" encoding="UTF-8"?>
<feed xmlns="" xmlns:app="" xmlns:cmisra="" xmlns:cmis="" xmlns:alf="" xmlns:opensearch="">
<generator version="4.0.0 (b 3835)">Alfresco (Community)</generator>
<link rel="service" href="'/>
<link rel="self" href="*%20FROM%20cmis:document%20WHERE%20cmis:creationDate%20%3e=%20TIMESTAMP%20%272011-11-04T16:09:58.438-07:00%27'/>
<title>Result set for SELECT * FROM cmis:document WHERE cmis:creationDate &gt;= TIMESTAMP &apos;2011-11-04T16:09:58.438-07:00&apos;</title>

However, when I used only &#39;=&#39; operator it returns matching cm:content.

Your help will be very appreciated.
Thank you!