Hi All ,
I am new to AEM and jcr queries. I have a requirement where I need to query the data using jcr sql.
I have a field call price whose type is String and I want to find out if that price falls between a certain range . I want to write a query which will fetch this node.
below is the query that I am trying,
SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE([/content/items]) and price >CAST ('1' AS DECIMAL) and price <CAST ('8' AS DECIMAL).
Can any one suggest me what am I doing wrong.
Thanks in Advance
Retrieving data ...