Re: SQL example to replace basicsearch

[David Nuescheler]

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