Skip to content

Instantly share code, notes, and snippets.

@kuckmc01

kuckmc01/gist:c4049d18d7e6669ce9ec16c28c2e3445

Created May 24, 2019 17:37
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kuckmc01/c4049d18d7e6669ce9ec16c28c2e3445 to your computer and use it in GitHub Desktop.
Save kuckmc01/c4049d18d7e6669ce9ec16c28c2e3445 to your computer and use it in GitHub Desktop.
Download ZIP
SQL2 dam:Asset query specific sub metadata node has property
Raw
gistfile1.txt
SELECT * FROM [dam:Asset] AS s WHERE ISDESCENDANTNODE([/content/dam/abc]) and s.[jcr:content/metadata/thing/textfield1] is not null
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment