topic Query Lucene: get the birthday in Alfresco Archive

Query Lucene: get the birthday

ventus85 — Mon, 26 Sep 2011 10:36:25 GMT

Hi all!If I write this query@myest\:birthday:"1998\-09\-24"The results are all those lines of people who were born on that day, but I want people born that month and that day (no year).@myest\:birthday:"*\-09\-24" and @myest\:birthday:"19*\-09\-24" not goodWhat is the right query?Thank you.

Re: Query Lucene: get the birthday

andy — Mon, 26 Sep 2011 19:31:02 GMT

Hi

There is no support to do this at the moment for datetime (and the wildcards you could use will lower case and miss)
It is a reasonable extension to have constraints on the upper and lower bits of datetime used. At the moment you can ignore everything below hour etc etc)

For date the index contains tokens of the form
yyyy-MM-dd

If you quote it - you will get stuff tokenised and the * will fail to parser to a date

So

@myest\:birthday:????\-09\-24

should give you a wildcard query that matches (and does not have to be valid date)

Andy

Re: Query Lucene: get the birthday

ventus85 — Tue, 27 Sep 2011 08:16:20 GMT

Thank you.
I solved by creating the node properties with day, month and year (individually).

My query is:

@myest\:month:"09" AND @myest\:day:"24"

Re: Query Lucene: get the birthday

andy — Tue, 27 Sep 2011 18:44:53 GMT

Hi

The date time analyser creates individual tokens for each field.
The problem is you can not query these direct.
At some point we will add some more date functions to expose this.

Andy