topic How to do a FTS-ALFRESCO date query with a custom datatime? in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/how-to-do-a-fts-alfresco-date-query-with-a-custom-datatime/m-p/311147#M264277 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm using Alfresco 4.2.6 with SOLR.</P><P></P><P>I need to seach a custom property with a FTS-ALFRESCO query. This custom property is a datetime. This is how I define it on my xml model:</P><P></P><P>&lt;namespaces&gt;</P><P>&lt;namespace uri="mydocument.model" prefix="doc" /&gt;</P><P>&lt;/namespaces&gt;</P><P></P><P>&lt;property name="doc:myDate" editVisible="true" createVisible="true" editable="true" inheritable="false" calculable="true"&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;title&gt;Data&lt;/title&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;type&gt;d:datetime&lt;/type&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;mandatory&gt;true&lt;/mandatory&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;index enabled="true"&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;atomic&gt;false&lt;/atomic&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;stored&gt;false&lt;/stored&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tokenised&gt;false&lt;/tokenised&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/index&gt;</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/property&gt;</P><P></P><P>If I go to the node navigator of my share and search something like this:</P><P></P><P>(@cm\:created:["2016-01-07T00:00:00.000" TO "2016-10-05T23:59:59.000"])</P><P></P><P>the seach works and return me results. But if I try to use my custom property:</P><P></P><P>@doc\:myDate:["2016-01-07T00:00:00.000" TO "2016-10-05T23:59:59.000"]</P><P></P><P>returns me 0 results. I can see documents with my property correctly fulled:</P><P></P><P>doc:myDate</P><P>d:datetime</P><P>12 ene 2016 00:00:00 GMT+0100 (CET)</P><P></P><P>Exactly as the cm create date:</P><P></P><P>cm:created</P><P>d:datetime</P><P>12 ene 2016 15:57:17 GMT+0100 (CET)</P><P></P><P>And all my properties are indexed on SOLR, because I can find it with another query.</P><P></P><P>Where is the problem? Why that query don't return me results?</P><P></P><P>NOTE: I don't need to search with hours and minutes. Only with dates, if there are a response more simple.</P><P></P><P>Thanks! And best regards.</P></BODY></HTML> Thu, 06 Oct 2016 12:32:11 GMT spilby 2016-10-06T12:32:11Z How to do a FTS-ALFRESCO date query with a custom datatime? https://connect.hyland.com/t5/alfresco-archive/how-to-do-a-fts-alfresco-date-query-with-a-custom-datatime/m-p/311147#M264277 Hi,I'm using Alfresco 4.2.6 with SOLR.I need to seach a custom property with a FTS-ALFRESCO query. This custom property is a datetime. This is how I define it on my xml model:&lt;namespaces&gt;&lt;namespace uri="mydocument.model" prefix="doc" /&gt;&lt;/namespaces&gt;&lt;property name="doc:myDate" ed Thu, 06 Oct 2016 12:32:11 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-do-a-fts-alfresco-date-query-with-a-custom-datatime/m-p/311147#M264277 spilby 2016-10-06T12:32:11Z Re: How to do a FTS-ALFRESCO date query with a custom datatime? https://connect.hyland.com/t5/alfresco-archive/how-to-do-a-fts-alfresco-date-query-with-a-custom-datatime/m-p/311148#M264278 <HTML><HEAD></HEAD><BODY><P>Maybe it's <A href="http://docs.alfresco.com/4.2/concepts/search-fts-config.html" rel="nofollow noopener noreferrer">this</A></P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD><P>Tokenised="true"If "true", the string value of the property is tokenized before indexing.if "false", it is indexed "as is" as a single string.if "both" then both forms above are in the index.</P></TD></TR></TBODY></TABLE></BLOCKQUOTE><P></P><P>What I understood is that your Tokenised="false" stored your custom date as a String in your Alfresco, wich would explain why it wouldn't be able to compare your dates format</P></BODY></HTML> Thu, 06 Oct 2016 13:57:53 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-do-a-fts-alfresco-date-query-with-a-custom-datatime/m-p/311148#M264278 redraccoon 2016-10-06T13:57:53Z Re: How to do a FTS-ALFRESCO date query with a custom datatime? https://connect.hyland.com/t5/alfresco-archive/how-to-do-a-fts-alfresco-date-query-with-a-custom-datatime/m-p/311149#M264279 <HTML><HEAD></HEAD><BODY><P>Yes, you can&nbsp; set&nbsp; tokenised to both and rebuild the index. </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;tokenised&gt;both&lt;/tokenised&gt;</P></BODY></HTML> Fri, 07 Oct 2016 05:19:43 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-do-a-fts-alfresco-date-query-with-a-custom-datatime/m-p/311149#M264279 kaynezhang 2016-10-07T05:19:43Z