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

[delgo]

Hi,

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

But I want all child nodes by sql

[hchiorean]

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