Dear Magnolians
I have asked this already once a while back on this list, but only
got half an answer:
How would a JCR SQL query look that would allow me to filter on a
mgnl:content property and a property on the content nodes meta data
simultaneusly?
Meta data is stored in a subnode named "MetaData", and I can easily
get all MetaNodes that are of a certian template:
1)
select * from mgnl:content, mgnl:metaData where mgnl:template like
'my_template'
But this would return mgnl:metaData nodes, not mgln:content nodes. So
how about this:
2)
select * from mgnl:content where MetaData.mgnl:template like
'my_template'
-> Doen't return anything. Now let's search on a normal property of
the mgnl:content node:
3)
select * from mgnl:content where newsDate >= DATE '2008-01-17'
Works fine. But how do I combine this with 1) in order to get all
mgnl:content nodes of the type "my_template" with newsDate >=
2008-01-17?
Thanks for the help!
-Will
----------------------------------------------------------------
for list details see
http://documentation.magnolia.info/docs/en/editor/stayupdated.html
----------------------------------------------------------------
