1 Reply Latest reply on May 15, 2014 11:03 AM by Randall Hauch

    How to filter on a join where the referenced item is NOT present

    Jan van de klok Newbie

      Hello there,


        I'm trying to query my modeshape tree for elements that don't have a specific sub node (caseResult). This is the query I ended up with but it does give the correct results:


      Select * from [caci:case] as case

      left join [caci:caseResult] as caseResult on ischildnode(caseResult,case)


      caseResult.[jcr:created] IS NULL



      I need to get all case nodes that don't have a caseResult as subnode.

      How can I achieve this???


      Any help is appreciated




      Using modeshape 3.7.3