jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David Nuescheler" <david.nuesche...@gmail.com>
Subject Re: SQL example to replace basicsearch
Date Wed, 29 Nov 2006 14:09:37 GMT
hi darren,

if you were looking for the equivalent of...

> String queryssn = "<D:searchrequest xmlns:D=\"DAV:\">" +
> "  <D:basicsearch xmlns:F=\"FAX\">" +
> "<D:select>" +
> "<D:allprop/>" +
> "</D:select>" +
> "<D:from>" +
> "           <D:scope>" +
> "              <D:href>/slide/files/</D:href>" +
> "               <D:depth>infinity</D:depth>" +
> "           </D:scope>" +
> "       </D:from>" +
> "       <D:where>" +
> "           <D:eq>" +
> "               <D:prop><F:ORIGINNUMBER/></D:prop>" +
> "               <D:literal>555-555-5555</D:literal>" +
> "           </D:eq>" +
> "       </D:where>" +
> "   </D:basicsearch>" +
> "</D:searchrequest>";

...in sql on jcr I guess...

select * from nt:base where F:ORIGINNUMBER='555-555-5555' and jcr:path
LIKE '/slide/files/%'

...would do the trick.

regards,
david

Mime
View raw message