Question
Instellars Global Consulting pvt ltd
IN
Last activity: 18 Jan 2023 2:00 EST
How to get the values from pxresults of an activity to the section used in correspondence
Hi
I have a requirement to send email to the users if they have created any task in a case
so i am using report definition to get the cases with case owner and remaining four properties which i want send to email.
so i have created activity with these report definition and got the pxresults page list
the requirement is send email to the case owner every monday morning with all the tasks he has created in the cases.on case owner can be having two tasks created in two differnent cases.
so how can i loop through the pxresults and get the values one cases with all the tasks created and send the mail to corresponding owner with all the deatils as a table to email
for this email part i have cretaed correspondence with included section in it and in that section i am using table which is used for tasks.
so how to get the tasks of each case owner and look for his/her email id and populate the details in that correspondence section and send mail.