sorry for not specify clearly and thanks for you reply. the root node is the default "root" node i use session.getRootNode() to get the default root node. then i add "domain" nodes as children of "root" node,then "information" nodes as children of "domain" node,and "news" nodes children of "information" node. then save. but now i want to select some "news" nodes from this tree, i use sql query but get nothing. i follow your sugguestion to modify the jcr:path,but still get nothing jcr:path='/jcr:root/domain/information/news'"; other paths:'/domain/information/news' /root/domain/information/news also used,still get nothing.
Ard Schrijvers wrote: > > Hello, > >> Andvar wrote: >> the structure of the nodes is as follows: >> root >> | >> domain >> | >> information >> | >> news >> I use sql to search the news nodes like this:"select * from >> nt:unstructured >> where jcr:path='domain/information/news'"; > > shouldn't the jcr:path start with /root? > > Also note that [EMAIL PROTECTED] might be a more appropriate list for your > question since it is clearly a user question. > > Regards Ard > > > -- View this message in context: http://www.nabble.com/How-to-get-the--subnodes-of-a-tree-using-sql--tf4371364.html#a12470569 Sent from the Jackrabbit - Dev mailing list archive at Nabble.com.
