java - JCR-SQL2 查询通配符搜索不起作用。

Question

我想运行此 JCR SQL2 查询:

SELECT * FROM [nt:base] WHERE path LIKE '/A/B/%'

但是运行查询后我收到以下异常:

javax.jcr.query.InvalidQueryException: Query:
SELECT * FROM [nt:base] WHERE jcr:(*)path LIKE '/A/B/%'; expected: (, ., =, <>, <, >, <=,

Answer 1

SELECT * FROM [nt:base] WHERE ISDESCENDANTNODE([/A/B/%])

了解更多 here