How to show manager name parallel to assignment group breakdown source filter name
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-06-2023 09:37 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-06-2023 10:40 PM
In the Breakdown Source, it showcases the Display field of the record. For instance, if your breakdown source refers to the Group [sys_user_group], it will display the Name field.
You won't be able to add anything to it unless you change either the Display field of the table or the data of the field.
An alternate method involves setting up a Manual Breakdown Source to serve as an intermediary. This source will contain a value combining the Group Name and Group Manager. This approach will provide the Source Data needed for your Breakdown.
Cheers,
Tai Vu
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-06-2023 11:25 PM
Hi @Tai Vu ,
Can you please briefly explain how to achieve the second alternate method?
Thanks,
Nisha Kumari
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-07-2023 12:36 AM - edited ‎11-07-2023 12:38 AM
Sure. There you go.
1. Create a Breakdown [pa_breakdowns]. Named Group - Manager
2. Define something to automate Manual Breakdowns [pa_manual_breakdowns] generation.
=> It can be a schedule job or a business rule, which will generate data into the Manual Breakdown table. Assume naming convention: (Group Name + " - " + Group Manager)
3. Create a Breakdown Source.
Table: Manual Breakdowns [pa_manual_breakdowns]
Conditions: Breakdown is Group - Manager
4. Create an Automate Breakdown using the Breakdown Source above.
5. Create a Scripting Breakdown Mapping (Check the Scripted flag)
6. Create a PA Scripts [pa_scripts] to handle the mapping.
What happens in the script is that you will do a query into the Manual Breakdown and return the sys_id of the record found.
Sample script below. (Incident Assignment Group)
var group = current.assignment_group.name + " - " + current.assignment_group.manager.getDisplayValue();
process(group);
function process(value){
var grManualBreakdown = new GlideRecord('pa_manual_breakdowns');
grManualBreakdown.addQuery('breakdown', '<breakdown_sys_id>'); //the sys_id of breakdown Group - Manager
grManualBreakdown.addQuery('value', value);
grManualBreakdown.query();
if(grManualBreakdown.next()){
return grManualBreakdown.getUniqueValue();
}
return '';
}
Remember to include the relevant fields into the PA Script.
 
7. Now you can add the Automate Breakdown to your Indicators.
Cheers,
Tai Vu
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-08-2023 12:20 AM