question about std_change_proposal and std_change_template

[cristian1988]

Hello dear Community, Im not sure if I picked the correct location for asking this question but here I go:

So we have a notification set that will let some approvers know about when a standard change proposal is created and waiting for approval. here the issue: the notification contains a variable "${sysapproval.business_service}"

but when the email is sent. that value comes empty, (I need it to be populated with what the template values has).

Taking a look into the template that was created in the proposal In the tab named "Change request values" I get to see that there is a list of fields such as description, risk, justification, and SERVICE, I could notice that all those fields are stored in  the  std_change_template  table, but I have no clue on how to try to read it so it can be populated each time a proposal is insterted.

Some considerations:

- I get to understand that those values are stored in an encoded query as a whole, (This can be seen if I take a look into the template xml, the service value will appear inside a "<template_value>" tag) --> attached screenshot

- I've been advised to create a business rule that will capture and extract values and extract the service value to finally somehow store it in somewhere so I can eventually call it from the notification email or maybe using an email script.

 I really appreciate your insight about how to achieve this, I´ve been some similar cases posted here but unfortunately, I have not been able to find a way to achieve this.

Please let me know if you need further details on my scenario! and thank you in advance for your help!

[Dr Atul G- LNG]

Hi @cristian1988 

Greetings!!

I am not sure , i understood your issue fully or not but with best understanding will answer.

So we have a notification set that will let some approvers know about when a standard change proposal is created and waiting for approval. here the issue: the notification contains a variable "${sysapproval.business_service}"

but when the email is sent. that value comes empty, (I need it to be populated with what the template values has).

Atul: Where are you entering the value of Business Service? In OOTB, i did not find field with this name.

Taking a look into the template that was created in the proposal In the tab named "Change request values" I get to see that there is a list of fields such as description, risk, justification, and SERVICE, I could notice that all those fields are stored in  the  std_change_template  table, but I have no clue on how to try to read it so it can be populated each time a proposal is insterted.

Atul: The process work like:

1st user create the proposal , means populate the value of change and who is owing the template and category.

The work flow / flow trigger in backend , which generate approval for proposal

3. Once proposal approved it become Template and ready for use.

[cristian1988]

Hello Atul! Thank you for your prompt response

To answer your questions:

Here´s  how it is all set so far:

- user creates  the proposal, this means that fills all the proposal fields from the form and the template values from the proposal form as well (have in mind that one of those values  is called "service. attached screenshot)

- Once the proposal is created, the approvers will receive an email notification, that will tell them that they have a proposal to approver, in the body of that notification we have a "service" field. (screenshot) but as you can see, the value comes empty. the main goal here is to find how to extract the "service" value from the template  and place it into the notification. I have attached an screenshot of what the notification has in the back end. as you can see it expects

${sysapproval.business_service} im open to change that variable I just need that service value to be populated by any mean jaja 🙂 thank you and I hope I was clear enogh 🙂 please let me know if you have further questions!

[Dr Atul G- LNG]

Hi @cristian1988 

Here´s  how it is all set so far:

- user creates  the proposal, this means that fills all the proposal fields from the form and the template values from the proposal form as well (have in mind that one of those values  is called "service. attached screenshot)

Atul: As per screen shot it is showing Service but how it pick up the value, bcz there is no Service Field on proposal , so it is showing blank. 

- Once the proposal is created, the approvers will receive an email notification, that will tell them that they have a proposal to approver, in the body of that notification we have a "service" field. (screenshot) but as you can see, the value comes empty. the main goal here is to find how to extract the "service" value from the template  and place it into the notification.

Atul: To do this, you need to bring or add Service Field in proposal form and then fill the value

The 3rd screens hot say sysapproval.businessService , but we are not sending / filling any where the value of BS so it will be blank.