Loading

Data 360: Calculated Insights cannot process long OR/AND query statements

Дата публикации: Nov 13, 2025
Описание

Data 360 enforces a dynamic limit on how many OR/AND statements can be chained to allow for proper optimization of all CI jobs. Calculated Insights with many “OR/AND” chain in its where statement may not refresh or the status may not update after its initial creation. Typically, low 10s of such statements is fine. It’s best to use an alternate function if longer statements are required.

Решение
As a workaround to reduce the number of ORs needed, you can use ‘rlike’ instead by concatenating different ids with a pipe ("|") - that's similar to OR in a regex. Also, be careful NOT to add space before and after the pipe ("|").

WHERE XY_dlm.xyid__c rlike '7bb19725-d6c6-4d92-8660-e978a95d0953|90f9c270-5817-4bcf-84b0-9f0ba8b9282b|5f63e0f0-c5d5-4e82-bc8c-f46ab8b24f48'
 
Номер статьи базы знаний

000390354

 
Загрузка
Salesforce Help | Article