즐겨찾기Gorav Seth (Ashoka) (최초 작성자: Rick Haag)2017년 8월 18일 오후 3:59Looping and Fast Updates.pngRick HaagLoops, Fast Updates and CPU Timeouts I have done a bit of research to find if there is some way to mass update records in an Sobject Collection Variable "without" Looping through each recordAssigning a value to an Sobject VariableAdding to a final collection and finally using the Fast Update element to write the new value. Is it possible to simply run a Fast Lookup to build the collection and then update a single column in the collection, with the same value for every record, then Fast Update? Example:Fast Lookup (Opportunity: ID & CustomCheckbox__c).After the fast lookup, update resulting collection to where "Custom Checkbox" in all records of the collection is set to TRUE.Fast Update Is there some way to do this without looping through each record in the collection? I have looked in to Collection Variables, using 1 assignment to set values in an Sobject Collection Variable, but that isn't an option (or I haven't been able to make it work). Why not just run the loop option, you may ask?It seems for collections somewhere between 600 & 700 records, looping through records triggers a Limit Warning or CPU Timeout, and thus the flow fails.더 보기댓글 2개댓글 더 보기...Gorav Seth (Ashoka)2017년 8월 18일 오후 3:59https://success.salesforce.com/0D53A00003DKPim댓글 추가댓글을 작성하세요...굵은 글꼴기울인 글꼴밑줄취소선불릿 기호 목록번호가 지정된 목록링크 추가코드 블록이미지 삽입파일 첨부링크 URL취소저장0/9000답글 쓰기
Rick HaagLoops, Fast Updates and CPU Timeouts I have done a bit of research to find if there is some way to mass update records in an Sobject Collection Variable "without" Looping through each recordAssigning a value to an Sobject VariableAdding to a final collection and finally using the Fast Update element to write the new value. Is it possible to simply run a Fast Lookup to build the collection and then update a single column in the collection, with the same value for every record, then Fast Update? Example:Fast Lookup (Opportunity: ID & CustomCheckbox__c).After the fast lookup, update resulting collection to where "Custom Checkbox" in all records of the collection is set to TRUE.Fast Update Is there some way to do this without looping through each record in the collection? I have looked in to Collection Variables, using 1 assignment to set values in an Sobject Collection Variable, but that isn't an option (or I haven't been able to make it work). Why not just run the loop option, you may ask?It seems for collections somewhere between 600 & 700 records, looping through records triggers a Limit Warning or CPU Timeout, and thus the flow fails.더 보기