topic Re: How to do a FTS-ALFRESCO date query with a custom datatime? in Alfresco Archive

How to do a FTS-ALFRESCO date query with a custom datatime?

spilby — Thu, 06 Oct 2016 12:32:11 GMT

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:<namespaces><namespace uri="mydocument.model" prefix="doc" /></namespaces><property name="doc:myDate" ed

Re: How to do a FTS-ALFRESCO date query with a custom datatime?

redraccoon — Thu, 06 Oct 2016 13:57:53 GMT

Maybe it's this

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.

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

Re: How to do a FTS-ALFRESCO date query with a custom datatime?

kaynezhang — Fri, 07 Oct 2016 05:19:43 GMT

Yes, you can set tokenised to both and rebuild the index.