Skip to main content

KI-120

Document Search unexpected token: ')' if all intermediate results have no files

Created date

05/09/2024

Updated date

11/04/2024

Status

Done

Related work item

PLTFM-2150

Description

When performing a document search, if all of the documents matching the filter criteria do not have a document, an error occurs.

This is because the code is not checking for an empty Content Document ID list and making a filter of WHERE ID IN (). Therefore, Salesforce is interpreting that as an invalid search and generating the error.

Affects version(s)

MIC V13

Impacted capabilities

Inquiry Management

Content Management

Steps to reproduce

  1. Perform a free text search with filters on the Documents tab or MIC Content Search where all documents meeting the filter criteria have no document.

  2. Observe the error.

Workaround

Previous workaround prior to fix: Make a file that looks/formatted like the metadata and upload it.

Fix version

MIC V15

Resolution notes

Users can now see all results matching their filter criteria without encountering an error.