Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@jackrabbit.apache.org
Received-SPF: pass (nike.apache.org: local policy)
Content-Type: text/plain; charset=iso-8859-1
Mime-Version: 1.0 (Apple Message framework v1077)
Subject: Re: Numeric/String comparisons in queries
From: =?iso-8859-1?Q?Fran=E7ois_Cassistat?= <f@maya-systems.com>
In-Reply-To: <1259687451504-932301.post@n4.nabble.com>
Date: Tue, 1 Dec 2009 13:21:41 -0500
Content-Transfer-Encoding: quoted-printable
Message-Id: <3915B025-A9F1-4DE9-B259-344548F81443@maya-systems.com>
References: <1259687451504-932301.post@n4.nabble.com>
To: users@jackrabbit.apache.org


Le 2009-12-01 =E0 12:10 PM, dave_gough a =E9crit :

>=20
> Hi,
>=20

Hi

> I have a a String property stored in the repository, but would like to =
query
> it using conditional logic as if it were a number
>=20
> I have tried to implement the Atom spec in JCR and allowed extensions =
to be
> added on an ad-hoc basis. In this case there are number of "meta" =
fields
> that extend the Atom model, but they are all saved as Strings in an =
attempt
> to keep it simple.
>=20
> However I now want to find all Entries that have a width property > =
10000,
> but the query below does an ASCII comparison, so 20 > 1000
>=20
> /jcr:root/element(*,atom:Entry)[./meta/width/@atom:value>'1000']=20
>=20
> I tried to spoof itby removing the single=3Dquotes around 1000 and =
this gave
> mixed results
>=20

It's normal since @atom:value property is from string type.

> /jcr:root/element(*,atom:Entry)[./meta/width/@atom:value>1000]=20
>=20
> Is there a function  such as "jcr:to_number()" or something similar =
that
> coerces the property to be a number? Or does anyone have any =
suggestions on
> how to do compare strings as numbers
>=20

There is a number function in standard XPath =
(http://www.w3.org/TR/xpath#function-number), you can try :
/jcr:root/element(*,atom:Entry)[number(./meta/width/@atom:value)>1000]=20=

But I'm not sure it is supported in JCR/JackRabbit.

> regards
>=20
> Dave Gough
>=20
> regards
> --=20
> View this message in context: =
http://n4.nabble.com/Numeric-String-comparisons-in-queries-tp932301p932301=
.html
> Sent from the Jackrabbit - Users mailing list archive at Nabble.com.


Frank