59、salesforce实现数据的批量处理

批处理,往自己的邮箱发一封邮件,批处理采用异步的处理方式处理数据,最多可以处理5000万条数据

global with sharing class MerchandiseBatch implements Database.Batchable<sObject>,Database.Stateful{ Integer queryCount = 0; String myEmailAddress = 'weizhen.zhao@pactera.com'; global Database.QueryLocator start(database.BatchableContext bc){ String query = 'select Name from Merchandise__c'; return Database.getQueryLocator(query); } global void execute (Database.BatchableContext bc,List<Merchandise__c> merchandiseList){ for(Merchandise__c merchandise : merchandiseList){ Decimal price = merchandise.Price__c; price += 1; queryCount +=1; } upsert merchandiseList; } global void finish(Database.BatchableContext bc){ System.debug('query count: '+ queryCount); Messaging.SingleEmailMessage email = new Messaging.SingleEmailMessage(); email.setToAddresses(new String[]{myEmailAddress}); email.setSubject('show count');//set subject email.setHtmlBody('query Count' + queryCount); Messaging.sendEmail(new Messaging.SingleEmailMessage[]{email}); } }
MerchandiseBatch merchandise = new MerchandiseBatch();
Id batchId = Database.executeBatch(merchandise);

 

转载于:https://www.cnblogs.com/weizhen/p/6407573.html

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
在任何列表视图上批量创建,批量更新,批量克隆,批量删除。支持经典和闪电! Salesforce Mass Editor is a simple but powerful chrome extension for doing the below things : ・Makes any Salesforce list view to be a powerful mass editor. ・Mass insert, mass clone, mass update and mass delete. ・Mass copy & paste from Excel with multiple rows and cells data. ・Export list view data to CSV file. If you have any question or issue, report it to HERE( https://github.com/xgeek-net/salesforce-mass-editor/issues ), I'll fix it ASAP! <日本語> Salesforce一括編集はシンプルで強力なChrome拡張機能で、下記の機能があります : ・数秒間で標準リストビューが強力な一括編集ページに変えます ・一括新規、一括コピー、一括更新、一括削除全てが可能です ・Excelの複数行・列のデータの一括コピー&ペーストができます ・編集中のデータをCSVにエクスポートできます ++++++++++++++++++++++++++++ Release notes ++++++++++++++++++++++++++++ 2018/10/18 ・Add support for Lightning S-Console. -------------------------------------- 2018/09/25 ・Add support for cloudforce orgs. -------------------------------------- 2018/08/24 ・Add supports for Community! ・Fix bugs for Lightning Sandbox. -------------------------------------- 2018/06/14 ・Fix bugs for Lightning -------------------------------------- 2018/05/17 ・Add support for Lightning new URL(Summer 18) -------------------------------------- 2018/01/23 Major release (v3.0.0) ・Add support for Lightning! ・Fix bugs for Classic. -------------------------------------- 2017/12/15 ・Fix updatable permission only issue. -------------------------------------- 2017/12/10 ・Fix polymorphic reference field issue. -------------------------------------- 2017/11/10 ・Add feature of all check / select to fields. -------------------------------------- 2017/08/13 ・Add permission control of Csv Exporting. -------------------------------------- 2017/05/20 ・Improve UX when using Non-Admin user. -------------------------------------- 2017/03/26 ・Improve mass paste UX. -------------------------------------- 2017/03/13 ・Fix bugs. -------------------------------------- 2016/12/02 Major release ・New features of mass insert and mass clone. ・Fix csv fi
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值