Demand stakeholder assessment recipients question

[jonkin]

Hello all,

I have a requirement where the client wants to be able to modify the demand stakeholders of the selected portfolio as "Assessment Recipients" to "Yes" or "No" on a per demand basis.

I know that the demand pulls form the dmn_stakeholder_register table and displays that on the "Stakeholders" tab on Demand...I also know that modifying any of the values on that related list will affect the master stakeholder table and thus affecting all other demands that use that portfolio.

I did reach out to ServiceNow and they did recommend that I can create the same fields on the dmn_m2m_demand_stakeholder which it turns out the Stakeholder related list is actually looking off this table and all the other fields are just dotwalked back up to dmn_stakeholder_register.

While I am able to now modify the values for Assessment Recipients and Interest and whatnot and have it on a per demand basis...I'm not sure where the script that fires off the assessments is...I tried looking at all the business rules and script includes that involve assessments but what I want to know is where I can change where it looks for the "Assessment Recipient" on dmn_stakeholder_register to "Assessment Recipient" on dmn_m2m_demand_stakeholder instead.

Unfortunately ServiceNow says this is a completely custom thing and they can't support it unless we use Professional Services...Which I would like to avoid.

Thanks in advance!

[Jorge Andre Per · Accepted solution]

Hey Jon,

I just left work so cannot really test this in order to provide you with an example, but since you already added a field in the m2m table, I would look at this article: Installed with Demand Management - ServiceNow Wiki and start by looking at the "Create OnDemand Assessment" BR. It should loop through stakeholders so there will probably be a GlideRecord('dm_stakeholder_register') which you can change to GlideRecord('dmn_m2m_demand_stakeholder').

I can look at this tomorrow morning, but let me know if you managed to achieve some progress in the meantime.

Good luck,

Jorge

[jonkin]

Hello Jorge,

That worked! Thank you so much!! I found the part where it does look at dmn_m2m_demand_stakeholder but the query is dotwalking up to the dm_stakeholder_register...So I modified that and its working great!

Thank you again!