Hey Flow-natics!
I would appreciate any help understanding what counts as a SOQL query in a flow. More details on the specific situation are below:
I'm running into this error with my flow: "System.LimitException: hed:Too many SOQL queries: 101." After debugging I see that the flow is failing on a path where a decision element checks whether one field "contains" any of 9 different values (OR logic). Do each one of these 9 "OR" conditions count as a SOQL query or are they lumped together as 1 query due to being contained in the same decision element?
답변 6개
Hi @Lee Ann Zies,
- All 'Get Records' elements are considered as SOQL.
- If you keep it in an iteration, each iteration is counted as one SOQL.
- If your loop iterates more than 100 times, you will see hitting the limit.
- It counts all the Get Records which are executed in the flow, meaning one Get Records executed 50 times in a iteration and other Get Records executed more than 50 times, It will hit the limit.
