Thanks again Michael. The syntax was just made up pseudo code. I was in a
hurry to respond.
Anyway, this worked and here's a snippet of what it looks like:
sharedFilterQuery = '''WITHRECURSIVE
q AS
(
SELECT h.*
FROMSelection.FilterFolder h
join
Thanks MB, that helps me out. I hadn't considered the text portion of
the WHERE.
The thing is, I'm using WITH RECURSIVE, which gets me a Common Table
Expression (CTE) that represents a folder hierarchy. I want to then
query my entity, apply any filters and make sure my ID appears in the
CTE.