How to configure Send E-mail Smart Service ?

prais1852 (prasoonp) Are you able to see the value for pv Id in the instance that is created?

Hi saksheer , I am using expression editor to write subject line of the email and selecting pv!Id from the list of available process variable only.

prais1852 I am assuming when you say ID - you mean the a ID which is used in the form. You are trying to map this pv in your smart service. When you run your process model, you say you are able to trigger the email - but id is not populating. Can you check in the instance, if the pv!id is getting populated once the form is filled? or is this pv!id null throughout the instance?

Hi saksheer , I used an if statement to check for the value of ID and i can see it null, that's why it was also not coming in the subject line earlier. What can i do now to resolve this issue ?

Hi saksheer My process model is very simple. It has a start form, Write to DB and then E-mail smart service. Attached is the screenshot.

prais1852 Is the Id being entered by the user in start form?

Hi saksheer , No - I am generating the ID in backend i.e. in my SQL Server DB using an auto incremented field to generate the ID.

prais1852 If you want the Id from DB to be passed to the smart service, you will have to fetch the Id from DB first - using query rule object or query entity function. Put another node in your process model, and fetch the record id, then use this value to populate in the subject.

However, since you are auto-generating the value, you can have the first value set in a constant. Then keep on auto incrementing this constant value by 1, every time you run the process model. That way the constant value will be in sync with the auto generated value.
I would not recommend using this, in case the values from DB are altered, there will be a discrepancy.

prais1852 If you want the Id from DB to be passed to the smart service, you will have to fetch the Id from DB first - using query rule object or query entity function. Put another node in your process model, and fetch the record id, then use this value to populate in the subject.

However, since you are auto-generating the value, you can have the first value set in a constant. Then keep on auto incrementing this constant value by 1, every time you run the process model. That way the constant value will be in sync with the auto generated value.
I would not recommend using this, in case the values from DB are altered, there will be a discrepancy.

prais1852 (prasoonp) A better way to do this is. In the write to data store entity tab - you have input/output tab. In the output tab, set a pv for stored values. And from this pv, derive ID.

 

 

Thank you so much saksheer . I used the approach you suggested and it is working now.

prais1852 Glad it worked :)