Error occurs when attempting to perform a search using the 'All' field in VTEX CRM UI

Storage

•

ID: 925679

Backlog

Published on10/25/2023

•

Last updated on11/13/2024

1 min read

Summary

The "All" filter in the CRM UI returns an error when used in entities with many documents. This occurs because the "All" filter performs a wildcard search across all searchable fields, which can result in an error due to the high volume of data being queried.

${"base64":" ","img":{"width":1612,"height":482,"type":"png","mime":"image/png","wUnits":"px","hUnits":"px","length":45132,"url":"https://raw.githubusercontent.com/vtexdocs/known-issues/refs/heads/main/docs/en/known-issues/Storage/error-occurs-when-attempting-to-perform-a-search-using-the-all-field-in-vtex-crm-ui_1.png"}}$

Simulation

Access the CRM UI https://.vtexcrm.com.br/ and navigate to a view representing an entity with many records.
Initiate a search using the "All" field.
${"base64":" ","img":{"width":799,"height":72,"type":"png","mime":"image/png","wUnits":"px","hUnits":"px","length":12221,"url":"https://raw.githubusercontent.com/vtexdocs/known-issues/refs/heads/main/docs/en/known-issues/Storage/error-occurs-when-attempting-to-perform-a-search-using-the-all-field-in-vtex-crm-ui_2.png"}}$
Search for any term in the search field.
Observe that the system attempts to perform a wildcard search on all searchable fields, which may result in an error due to the high volume of data. "An unexpected error has occurred. Please try again. If the problem persists, contact support."
${"base64":" ","img":{"width":607,"height":155,"type":"png","mime":"image/png","wUnits":"px","hUnits":"px","length":15407,"url":"https://raw.githubusercontent.com/vtexdocs/known-issues/refs/heads/main/docs/en/known-issues/Storage/error-occurs-when-attempting-to-perform-a-search-using-the-all-field-in-vtex-crm-ui_3.png"}}$

Workaround

Use filters for specific fields.