Expand my Community achievements bar.

Dive into Adobe Summit 2024! Explore curated list of AEM sessions & labs, register, connect with experts, ask questions, engage, and share insights. Don't miss the excitement.

Get Email Address of Process Creator

Avatar

Former Community Member
I have a requirement to, at the end of my workflow process, render the form as a PDF document which will be mailed back to the process creator. Is there some way to obtain the creators email address within my process so that I can accomplish this?
5 Replies

Avatar

Level 10
You would probably need to query the database and get the email associated with the /process_data/@creator_id variable.



You can also use the API and build a custom component to do it.



Jasmin

Avatar

Former Community Member
What table would I query? When you say "use the API and build a custom component" I'm not sure what you mean.

Avatar

Former Community Member
that would not be necessary for you,as you can just query the DB and get the email

the sql query would be

select email from edcprincipalentity where id = '{$/process_data/@creatorID$}'

Avatar

Former Community Member
It worked - I just had to add a JdbcService step, set the Datasource Name to the literal value java:\DefaultDS, and to define a data mapping to output the returned record to a string variable.