お気に入りGorav Seth (Ashoka) (元の投稿者: Rick Haag)2017年8月18日 15: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日 15: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.表示件数を増やす