Need to include the Image URL/body of the page in return results by query builder report | Community
Skip to main content
D
dragon2A
Level 5
April 11, 2017
Solved

Need to include the Image URL/body of the page in return results by query builder report

  • April 11, 2017
  • 2 replies
  • 2245 views

Hi Team,

     I have a situation like need to pull a report which pages are having the DAM specific folder URLs.  I am able to pull that by using the query builder. By using the below query 

path=/content/*
fulltext=/content/dam/*
p.limit=-1 

But in results, I am getting only 

[

  •  
    {
    • path: "****",
    • excerpt: "",
    • name: "small",
    • title: "small",
    • lastModified: "2016-10-07 18:52:43"
    },

I wanted to add extra result field to this query. If yes how I can do it.  For example images in JCR:content stored like below. 

small: 

 

{

  • jcr:primaryType: "nt:unstructured",
  • fileReference: "/content/dam/eahelp/articles/sports/fifa-mobile-attack-mode.jpg",

 

I would like to get the fileRefernce property in that query .

Or

Is there anyway Can I get the report of DAM images which are used in the pages?

 

Thanks In Advance 

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 dragon2A

I am able to solve it by adding the hits and extra fields to the JSON results kind of like this 

fulltext=*&p.limit=-1&path=*&p.hits=selective&p.properties=sling:resourceType%20jcr:primaryType%20jcr:title%20jcr:path%20/fileReference/&property=jcr:title

 

This thread helped me to resolve the issue quickly 

http://help-forums.adobe.com/content/adobeforums/en/experience-manager-forum/adobe-experience-manager.topic.html/forum__czvb-i_am_using_querybui.html

Thanks  :)

2 replies

D
dragon2AAuthorAccepted solution
Level 5
April 11, 2017

I am able to solve it by adding the hits and extra fields to the JSON results kind of like this 

fulltext=*&p.limit=-1&path=*&p.hits=selective&p.properties=sling:resourceType%20jcr:primaryType%20jcr:title%20jcr:path%20/fileReference/&property=jcr:title

 

This thread helped me to resolve the issue quickly 

http://help-forums.adobe.com/content/adobeforums/en/experience-manager-forum/adobe-experience-manager.topic.html/forum__czvb-i_am_using_querybui.html

Thanks  :)

    Terms & ConditionsAccessibility statement

    Loading footer...