I am trying to create an email notification when a CR is promoted to the state of In Review from the state of New. Our CRs do not have a workflow so I configured the email notification in the life cycle state of In Review. Unfortunately, it does not work. I tested my query string in AML Studio and it works.What do I have wrong?
Subject
${Item[@type="a_CR"]/a_business_unit} CR Number ${Item[@type="a_CR"]/cr_number} is Pending Your Review
Query String
<Item type="a_CR" action="get" select="id,cr_number,a_business_unit,change_description,change_reason,req_dept">
<id>${Item/id}</id>
</Item>
Body HTML
${Item[@type="a_CR"]/cr_number} is now pending your review in Innovator.
<br/><br/>
<table>
<tr>
<td>Business Unit:</td>
<td>${Item[@type="a_CR"]/a_business_unit}</td>
</tr>
<tr>
<td>CR Number:</td>
<td>${Item[@type="a_CR"]/cr_number}</td>
</tr>
<tr>
<td>Change Request:</td>
<td>${Item[@type="a_CR"]/change_description}</td>
</tr>
<tr>
<td>Change Reason:</td>
<td>${Item[@type="a_CR"]/change_reason}</td>
</tr>
<tr>
<td>Requesting Department:</td>
<td>${Item[@type="a_CR"]/req_dept}</td>
</tr>
</table>
