Uploaded image for project: 'Magnolia DAM Module'
  1. Magnolia DAM Module
  2. MGNLDAM-273

Adapt JCR indexing for DAM mgnl:assets

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Fixed
    • Neutral
    • 1.0.1
    • 1.0
    • None
    • None
    • 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

        Acceptance criteria

        Attachments

          Issue Links

            Activity

              People

                Unassigned Unassigned
                pmundt Philip Mundt
                Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  Checklists

                    Task DoD