Can you use Query Builder to return related assets? | Community
Skip to main content
J
jwendling
Level 2
April 8, 2022
Solved

Can you use Query Builder to return related assets?

  • April 8, 2022
  • 1 reply
  • 1586 views

In AEM you are able to use the "relate" function e.g. source, derived and others to associate files in AEM Assets. My question is are you able to use the query builder to target and return a list of related assets?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Ravi_Pampana

Try below queries

 

1) path=/content/dam
    1_property=jcr:content/related/derived/sling:members/@sling:resources
    1_property.value=/content/dam%
    1_property.operation=like
     p.limit=-1


2) type=dam:Asset
    p.hits=selective
   1_property=jcr:content/related/derived/sling:members/@sling:resources
   1_property.value=/content/dam%
   1_property.operation=like
    p.limit=-1

 

 

In both the results I am getting the results. 

 

To return the json below is the link for above query

 

http://localhost:4502/bin/querybuilder.json?1_property=jcr%3acontent%2frelated%2fderived%2fsling%3amembers%2f%40sling%3aresources&1_property.operation=like&1_property.value=%2fcontent%2fdam%25&p.hits=selective&p.limit=-1&type=dam%3aAsset

 

In order to return results in desired format, you can write a servlet which will process the output of query builder and add the response to required format.

 

1 reply

Ravi_Pampana
Community Advisor
Ravi_PampanaCommunity Advisor
Community Advisor
April 8, 2022

Hi,

 

Yes, the related assets are added to related node under jcr:content

 

We can retrieve all the nodes related assets available under the path

 

{assets}/jcr:content/related/derived/sling:members

    J
    jwendlingAuthor
    Level 2
    April 11, 2022

    Am I able to use this as part of querying other properties?

    Here is an example:

    type=dam:Asset

    p.hits=selective

    p.limit=-1

    p.properties=jcr:content/metadata/dc:title jcr:content/metadata/dc:description jcr:content/related/derived/sling:members

     

    When I add your recommendation to my query it comes back in the JSON but is blank even when there are relationships made with the assets main folder path. What I was hoping is that it would return paths for related assets. The use case is I'm using the "Others" related option to associate Videos with their VTT files and would like to show that relationship in the JSON query with some other metadata I need to be shown. 

    },
    related: { }

    }

      Ravi_Pampana
      Community Advisor
      Ravi_PampanaCommunity AdvisorAccepted solution
      Community Advisor
      April 12, 2022

      Try below queries

       

      1) path=/content/dam
          1_property=jcr:content/related/derived/sling:members/@sling:resources
          1_property.value=/content/dam%
          1_property.operation=like
           p.limit=-1


      2) type=dam:Asset
          p.hits=selective
         1_property=jcr:content/related/derived/sling:members/@sling:resources
         1_property.value=/content/dam%
         1_property.operation=like
          p.limit=-1

       

       

      In both the results I am getting the results. 

       

      To return the json below is the link for above query

       

      http://localhost:4502/bin/querybuilder.json?1_property=jcr%3acontent%2frelated%2fderived%2fsling%3amembers%2f%40sling%3aresources&1_property.operation=like&1_property.value=%2fcontent%2fdam%25&p.hits=selective&p.limit=-1&type=dam%3aAsset

       

      In order to return results in desired format, you can write a servlet which will process the output of query builder and add the response to required format.

       

        Terms & ConditionsAccessibility statement

        Loading footer...