@touseefk2181136 You can find the query builder equivalent of this SQL2 query and that should do the trick :
SELECT * FROM [nt:unstructured] AS s WHERE ISDESCENDANTNODE([/content/data]) AND NOT ISCHILDNODE([/content/data])
path.flat property might come in handy in that.
Otherwise, if you are o...