topic Help for query in lucene. in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/help-for-query-in-lucene/m-p/201654#M154784 <HTML><HEAD></HEAD><BODY><SPAN>Hi guys, </SPAN><BR /><BR /><SPAN>I have some problem to do a query in lucene. My goal is to search for a specific custom-type which contains a date property, so the point is that I have to filter by this date. I see also some example but all of them are based on the </SPAN><PRE class="language-none line-numbers"><CODE> @cm\\:created <SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>My query is below and the point is the part of query in the first +() make no change at all.</SPAN><BR /><SPAN>At the end my problem is to filter by date, but the date is a property of a custom-type.</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />&lt;#if companyhome.childByNamePath["CompanyWorkSpace"]?exists&gt;<BR /><BR />&nbsp;&nbsp;&nbsp;&lt;#list companyhome.childrenByLuceneSearch["<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+(@\\{http\\://<A href="http://www.someco.com/model/content/1.0\\}mycustomtype.Start_Date:[2007-11-10" rel="nofollow noopener noreferrer">www.someco.com/model/content/1.0\\}mycustomtype.Start_Date:[2007-11-10</A> TO 2007-11-14])<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;+(TYPE:\"rsi:mycustomtype\")<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PATH:\"/app:company_home/cm:CompanyWorkSpace//*\"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"] as doc&gt;<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></CODE></PRE><BR /><SPAN>Thanks a lot guys,</SPAN><BR /><BR /><SPAN>Best Regards.</SPAN></BODY></HTML> Mon, 27 Apr 2009 08:48:18 GMT joksy 2009-04-27T08:48:18Z Help for query in lucene. https://connect.hyland.com/t5/alfresco-archive/help-for-query-in-lucene/m-p/201654#M154784 Hi guys, I have some problem to do a query in lucene. My goal is to search for a specific custom-type which contains a date property, so the point is that I have to filter by this date. I see also some example but all of them are based on the @cm\\:created ‍My query is below and the point is the pa Mon, 27 Apr 2009 08:48:18 GMT https://connect.hyland.com/t5/alfresco-archive/help-for-query-in-lucene/m-p/201654#M154784 joksy 2009-04-27T08:48:18Z Re: Help for query in lucene. https://connect.hyland.com/t5/alfresco-archive/help-for-query-in-lucene/m-p/201655#M154785 <HTML><HEAD></HEAD><BODY><SPAN>Have you tried in this way?</SPAN><BR /><PRE class="language-none line-numbers"><CODE><BR />+ ( @yourCustomPrefix\\:Start_Date:[2007-11-10T00:00:00 TO 2007-11-14T00:00:00] )<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><SPAN>I think you must add your custom prefix and you must define in Lucene all the timestamp (YYYY-MM-DDTHH:mm<img id="smileyfrustrated" class="emoticon emoticon-smileyfrustrated" src="https://connect.hyland.com/i/smilies/16x16_smiley-frustrated.png" alt="Smiley Frustrated" title="Smiley Frustrated" />S) to allow dates comparation.</SPAN><BR /><BR /><SPAN>Hope this helps.</SPAN></BODY></HTML> Tue, 05 May 2009 14:30:57 GMT https://connect.hyland.com/t5/alfresco-archive/help-for-query-in-lucene/m-p/201655#M154785 openpj 2009-05-05T14:30:57Z