Thanks for the help - unfortunately I still have questions though: If
this is the case, shouldn't my first not work either? Or put
differently: What would the correct query be to get the all pages of
a certain template typ that have property x set to value y?
Regards,
Will
On 24.08.2007, at 12:00, Grégory Joseph wrote:
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
----------------------------------------------------------------
----------------------------------------------------------------
for list details see
http://documentation.magnolia.info/docs/en/editor/stayupdated.html
----------------------------------------------------------------
