Dear Magnolians I've got the following SQL query, which I am testing in the "JCR Queries" tool on the dms repository:
select * from mgnl:resource where jcr:path like '/path/to/some/folder/%' and ((width = '400' and height <= '300') or (width <= '400' and height = '300')) When I set the "Result Item Type" to "nt:base", the query returns the dms mgnl:contentnode which contains the mgnl:resource node that matches the required width and height. However, when I set the "Result Item Type" to mgnl:resource, I don't get anything! The same thing happens when I use the path as the sole criteria. Therefore I must assume that the Magnolia query mechanism does not really work for mgnl:resource nodes, correct? Is this intentionally? What's the reason for this and is there a workaround? Thanks! -Will P.S.: This is on Magnolia 4.1.1 ---------------------------------------------------------------- For list details see http://www.magnolia-cms.com/home/community/mailing-lists.html To unsubscribe, E-mail to: <[email protected]> ----------------------------------------------------------------
