Loading

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

Publiceringsdatum: Nov 13, 2025
Beskrivning

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.

Lösning
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'
 
Knowledge-artikelnummer

000390354

 
Laddar
Salesforce Help | Article