Adding RequestedByUser and CreatedByUser Fields on the same Portal Form

The Problem. 

I started looking into this issue once a few customers had reported it and wanted to see if there was a solution, so what was the problem? Well, adding these 2 fields to a custom portal form in the portal requires you to put the property name on the portal form. The property name is the target name of the relationship in this case. 

However, the target name for the RequestedByUser and CreatedByUser relationships are identical, which is down to Microsoft for coding it like this…  

portal form

A custom type projection is needed for the portal form to load in both relationships as there is not a type projection out of the box that includes RequestedByUser.  But when you use the custom type projection the portal brings back 2 identical target Ids for ‘CreatedWorkItem, one for CreatedByUser and one for RequestedByUser.  The custom portal form does not understand which one to use and fails. 


The Solution. 

We came up with a solution to get the best of both worlds having both relationships as user pickers displayed on the work item form. 

We started by displaying the CreatedByUser field using the default type projection as this works normally as expected. To include the RequestedByUser field, we built a custom type projection which only included the RequestedByUser relationship and imported this management pack into SCSM. 

Then we added a user picker onto the custom form with a dummy property name to populate a field on the form to work with. 

2019 1220 RequestedByUser and CreatedByUser IMG2 1

Custom JavaScript was used to fill in the information in the empty field, by making a call to the GetProjection API. The WorkItemId (obtained from the view model) and the Id for the type projection, from the management pack mentioned earlier, get passed into the API call to return the information. The code then adds the Name relationship for the RequestedByUser and then binds the information to the field. 

2019 1220 RequestedByUser and CreatedByUser IMG3 1

For more information on this solution, please use this Community page link.

Many thanks to John Doyle and Justin Workman for their help! 

Experience Teams Ticketing Today

Start your 14-day free trial of Tikit. No credit card required.