How to Create Breakdown Mappings for Child Class Table when Breakdown Fact Table is a Base Table

Michael Zglesze · ‎02-27-2017

Hello Community!

I hope I used the correct terminology in the Subject Line... 🙂

Here's what I'm hoping to accomplish: I have a breakdown created for a custom field, and that field is in the change_request table. The Automated Indicator is built on the task_ci table because the process that we use at my company dictates that I pull information on Change Requests based on the CIs Affected. Unfortunately, when I go to map the Breakdown, I can't get to the Extended Tables to select that field.

It looks like my solutions are the following three things:

1) Create a Database View. This isn't an option as I don't have access to do that, and our admins don't want to take a performance hit on the system.

2) Add a reference field on the form so that I can traverse it. This isn't an option as, again, I don't have access to do that, and our admins don't want to take a performance hit on the system.

3) Use the scripting capability. This is totally doable, but I'm unsure how to return the information that ServceNow needs.

Is there I resource that I can refer to regarding Performance Analytics scripting, specifically?

Has anyone had the same issue and can maybe share some example code to do this?

Thanks, Community! 🙂

sowmya123 · ‎02-28-2017

Creating breakdown mapping to extended fields can be done thru scripts

below is a sample script where the "task" field is passed onto the function and it retrieves the incident category from the incident table

you can use this script to then attach to the breakdown mapping

var getIncCat = function (inc)

{

gs.log("Getting info for inc: " + inc);

var gr = new GlideRecord('incident');

gr.get(inc);

return gr.u_incident_category;

};

getIncCat(current.u_task);

View solution in original post

Arnoud Kooi · ‎02-28-2017

Maybe you can try this solution Is there a way to use extended fields in interactive filters?

If not what is the exact breakdown facts table, your working on?