Skip to content

Instantly share code, notes, and snippets.

@ahmed-musallam

ahmed-musallam/SQL2-Query-Samples.md

Last active October 23, 2017 15:40
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 ahmed-musallam/20a1c3601532f87cdb17e8e4de33c127 to your computer and use it in GitHub Desktop.
Save ahmed-musallam/20a1c3601532f87cdb17e8e4de33c127 to your computer and use it in GitHub Desktop.
Download ZIP
JCR SQL2 Query Samples
Raw
SQL2-Query-Samples.md

JCR SQL2 Query Samples

A collection of JCR SQL2 query examples

Nodes that have a non-empty property with name 'propName'

SELECT 
   p.* FROM [nt:unstructured] AS p 
WHERE 
   ISDESCENDANTNODE('/') 
   AND p.[propName] <> ''
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment