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)

      where

      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

       

      Jan

       

      Using modeshape 3.7.3