![]() |
|
|
|
|
Change By:
|
Philip Mundt
(12/Jun/13 9:15 AM)
|
|
Description:
|
To be able to do flat jcr queries it is necessary to adjust the
jcr search
index of DAM and mgnl:assets. Most file information are store in the jcr:content subnode of an asset and thus, are not easily queried.
A SQL2 workaround form Greg is
SELECT *
FROM [nt:base]
WHERE extension='jpg'
AND ISDESCENDANTNODE([/demo-project/])
But one has to set the result NodeType to mgnl:asset to only get the assets from the query.
Deprecated XPath query would be
/jcr:root/demo-project[1]//element(*,nt:base)[jcr:content/@extension='jpg']
SQL2 join queries are not supported atm.
|
|
|
|
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
----------------------------------------------------------------
For list details, see: http://www.magnolia-cms.com/community/mailing-lists.html
Alternatively, use our forums: http://forum.magnolia-cms.com/
To unsubscribe, E-mail to: <
[email protected]>
----------------------------------------------------------------
