![]() |
|
|
|
|
Issue Type:
|
![Improvement]() Improvement
|
|
Affects Versions:
|
5.0 |
|
Assignee:
|
Unassigned |
|
Components:
|
core |
|
Created:
|
12/Jun/13 9:13 AM
|
|
Description:
|
To be able to do flat jcr queries it is necessary to adjust the 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.
|
|
Fix Versions:
|
5.0 |
|
Project:
|
Magnolia
|
|
Priority:
|
![Neutral]() Neutral
|
|
Reporter:
|
Philip Mundt
|
|
Security Level:
|
Public |
|
|
|
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]>
----------------------------------------------------------------
