Details
-
Improvement
-
Resolution: Fixed
-
Neutral
-
1.0
-
None
-
None
-
-
Empty show more show less
-
RC 1
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.
Checklists
Attachments
Issue Links
- is depended upon by
-
MGNLSTK-1186 Fix/adapt component stkDownloadList
-
- Closed
-
- is superseded by
-
MGNLDAM-267 Prevent adjustments of JCR index for DAM mgnl:assets
-
- Closed
-