This conversation has been locked due to inactivity. Please create a new post.
Introducing Adobe LLM Optimizer: Own your brand’s presence in AI-Powered search and discovery
SOLVED
SQL2 Query for perticular DAM folder.
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.
Topics
Topics help categorize Community content and increase your ability to discover relevant content.
1 Accepted Solution
Correct answer by
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')
Arun Patidar
Correct answer by
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')
Arun Patidar
Related Conversations
