use Activity/RD to fetch all the operators and mail it to email id
hi ,
I need to fetch all the operators i have in Pega and save it in excel (may be mail to any email id)
i wrote one Report definition which gives all the list of operators but export to excel doesn't work and moreover this excel is needed in email
Any suggestions?
Thanks,
Ritika
Accepted Solution
EvonSys India Pvt Ltd
AU
store the value in string(text) at property-set, not with date property because the return value is not valid date format it seems.
try and let me know
EvonSys India Pvt Ltd
AU
If you want excel with all the operator id and email, try like this
1. Create data table with operator id and email id
2. create test activity and try obj-brows or RD(Data-Admin-Operator-ID) to fetch all the operator records
3.Create new page and set values which you fetch from above(pyAddresses(Email).pyEmailAddress) and do the obj-save
4. Export excel from data table where all the records saved
let me know If my understanding wrong from your expectation
Infosys
IN
hey Surya Prakash,
Thanks! actually i had to browse all the operators of pega and get them in excel sheet but now it is done by an activity.
The only thing is i am getting the date in the format as (20160520T080945.000 GMT) but need to convert it in the format (17-9-2018 9:58:00)
Any idea how can we achieve it ?
EvonSys India Pvt Ltd
AU
Try as below it's work for your requirement and make sure to close this as an answerable(If it solve your problem) so that it helps other pega community
I hardcoded the date you can change as per requirement
@FormatDateTime("20160520T080945.000 GMT", "dd-mm-yyyy hh:mm:ss", "GMT-1", "en-US")
Accepted Solution
EvonSys India Pvt Ltd
AU
store the value in string(text) at property-set, not with date property because the return value is not valid date format it seems.
try and let me know