Mailing-List: contact dev-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@jackrabbit.apache.org
Received-SPF: pass (asf.osuosl.org: domain of marcel.reutegger@gmx.net
 designates 213.165.64.20 as permitted sender)
Message-ID: <44EAF3CA.4010706@gmx.net>
Date: Tue, 22 Aug 2006 14:08:42 +0200
From: Marcel Reutegger <marcel.reutegger@gmx.net>
User-Agent: Thunderbird 1.5 (Windows/20051201)
MIME-Version: 1.0
To: dev@jackrabbit.apache.org
Subject: Re: Search with the SQL language and conditions
References: <11320557.1156241242475.JavaMail.www@wwinf4006>
In-Reply-To: <11320557.1156241242475.JavaMail.www@wwinf4006>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Expressions on the pseudo property jcr:path are very limited and will 
in general only work in a reasonable way when you limit the nodes to a 
certain subtree of the workspace.

e.g. jcr:path like '/foo/bar/%'

XPath might do the job:

//element(oliver, nt:file)

will return all nt:file nodes named 'oliver'.

Jackrabbit also puts the node name into the fulltext index, which 
means you could to this:

select * from nt:file where contains(*,'oliver')

or

//element(*, nt:file)[jcr:contains(*,'oliver')]

regards
  marcel

olivier wrote:
> Hi, 
> I would search files in the repository. I use SQL language.
> Here my code : 
> String keywords = "olivier";
> String querySQL = "SELECT * FROM " + "nt:file" +" WHERE jcr:path Like '%" + keywords + "%'"; 
> QueryManager queryManager = session.getWorkspace().getQueryManager();
> Query query = queryManager.createQuery(querySQL,"sql");
> QueryResult queryResult = query.execute();
> System.out.println("noombre de resultats : " + queryResult.getRows().getSize());
> I obtain no error, but no results. When i delete the condition "where...", I recover all the files.
> Why don't it function with the condition "where..."? 
> Somebody can he help me?
> Olivier