topic can't make lucene query work in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/can-t-make-lucene-query-work/m-p/276900#M230030 <HTML><HEAD></HEAD><BODY><SPAN>Hello folks,</SPAN><BR /><BR /><BR /><SPAN>I am facing some problems with querying lucene.</SPAN><BR /><BR /><SPAN>Following my construct:</SPAN><BR /><PRE class="language-none line-numbers"><CODE>// search construct<BR />var sort1 = {<BR />column: "@{<A href="http://www.alfresco.org/model/content/1.0}created" rel="nofollow noopener noreferrer">http://www.alfresco.org/model/content/1.0}created</A>",<BR />ascending: true<BR />};<BR />var paging = {<BR />maxItems: 100,<BR />skipCount: 0<BR />};<BR />var def = {<BR />query: "@cm\\:created:[\"" + splitd1 + "*\" TO \"" + splitd2 +"*\"]",<BR />store: "workspace://SpacesStore/"+item,<BR />language: "fts-alfresco",<BR />sort: [sort1],<BR />page: paging<BR />};<BR /><BR />var candidates = search.query(def);<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN>splitd1 and splitd2 are two date-strings that i have manipulated. One represents the actual time and the other represents a date one week before the actual time. </SPAN><BR /><BR /><SPAN>I want to find all files that have been created in the last week (from now on). </SPAN><BR /><BR /><SPAN>According to the alfresco reository javascript debugger the query looks like this:</SPAN><BR /><PRE class="language-none line-numbers"><CODE>@cm\:created:["2011\-09\-29*" TO "2011\-09\-22*"]<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>But the method is not returning any result!</SPAN><BR /><BR /><SPAN>However, if i enter the string above in the lucene search field in the node browser of my alfresco installation it works perfectly fine.</SPAN><BR /><BR /><SPAN>What am I missing? Do i have to escape some more characters because of lucenes syntax? </SPAN><BR /><SPAN>help needed. thanks in advance!</SPAN><BR /><BR /><BR /><SPAN>// alfresco 3.2 community</SPAN></BODY></HTML> Thu, 29 Sep 2011 13:20:00 GMT mrks_js 2011-09-29T13:20:00Z can't make lucene query work https://connect.hyland.com/t5/alfresco-archive/can-t-make-lucene-query-work/m-p/276900#M230030 Hello folks,I am facing some problems with querying lucene.Following my construct:// search constructvar sort1 = {column: "@{http://www.alfresco.org/model/content/1.0}created",ascending: true};var paging = {maxItems: 100,skipCount: 0};var def = {query: "@cm\\:created:[\"" + splitd1 + "*\" TO \"" + s Thu, 29 Sep 2011 13:20:00 GMT https://connect.hyland.com/t5/alfresco-archive/can-t-make-lucene-query-work/m-p/276900#M230030 mrks_js 2011-09-29T13:20:00Z Re: can't make lucene query work https://connect.hyland.com/t5/alfresco-archive/can-t-make-lucene-query-work/m-p/276901#M230031 <HTML><HEAD></HEAD><BODY><SPAN>Hi</SPAN><BR /><BR /><SPAN>Build this - no escaping is required inside quotes - I am not sure if the * breaks the date parse.</SPAN><BR /><SPAN>Having the range reversed should be OK. </SPAN><BR /><BR /><SPAN>@cm\:created:["2011-09-29" TO "2011-09-22"]</SPAN><BR /><BR /><SPAN>Andy</SPAN></BODY></HTML> Fri, 30 Sep 2011 19:29:32 GMT https://connect.hyland.com/t5/alfresco-archive/can-t-make-lucene-query-work/m-p/276901#M230031 andy 2011-09-30T19:29:32Z