how to send emails to users in data type
hi guys,
i have a data table with employee info namely id, name, company, salary and emailaddress. i want to send emails to employees with salary greater than an amount using an activty. please help me with steps.
I have tries obj browse with select salary>amount-> then loop through embedded pages and then tried to property-set .emailid(property to store emailid from table) = pxresult(<CURRENT>).emailaddress. But the problem is pxresult(x) contain only salary property because of select condition, I don't know how to get the emailid property from table.
Help is very much appreciated.
Thanks
Jeevan
***Edited by Moderator: Lochan to update platform capability tags***
Accepted Solution
BPM Company
NL
Could you please provide a screenshot of your Obj-Browse.
I guess you should uncheck all selects in Obj-Browse. Thus it will fetch all columns.
Or
Explicitly add emailaddress property in Obj-Browse with Value Only option
Accepted Solution
BPM Company
NL
Could you please provide a screenshot of your Obj-Browse.
I guess you should uncheck all selects in Obj-Browse. Thus it will fetch all columns.
Or
Explicitly add emailaddress property in Obj-Browse with Value Only option
hcl
IN
Hey Vaspoz,
PFB screenshots:
Hey Vaspoz,
PFB screenshots:
I have 2 records with salary > 50000, with select condition over salary pxresultscount is 2 and i am looping my obj-browse over each embedded page with step page "employeeinfopagelist.pxResults". But pxResults(x) contains only salary property, i am unable to pull emailaddress property from page list.
hcl
IN
If I uncheck all select options, how can i get emailaddresses of employees whose salary is greater than 50000? With select unchecked it will fetch emailaddresses of all employees, but that is not what i want.
BPM Company
NL
Add "A" in the Label field. And also in the Logic field.
"Select" does not related to your logic. it's like in Select sql statement.
So, having Salary unchecked, can you see other fields in the pxResults?