sqlmagnoliajcr-sql2

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


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


Solution

  • That´s the answer:

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

    This returns my node: /Application/news/3265

    Thanks also.