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.
***Edited by Moderator: Lochan to update platform capability tags***
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.
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.