Hi Łukasz, Łukasz Sroka wrote:
I have SQL query : select * from nt:unstructured where jcr:path like '%/childNode0Level1' and XPath : //GUI//childNode0Level1
those two statements are not exactly the same because the XPath statement you have contains two descendant-or-self axis. but that's another issue.
the reason why the SQL query only return one node is the fact that: jcr:path like '%/childNode0Level1' is roughly equivalent to an XPath statement: //childNode0Level[1] See spec section: 8.5.2.2 if you need all same name siblings you have to write: jcr:path like '%/childNode0Level1[%]' regards marcel
