SQL2 Query for perticular DAM folder.

Avatar

Avatar

onkarh71407069

Avatar

onkarh71407069

onkarh71407069

08-02-2021

Hi,

PFA.

 

SELECT * FROM [dam:Asset] AS asset WHERE (asset.[jcr:content/metadata/cq:tags] IN ('post-sales')) AND ISDESCENDANTNODE(asset,'/content/dam/marketing-assist/digital-services')

 

This query is working properly.
It gives me nodes from "/content/dam/my-folder/digital-services" path as well as its subfolder nodes.

I want to limit it to a particular folder only; without subfolders.

 

Please suggest.

 

onkarh71407069_2-1612790010904.pngonkarh71407069_3-1612790065101.png

 

 

 

 

 

 

 

Assets SQL2

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Arun_Patidar

MVP

Total Posts

3.1K

Likes

1.2K

Correct Reply

883

Avatar

Arun_Patidar

MVP

Total Posts

3.1K

Likes

1.2K

Correct Reply

883
Arun_Patidar
MVP

08-02-2021

Hi,

Use below query

SELECT * FROM [dam:Asset] AS asset WHERE (asset.[jcr:content/metadata/cq:tags] IN ('post-sales')) AND ISCHILDNODE(asset,'/content/dam/marketing-assist/digital-services')

Answers (0)