Loading

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

Fecha de publicación: Nov 13, 2025
Descripción

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.

Solución
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'
 
Número del artículo de conocimiento

000390354

 
Cargando
Salesforce Help | Article