Question

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***

Correct Answer
November 15, 2019 - 10:21am

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

Comments

Keep up to date on this post and subscribe to comments

November 15, 2019 - 10:08am

Hi Guys,

 

Anybody please?!

November 15, 2019 - 10:21am

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

November 15, 2019 - 10:36am
Response to vaspoz

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.

November 15, 2019 - 10:50am
Response to vaspoz

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.

November 18, 2019 - 5:25am
Response to jeevanm7

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?

November 15, 2019 - 11:07am

Hi Guys,

Anyone please help me with the steps. I am stuck.