We have a need for a workflow which is capable of replicating the Group_CONCAT() function in SQL.
SELECT emp_id, fname, lname, dept_id, GROUP_CONCAT ( strength ) as "strengths" FROM employee group by emp_id;
|1||mukesh||gupta||2||Leadership, Resposible, Quick-learner|
|4||keshav||singhal||3||Listening, Critical thinking|
If anyone has any ideas on how to apply this logic using the targeting activities available in Adobe Campaign Classic, please let me know!
Solved! Go to Solution.
Thanks David. I was able to add a function groupConcat() but struggling to put this into practice by leveraging the function inside of the .js. Is there an easier way to iterate through & group the records together using one of the built-in jsapi functions? In the end, I just need to send a single email to Manager Id1 listing each of their associate emails in some way. I'm probably overcomplicating it.
Hi @reddyx0133 - instead of the comma-separated string, we were able to find an approach that iterated through all of the records belonging to a user in a data table & create a list of their specific associates that were active on the website in the past 24 hours &send in an email to the user.
Hi, Please bear in mind that you have referenced this GROUP_CONCAT() function from MySQL DB Engine. But as you may know, most of Adobe Campaign solution are implemented with PostgreSQL DB engine. So you need to find the equivalent aggregate function depending of your instance DB Engine.