2 Replies Latest reply on May 15, 2014 12:32 PM by Randall Hauch

    query join problem

    Jan van de klok Newbie

      Hello there,  I've run into a serious problem (I think) , but maybe it's just my lack of experience with modeshape sql2 query language.

      We have the following situation:

                   we have a top level node "case" of type [caci:case] which has 2 subnodes, one called assignee of type [caci:aclUserIdentifier] and one called requestor of type  [caci:caseRequestor]. Both subnodes have a property called acl_identifier.  

      The assignee nodes have only 'user1..999' as acl_identifier property  values  and the  requestor nodes have only 'klant1..999' as acl_identifier property  values.

      When I run this query  :

      Select case.[jcr:path], assignee.acl_identifier  from [caci:case] as case

      inner join [caci:aclUserIdentifier]  as assignee on ischildnode(assignee ,case)



      (assignee.acl_identifier <> 'user1')

      I get this result:


      etc etc


      This is tottally incorrect!!!   Cas 10001 and 10002 do not have assignee's with acl_identifier properties with value's like 'klantxx' .


      Is it my query or what??

      Any help is greatly appreciated


      Jan van de Klok


      (our modeshape version is 3.7.3 running as a jboss EAP 6.1 module)  JDK version is 1.7_45)