Han Dao,
As you have guessed, the creator_id is a string that holds the ID of the process's creator and, unfortunately, none of the send email services allow an email address to be specified as such.
To query for the actual email address of the process creator, use the "Query Single Row" operation of the JDBC service. This service can be found within the "Foundation" category.
The service accepts the following input:
1) Datasource Name: This is a string value that points to the JNDI reference for the data connection you want. If you simply leave this parameter blank, however, it will simply use the default database connection for LiveCycle which has the Adobe database.
2) SQL Statement: Opening up this parameter allows you to type in an actual SQL query. The query you want is as follows:
SELECT A.email FROM LiveCycle_DBO.EDCPRINCIPALENTITY AS A WHERE id = '_________'
The underscores above are where you place your creator_id variable. To do this, simply click the "XPath" button below the text field and add it. I would add that if your LiveCycle database is transactional you should append a WITH (NOLOCK) immediately after your FROM clause to ensure you don't lock the table and disallow other transactions.
3) Data Mapping: Opening this up will allow you to map between data points returned from your query and a process variable within your LiveCycle orchestration. The index column is arbitrary but the Column Name needs to match the respective column names from your query.
The service returns the following output:
1) Number of Rows: An integer value representing the number or rows returned. I believe for this service (Query Single Row), it will always be either 0 or 1.
After running this service, the email address for the originator of your process will be in whatever process variable (String) you assigned it to in the Data Mapping above.
Feel free to shoot me an email should you have any issues or any further questions.
Josh Boyle
jboyle@cardinalsolutions.com
Cardinal Solutions Group
