The "state" property is (I assume) a property of the nodes you're
looking for, while "mgnl:template" is a property of the MetaData
nodes, which are child nodes of the nodes you're looking for.
On Aug 24, 2007, at 11:39 , Will Scheidegger wrote:
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
----------------------------------------------------------------
----------------------------------------------------------------
for list details see
http://documentation.magnolia.info/docs/en/editor/stayupdated.html
----------------------------------------------------------------
