QuickSearch is a standalone web service that runs against DBXL v2.1 and v2.2. In order to get QuickSearch to work you have to:
1. Manually copy the files from the attached zip file into your QdabraWebService directory, copying the DLL into the bin folder and the QuickSearch asmx file in Qdabra’s root folder.
2. Add permissions to both the asmx file and the dll file. You can view the file’s permissions by right clicking on it and selecting Properties. For reference, look at the permissions that DBXL allocates to the other asmx and dll files, and then add the permissions that are missing for the files copied in step 1.
3. In SQL server, enable full-text index on the DataExtractedPlaintext field of the Document table in the QdabraDBXL database. This is a two step process.
a. First, execute a command similar to this:
use mydatabase
go
EXEC sp_fulltext_database 'enable'
go
CREATE FULLTEXT CATALOG mycatalog
go
b. Then design the Document table and add a full text index for the DataExtractedPlaintext field.
You can now use QuickSearch in your InfoPath forms by referencing the new web service. The input parameters are the following:
• searchPhrase: a string which will be used to search the documents created in DBXL.
• searchType: All or Metadata or Data.
• docType: a string that contains the name of the document type configuration that will be searched.
The forms referencing QuickSearch will not be portable because the absolute URL to DBXL will not be changed upon deployment to another server. This means that if you have originally developed against http://<host1>/QdabraWebService/QuickSearch.asmx, before deploying to http://<host2> you have to manually update the reference in your XSN. Usually, for other web services, DBXL will update the URL for you but this is not supported for QuickSearch yet.
Note that Quick Search only works with single words. Multi-word queries will fail and cause an exception. This will be fixed in a future version.