Using Data Properties From the Parent Work Items in Activity Email Templates

re: Using Data Properties From the Parent Work Items in Activity Email Templates

John Zimmerman — Tue, 21 May 2013 14:05:37 GMT

Thank you Alexander! Your solution worked perfectly. I had to double check <ID>System.WorkItem.ChangeRequest.Library</ID> because it was listed under another alias in the Management Pack.

Why is your solution not shouted off a rooftop? Everywhere I search people say it is not possible to pull up that information but digging deep in the comments is where the answer lies. Thanks!

re: Using Data Properties From the Parent Work Items in Activity Email Templates

Saman — Wed, 20 Mar 2013 04:54:37 GMT

Nobody can help me ?

I have same issue like as comment that sent by "Wyatt Wong"

1. Is it possible to include the SM Portal Change Request URL in the Review Activity and Manual Activity e-mail template ?

2. Is it possible to add the Requester or Reviewer's display name into the Review Activity e-mail template ?

re: Using Data Properties From the Parent Work Items in Activity Email Templates

Robert.Rambo — Tue, 19 Mar 2013 20:27:08 GMT

@Alexander.Markel

I still can't get mine to work.. I have the correct reference in my MP but when I try to type in the substitution string or copy/paste, etc.. the notification email just prints the sub string.

re: Using Data Properties From the Parent Work Items in Activity Email Templates

Saman — Sun, 03 Mar 2013 08:26:33 GMT

I have same issue like as comment that sent by "Wyatt Wong"

1. Is it possible to include the SM Portal Change Request URL in the Review Activity and Manual Activity e-mail template ?

2. Is it possible to add the Requester or Reviewer's display name into the Review Activity e-mail template ?

re: Using Data Properties From the Parent Work Items in Activity Email Templates

alexander.markel — Tue, 26 Feb 2013 12:13:53 GMT

Just wanted to add that it is possible to insert Change Request specific fields (such as Change Reason, Implementation Plan, etc.) in the notifications, but not directly via GUI.

You can't insert those properties by using the insert button in the notification template Editor, you'd have to type / paste them manually in instead.

To Access those properties you can use the following Schema

<b>Reason:</b>$Context/Path[Relationship='CustomSystem_WorkItem_Activity_Library!System.WorkItemContainsActivity' SeedRole='Target' TypeConstraint='CustomSystem_WorkItem_ChangeRequest_Library!System.WorkItem.ChangeRequest']/Property[Type='CustomSystem_WorkItem_ChangeRequest_Library!System.WorkItem.ChangeRequest']/Reason$

You just have to ensure that your Management pack with the notifications contains a reference to the System.WorkItem.ChangeRequest.Library. If it already does, use your reference alias and replace the "'CustomSystem_WorkItem_ChangeRequest_Library" alias from my example with yours. If you don't have a reference set to this MP just add the following reference to your MP references section:

<ID>System.WorkItem.ChangeRequest.Library</ID>

</Reference>

With this approach it's possible to subscribe / insert any CR specific properties to your activity notifications.

Hope that helps.

Cheers

Alex

re: Using Data Properties From the Parent Work Items in Activity Email Templates

Graham Davies — Mon, 28 Jan 2013 18:47:48 GMT

We don't use parallel activities much so we did a workaround using Orchestrator. There are a few examples on my blog:

www.systemcentersolutions.co.uk/.../service-manager-some-thoughts-around-emailing-review-activity-details-and-the-exchange-connector

I'm looking to do this via PowerShell in the future to improve performance

re: Using Data Properties From the Parent Work Items in Activity Email Templates

Ray — Wed, 19 Dec 2012 02:16:50 GMT

Sorry for the half post.. Tripped up on my iPad. I also need to include the CR information on review and manual activities when they are contained within a parallel activity.... Has anyone figured this out?

Thanks,

Ray

re: Using Data Properties From the Parent Work Items in Activity Email Templates

Ray — Wed, 19 Dec 2012 02:14:01 GMT

This looks great and gets me about 50% where I need to be. I lso

re: Using Data Properties From the Parent Work Items in Activity Email Templates

Matt_Hall88 — Tue, 20 Nov 2012 11:35:52 GMT

@Anatoliy, @Travis,

Thanks guys, was the square brackets in the subject that was missing, clearly I can't read and copy text correctly haha :P

Thanks again

re: Using Data Properties From the Parent Work Items in Activity Email Templates

Anatoliy Pavlyuchenko — Mon, 19 Nov 2012 19:39:18 GMT

@Matt_Hall88

OK, I see. Subject should contain RA Id in bracket [RA12345]. Body should contain keyword that is configured in Exchange connector (including bracket as well if configured in the connector).

It works fine in our environment.

BR,

Anatoliy