We're seeing a very strange effect here on a query on the repository...
SELECT * FROM nt:base WHERE jcr:path like '/mtb/data/dealers/%' and mgnl:template = 'mtb_dealer_data_page'
correctly returns all content nodes under /mtb/data/dealers that are of the specified template.
SELECT * FROM nt:base WHERE jcr:path like '/mtb/data/dealers/%' and (state = 'BE' or state = 'VS')
correctly returns all contend nodes under /mtb/data/dealers with state == 'BE' or state = 'VS'. Thanks to the fact that all other content nodes there do not have a state attribute, they are not returned. But when I add the template restriction to this query...
SELECT * FROM nt:base WHERE jcr:path like '/mtb/data/dealers/%' and mgnl:template = 'mtb_dealer_data_page' and (state = 'BE' or state = 'VS')
I don't get any result at all! Does anyone have an explanation for this weird behavior?
Thanks for the help! Regards, Will ---------------------------------------------------------------- for list details see http://documentation.magnolia.info/docs/en/editor/stayupdated.html ----------------------------------------------------------------
