First of all, good year everybody.
1. I 've seen that i can store document in the Derby Database thanks to the Document attribute. It's great, but we cannot use the contents of the documents in queries directly. It's annoying because it is what we want to do. Can we use our documents outside the Derby database . If so, how? Do you have an example?
2. I try to make a SQL query using the Windows Indexing Service but it doesn't work. Can you help me to fix the problem?
Code: Select all
SELECT Candidat.* FROM AladdinV2_CANDIDAT AS Candidat WHERE Candidat.infosCandidat = ALL (Select Path,FileName from SCOPE (DEEP TRAVERSAL OF {"\\Laboratoire\Inetpub\wwwroot\lab\cabinet\module"})WHERE contains (contents,{?'infosCandidat'}))