Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@jackrabbit.apache.org
Received-SPF: pass (athena.apache.org: local policy)
Message-ID: <48691EE9.3000808@anyware-tech.com>
Date: Mon, 30 Jun 2008 19:59:05 +0200
From: =?ISO-8859-1?Q?S=E9bastien_Launay?=
 <sebastien.launay@anyware-tech.com>
User-Agent: Thunderbird 2.0.0.14 (X11/20080505)
MIME-Version: 1.0
To: users@jackrabbit.apache.org
Subject: Re: Birthdate query
References: <4869059C.4080305@goojet.com>
In-Reply-To: <4869059C.4080305@goojet.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Hi JB,

None of the functions you describre are currently supported by Jackrabbit.
A date property is stored in the lucene index using ISO8601 format for
using < and > operator efficiency.

The most efficient way IMHO is to have another date property which will
contain the same the value but with a same fixed year.
The drawback is that you must maintain the integrity of the two fields at
each update.

But i think the duplicity is worth the effort hence it will consume more 
disk.

Note that you will need to use xs:datetime('XXXX-06-30T00:00:00.000+00:00')
with operator >= and <.

You can also use a string property with month and day concatenated ("06/30")
but the query will not be so fine grained (users born on the same hour :)).

Best regards,

S�bastien.

Jean-Baptiste Bellet a �crit :
> Hi,
>
> I'm using jackrabbit and I'm trying to execute a query in order to 
> retrieve 'users', registered in JCR, who have a birthdate 
> corresponding to the current date.
> For example if a user was born on june the 30th, 1992 I want to 
> compare the user's birthdate with june the 30th (and without the year 
> wich is not important in this case). I have tried a lot of queries, 
> but without success.
> Any idea on how to perform such a query?
> Thanks a lot,
> jb
>
> This one works:
>     //user[@birthDate = '1992-06-30T14:36:24.292+01:00']
> These do not work:
>     //user[substring(@birthDate, 1, 1) = '1']
>     //user[substring(fn:string(@birthDate), 1, 1) = '1']
>     //user[concat(substring(@birthDate, 6, 2), substring(@birthDate, 
> 9, 2)) = '0630']
>     //user[fn:month-from-dateTime(@birthDate) = 6]
>     //user[fn:month-from-dateTime(./@birthDate/value()) = 6]