Skip navigation

1 Reply Latest reply on Oct 23, 2015 1:35 AM by hchiorean

get current node's all child nodes by jcr-sql2

delgo Oct 22, 2015 9:19 PM

Hi,

I can get current node by sql:"select * from [modelname] where PATH()='/.....'",

But I want all child nodes by sql

1. Re: get current node's all child nodes by jcr-sql2

hchiorean Oct 23, 2015 1:35 AM (in response to delgo)

You can read about the different JCR-SQL2 constraints and operands here: JCR-SQL2 - ModeShape 4 - Project Documentation Editor. For example ISCHILDNODE: JCR-SQL2 - ModeShape 4 - Project Documentation Editor
Actions