How to find by a relative path in jcrQuery (Sql2)

Question

I´m trying to find a node by a relative path:

I need to search a node which terminates in : 3265

I´m using queries like that:

SELECT * from [mgnl:news] AS t WHERE ISSAMENODE([/%/3265])

I need to know how to find a node by a relative path, thanks

score 1 · Accepted Answer · answered Mar 16 '16 at 14:36

1

That´s the answer:

Select * from [mgnl:news] as t where name(t) = '3265'

This returns my node: /Application/news/3265

Thanks also.

answered Mar 16 '16 at 14:36

Miguel Carrasco

Well, it may because you are typically query by name instead of path :) Happy that you found your way, cheers – Ducaz035 Mar 16 '16 at 15:43

Ducaz035 · Answer 2 · 2016-03-16T12:53:28.963

0

You may do something like

Select * from [nt:base] where path like '%.%'

Cheers,

edited Mar 16 '16 at 12:53

answered Mar 16 '16 at 11:52

Ducaz035

this not function, also i´m trying like that: Select * from [mgnl:news] where [jcr:path] like '%201003181%'" and not function – Miguel Carrasco Mar 16 '16 at 11:57
Are you using JCR Queries app ? May i learn where do you execute this query from ? – Ducaz035 Mar 16 '16 at 12:54

2 Answers2