This content has been marked as final. Show 11 replies
you can get the process creator id, then you will have to query the edcprincipalentity table to get the email which corresponds to the process creator id
I am not sure what you want to do if the reviewer accepts the form, some more explanation would be helpful
I'm sorry, but I wouldn't know how to do a query within LC. Is there a way to read this email address and save it into a variable for later use?
With regards to your question, if the user accepts it, I want to allow the user to save or print the form for later use. If the user doesn't accept it, I need to email a message to the process creator about making corrections/additions, as necessary, and resubmitting the form.
You would need to query the edcprincipalentity table. You can use something like this
select email from edcprincipalentity where id = /process_data/TaskCompletedByID. You will need to create a variable of type String and call it TaskCompletedByID, and map it to the completedUserID field in the userService in the FormDataMappings section. after the user service step you would need a query single Row service operation to query the DBfor email and send the email
hope this helps
let me know how it goes
Where do I put that query?
If I understand correctly, and I use the completedUserID field of the FormDataMappings of the reviewer's Assign User task, after this task is completed, the completedUserID field is going to contain the reviewer's address, not the process creator's. Please, correct me if I'm wrong.
Also, from the reviewer's activity (Assign User), on one of the routes, I need to generate and send a message to the process creator (email?) that there are errors and/or omissions. From this message generation task, I need to reassign the task to the process creator for him/her to correct/complete the form. I know this is an Assign User task and not the problem. The problem is in the intermediate step.
yes, the completedUserID gives you the userID if the person who completed the task. If you need to send a email to the process creator you need to query the edcprincipalentity table using the process creator id to get the process creators email. Use the Service called "Query Single Row". This can be found under the services views - Foundation|JDBC|Query single Row.
Use the following settings
For the DataSource setting enter java:/IDP_DS(Assuming you are running mysql/jboss)
then build the query.
This step should be after the user step
We are using JBoss but MSSQL, not MySQL.
I also decided to change the process slightly to avoid unnecessary steps and, perhaps, this query step altogether.
So this is what I have so far: A Set Value task to fill the form, and an Assign User to assign the form for review. Upon acceptance by the Reviewer, the form should be saved and/or printed, as selected by the Reviewer. Upon reject, it should be reassigned to the Process Creator for correction/completion. When this is done, the form should be resubmitted for review.
The form is filled, but the Reviewer gets nothing in his queue (To Do list), even thought he's assigned in the process. The email notifications are not working correctly yet, but it should still be assigned to the Reviewer, correct? He's the Specific User in the Initial User Selection property.
I'd appreciate any help that you can provide.
There are two parts to this request: the email part and the save and display part. I'm sorry, I'm still new at this . . . this is my first process.
The email part is being replaced with a notification within Workspace. Will it show up automatically, or does it use email notifications? See previous posting.
The save and display part: I need to display two buttons after the form is accepted, one for save and one for print. In either case, the for should still be displayed. How can I make them show up? See my previous posting for an explanation on the process.
Thank you for you help!
The task shows up in the Tracking screen, not in the To Do screen where I expected it. I also received no messages within Workspace to let me know that I had a waiting task.
There are no save or print buttons or even a complete button to complete the process. How do I get them in?
TK18, send me a email to mergeandfuse@gmail, i will help you out
Also send me your process email@example.com
I've sent you the process archive for your review. I truly appreciate all the help you are providing.