Skip to main content

KI-120

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

Created date

05/09/2024

Updated date

05/09/2024

Status

Backlog

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)

Spring '23

Impacted capabilities

N/A

Steps to reproduce

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

  2. Observe the error.

Workaround

Make a file that looks/formatted like the metadata and upload it.

Fix version

Fall '24

Resolution notes

N/A