Loading

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

Udgivelsesdato: Nov 13, 2025
Beskrivelse

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'
 
Vidensartikelnummer

000390354

 
Indlæser
Salesforce Help | Article