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)
where
(assignee.acl_identifier <> 'user1')
I get this result:
| case.jcr:path | assignee.acl_identifier |
|---|
| /case/content/STLK/10001 | klant1 |
| /case/content/STLK/10001 | user7 |
| /case/content/STLK/10003 | klant2 |
| /case/content/STLK/10003 | user8 |
| 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)
