Expand my Community achievements bar.

Radically easy to access on brand approved content for distribution and omnichannel performant delivery. AEM Assets Content Hub and Dynamic Media with OpenAPI capabilities is now GA.
SOLVED

AEM Query for retrieving tags value

Avatar

Level 3

Hi Team,

I have a requirement to fetch the value of tags, which is under the metadata of content fragment through json url . So can anyone please provide the query for it.

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

@skumari ,

I think you need to write a servlet to run a xpath query to fetch the results. Assuming you need a servlet, this sample code should help you to return result in JSON format

Session session = resourceResolver.adaptTo(Session.class);
Map<String, String> predicateMap = new HashMap<>();

predicateMap.put("1_path", /content/dam/content-fragments/bookpedia);
predicateMap.put("2_type", "dam:Asset");
predicateMap.put("3_property", "jcr:content/contentFragment");
predicateMap.put("3_property.value", "true");
predicateMap.put("4_orderby", "@jcr:content/jcr:lastModified");
predicateMap.put("4_orderby.sort", "desc");

Query query = queryBuilder.createQuery(PredicateGroup.create(predicateMap),session);
SearchResult result = query.getResult();
Iterator<Resource> resultIterator = result.getResources();
Resource resource = null;
ValueMap valueMap = null;
com.google.gson.JsonObject jsonObject = new JsonObject();
while (resultIterator.hasNext()){
    resource = resultIterator.next();
    valueMap = resource.getValueMap();
    //TO DO 
    //Fetch your properties from the valueMap and add them to the JsonObject as per your needs
    //jsonObject.addProperty("key", valueFromValueMap);
    //jsonObject.add("key", anotherJSONObject);
}
response.setContentType("application/json");
response.setCharacterEncoding("UTF-8");
response.getWriter().print(jsonObject.toString());

Hope this helps!

View solution in original post

5 Replies

Avatar

Community Advisor

Please check the below sample query:

query {
  articleList {
    items {
      _tags
      _metadata {
        stringArrayMetadata {
          name
          value
        }
      }
    }
  }
}

Response:

Screenshot 2023-08-07 at 7.38.55 PM.png

Reference: https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/aem-6-5-graphql-query-to-f... 

 

 

Avatar

Level 3

Hi @Mahedi_Sabuj 

Thanks for the above information. But we need to add it in code like below. We basically want the response through json.

predicateMap.put("1_path", /content/dam/content-fragments/bookpedia);
predicateMap.put("2_type", "dam:Asset");
predicateMap.put("3_property", "jcr:content/contentFragment");
predicateMap.put("3_property.value", "true");
predicateMap.put("4_orderby", "@jcr:content/jcr:lastModified");
predicateMap.put("4_orderby.sort", "desc");

Avatar

Correct answer by
Community Advisor

@skumari ,

I think you need to write a servlet to run a xpath query to fetch the results. Assuming you need a servlet, this sample code should help you to return result in JSON format

Session session = resourceResolver.adaptTo(Session.class);
Map<String, String> predicateMap = new HashMap<>();

predicateMap.put("1_path", /content/dam/content-fragments/bookpedia);
predicateMap.put("2_type", "dam:Asset");
predicateMap.put("3_property", "jcr:content/contentFragment");
predicateMap.put("3_property.value", "true");
predicateMap.put("4_orderby", "@jcr:content/jcr:lastModified");
predicateMap.put("4_orderby.sort", "desc");

Query query = queryBuilder.createQuery(PredicateGroup.create(predicateMap),session);
SearchResult result = query.getResult();
Iterator<Resource> resultIterator = result.getResources();
Resource resource = null;
ValueMap valueMap = null;
com.google.gson.JsonObject jsonObject = new JsonObject();
while (resultIterator.hasNext()){
    resource = resultIterator.next();
    valueMap = resource.getValueMap();
    //TO DO 
    //Fetch your properties from the valueMap and add them to the JsonObject as per your needs
    //jsonObject.addProperty("key", valueFromValueMap);
    //jsonObject.add("key", anotherJSONObject);
}
response.setContentType("application/json");
response.setCharacterEncoding("UTF-8");
response.getWriter().print(jsonObject.toString());

Hope this helps!

Avatar

Community Advisor

Hi @skumari, I added the Query Builder implementation for Metadata/Tags in the GitHub Repository. Please check here: https://github.com/MahediSabuj/aem-react-spa/blob/3488028db20beff9cff391e0673aafca77eec731/core/src/... 

String assetPath = request.getParameter("assetPath");

Map<String, String> predicateMap = new HashMap<>();
predicateMap.put("1_path", assetPath);
predicateMap.put("2_type", "dam:Asset");
predicateMap.put("3_property", "jcr:content/contentFragment");
predicateMap.put("3_property.value", "true");
predicateMap.put("4_orderby", "@jcr:content/jcr:lastModified");
predicateMap.put("4_orderby.sort", "desc");

// In case you want to search by metadata/cq:tags property
// predicateMap.put("5_property", "jcr:content/metadata/cq:tags");
// predicateMap.put("5_property.value", "aem-react-spa:us/articles/aem-cloud");

Session session = request.getResourceResolver().adaptTo(Session.class);
QueryBuilder queryBuilder = request.getResourceResolver().adaptTo(QueryBuilder.class);
Query query = queryBuilder.createQuery(PredicateGroup.create(predicateMap), session);

SearchResult result = query.getResult();

JsonObject jsonObject = new JsonObject();
if (result != null && result.getResources() != null) {
    Iterator<Resource> resultIterator = result.getResources();

    while (resultIterator.hasNext()){
        Resource resource = resultIterator.next();
        ValueMap valueMap = resource.getValueMap();

        String resourcePath = resource.getPath();
        String[] tags = valueMap.get("jcr:content/metadata/cq:tags", new String[0]);

        JsonArray jsonArray = new JsonArray();
        Arrays.stream(tags).forEach(jsonArray::add);
        jsonObject.add(resourcePath, jsonArray);
    }
}

response.setContentType("application/json");
response.setCharacterEncoding("UTF-8");
response.getWriter().print(jsonObject);

Reference: https://github.com/adobe/aem-core-wcm-components/blob/main/bundles/core/src/main/java/com/adobe/cq/w... 

 

 

Avatar

Community Advisor

Hi @skumari 

Using query we can get all tags and then filter out the tags which are assigned to the content fragment programmatically we can get the tags that are assigned to the content fragment by resolving the content fragment path using a resource resolver but we can't get the tags that are assigned to the content fragment directly using a query. For that, we have to resolve the content fragment and then we can get the tags that are assigned to the content fragment from its resource.getValueMap().get("jcr:content/metadata/cq:tags")