On Fri, Oct 22, 2010 at 19:35, Neil Corbet <ncor...@towerhillservices.com> wrote: > Fabián Mandelbaum <fmandelbaum <at> gmail.com> writes: >> I'm using JackRabbit 1.6.2 on my project and I was wondering which >> would be the query to execute (either XPath or SQL) to be able to >> search for a given string in a file name (search in file names). > > I think you may want to use the fn:name() function in the query. Something > like: > " fn:name() LIKE 'Samba' " you could include the "jcr:path LIKE > '/workspaces/W1/content/%'" to help guide it down the right path and use > fn:name() to narrow it down to a set of names.
No, fn:name() in jcr-sql (the one from jcr 1.0, in Jackrabbit 1.x) does not support wildcards. Wild card search on node names is only possible since Jackrabbit 2.0 using JCR-SQL2. See http://jackrabbit.markmail.org/thread/xvoo5afksxtyplhw Regards, Alex -- Alexander Klimetschek alexander.klimetsc...@day.com
