Finally my content search in documents works fine but when using 'Doesn't
contain' search I get the error as below. When 'Contains' everything works fine
and it correctly returns the documents that contain the word. It is not critical
for me but just letting you know. -----------------------------------
An error
occurred in the following search: SELECT {objectQualifier}DMX_Entries.*,
ParentEntries.Description AS CollectionName,
{objectQualifier}DMX_Extensions.Icon16 FROM {objectQualifier}DMX_Entries,
{objectQualifier}DMX_Entries AS ParentEntries, {objectQualifier}DMX_Extensions,
OPENQUERY(DNNdocs, 'SELECT Filename, Rank FROM SCOPE() WHERE NOT
CONTAINS(Contents, ''"alien"'')') AS Docs WHERE
(({objectQualifier}DMX_Entries.CollectionId *= ParentEntries.EntryId) AND
({objectQualifier}DMX_Entries.PortalId = 0) AND
({objectQualifier}DMX_Entries.EntryType =
{objectQualifier}DMX_Extensions.ExtensionKey) AND
({objectQualifier}DMX_Extensions.PortalId = 0) AND
(';'+{objectQualifier}DMX_Entries.ViewRoles LIKE '%;-1;%') AND
({objectQualifier}DMX_Entries.IsApproved=1 OR
{objectQualifier}DMX_Entries.UserId=-1) AND
({objectQualifier}DMX_Entries.EntryId =
{objectQualifier}DMX_Entries.LastVersionId) AND
({objectQualifier}DMX_Entries.Deleted = 0) AND (CHARINDEX(Docs.Filename,
{objectQualifier}DMX_Entries.Entry,1) > 0)) Error: Could not execute query
against OLE DB provider 'MSIDXS'.
|