Using Query Builder to query content fragments by variation name?

Question

I'm aware of how to query content fragments based on their variation. I'm trying to figure out how to do this using Query Builder and there isn't much documentation. Only GraphQL documentation.

I've tried to log out the XPath/SQL2 equivalent of a GraphQL query to see how it's done under the hood when performing the GraphQL version of this query in AEM, but I'm finding it difficult to get that query log result.

Mahedi_Sabuj · Accepted Answer

I am not sure if it serves your purpose but you can try using p.hits = selective which will return variation properties. Change the p.properties value based on your needs.

path = /content/dam/aem-demo
type = dam:Asset
contentFragment
1_property = jcr:content/data/cq:model
1_property.value = /conf/..../cfm/models/article
2_property = jcr:content/data/web/jcr:primaryType
2_property.operation = exists
p.hits = selective
p.properties = jcr:path jcr:content/data/web/title jcr:content/data/web/description jcr:content/data/web/tags

{
  "success": true,
  "results": 1,
  "total": 1,
  "more": false,
  "offset": 0,
  "hits": [{
    "jcr:path": "/content/dam/aem-demo/..../aem-community",
    "jcr:content": {
      "data": {
        "web": {
          "description": "<p>Hello World!!<\/p>",
          "title":"AEM Community",
          "tags": [
            "aem-demo:activity/biking",
            "aem-demo:activity/running"
          ]
        }
      }
    }
  }]
}

Hello World!!<\/p>", "title":"AEM Community", "tags": [ "aem-demo:activity/biking", "aem-demo:activity/running" ] } } } }]}

Mahedi_Sabuj · Answer

You can use the following query to retrieve article content fragments based on the web variation.

path = /content/dam/aem-demo
type = dam:Asset
contentFragment
1_property = jcr:content/data/cq:model
1_property.value = /conf/aem-demo/settings/dam/cfm/models/article
2_property = jcr:content/data/web/jcr:primaryType
2_property.operation = exists

Make sure to replace the variation name "web" according to your specific requirements.

Sign up

Login with SSO

Login to the community

Login with SSO