path query

["Birmingham, Steven" <St...@itt.com>]

OK, I am getting pretty frustrated.  Why does this SQL2 query return 0 nodes?  I have 1000 nodes under /signals which is of type nt:unstructured.

Select [jcr:path] from [nt:unstructured] WHERE [jcr:path] LIKE '/signals/%';

Steve

________________________________
This e-mail and any files transmitted with it may be proprietary and are intended solely for the use of the individual or entity to whom they are addressed. If you have received this e-mail in error please notify the sender.
Please note that any views or opinions presented in this e-mail are solely those of the author and do not necessarily represent those of ITT Corporation. The recipient should check this e-mail and any attachments for the presence of viruses. ITT accepts no liability for any damage caused by any virus transmitted by this e-mail.

Re: path query

[Guo Du <mr...@gmail.com>]

On Thu, Mar 4, 2010 at 8:49 PM, Birmingham, Steven
<St...@itt.com> wrote:
> Select [jcr:path] from [nt:unstructured] WHERE [jcr:path] LIKE '/signals/%';

Another format in SQL2:
Select [jcr:path] from [nt:unstructured] WHERE ISDESCENDANTNODE('/signals')

More details:
http://www.day.com/specs/jcr/2.0/6_Query.html#Constraint

-Guo