...
3.2.根据用户名称获取用户属性:email:
//根据用户名获取用户对象var 根据用户名获取用户对象
var user = usrManagerService.getUserByName(userName);
//根据key值获取用户扩展属性,此处获取用户的email地址var 根据key值获取用户扩展属性,此处获取用户的email地址
var email = usrManagerService.getUserAttribute(user.getId(), "email").getValue();
3.3.通过设置用户名参数:
//设置格式:{id:"OutputParameter.数据集ID.参数名称",value:参数真实值,displayValue:参数显示值}
var reportParamSetting = [{id:"OutputParameter.I2c9019810158fc12fc1224c00158fc2e21c50069.当前用户",value:userName,displayValue:userName}]
//参数值也可以设置为固定值,变量,或者默认值,其中默认值写法:"$默认值$"
如:{id:"OutputParameter.I2c9019810158fc12fc1224c00158fc2e21c50069.测试",value:"$默认值$",displayValue:"$默认值$"}
3.4.打开报表:
//打开报表的方法基本固定,无需作出更改。
var openReportOutput = execute('openResource', {
connector: connector,
reportId: reportID
});
...
var exportReportOutput = execute('exportResource', {
connector: connector,
resourceHandle: openReportOutput.resourceHandle,
paramSettingIterator: enumerateParamValuesOutput.getParamValues(),
exportSetting: {"delimiter":"","pathId":"","fileNameSufParams":false},
taskName: taskName,
exportType: "EXCEL2007"
});
3.6.发送邮件:
var title = "%TASKNAME_%DATE%TIME";//邮件标题,默认为:任务名称_日期时间
var text = "这是一个系统自动发送的邮件,所含附件是您订阅的报表";//邮件正文内容
var doZip = true;//是否需要压缩,默认:是。
var picInMail = false;//是否将图片作为正文内容,默认:否
var sendToMailOutput = execute('sendToMail', {
connector: connector,
taskName: taskName,
paramValueMap: null,
files: [outputFile],
//设置邮件
sendSetting: {"mailList":email,"doZip":doZip,"title":title,"text":text,"picInMail":picInMail}
});
...