jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jean-Baptiste Bellet <jbbel...@goojet.com>
Subject Birthdate query
Date Mon, 30 Jun 2008 16:11:08 GMT
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]

Mime
View raw message