How to find particular image log exists on what pages using SQL2 query? | Community
Skip to main content
touseefk2181136
touseefk2181136
Level 3
August 18, 2020

How to find particular image log exists on what pages using SQL2 query?

  • August 18, 2020
  • 2 replies
  • 1213 views

I have a requirement where I need a list of pages, just to know that a particular image logo exists on what pages. 

As highlighted in the following image, I need all the pages with property imageReference set as "company-horiz-blk.png"

 

 

 

 

So I need to write a SQL2 query regarding this.

Any help would be appreciated.

 

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

    2 replies

    Nikhil-Kumar
    Community Advisor
    Nikhil-KumarCommunity Advisor
    Community Advisor
    August 18, 2020

    @touseefk2181136  
    Try giving the path of the content structure in the Path and the string or the reference you want to search in the Text below and Generate and Execute the query. It should display the results.



    Let me know if this doesn't works!!

      Nupur_Jain
      Adobe Employee
      Nupur_JainAdobe Employee
      Adobe Employee
      August 19, 2020

      Hi @touseefk2181136 

       

      SQ2 to search for image References with particular image can be searched with 


      SELECT * FROM [nt:unstructured] AS node WHERE ISDESCENDANTNODE (node, '/content/we-retail') AND node.[imageReference] = '/content/dam/we-retail/en/activities/climbing/indoor-practicing.jpg'

       

      The above query will search for all the paths where imageReference is present.

      I would say if you want to search for logo imageReference specifically, you can also add sling:resourceType of the logo as well in the search like

       

      SELECT * FROM [nt:unstructured] AS node WHERE ISDESCENDANTNODE (node, '/content/we-retail') AND node.[imageReference] = '/content/dam/we-retail/en/activities/climbing/indoor-practicing.jpg' AND node.[sling:resourceType] = 'foundation/components/image'

       

      Hope it helps!

      Thanks!

      Nupur

        Terms & ConditionsAccessibility statement

        Loading footer...