Get the first assignment group

[richardlore]

Hi Community,

I have a requirement to retrieve the first assignment group. Does anyone have any idea how to achieve this for reporting purposes?

[Dr Atul G- LNG]

Metrics can be helpful, but the data will be stored against multiple groups. As soon as any group details change, it may impact the results.

There is no OOTB way to achieve this. You can create a custom field, populate the first group value in that field, and then use the OOTB field. However, this approach will create technical debt.

[Shivambitanwar1]

Hi @richardlore ,

What would you want the report to display? is it to see what groups get an incident assigned to them first?`
A good place to start is - what decision will this report help in making and then figure out how to visualise it.

//Shivambi

[Ankur Bawiskar]

@richardlore 

you will require a custom reference field which holds Group on that table

you can use before insert/update on that table and then populate it

BR Condition: current.u_first_group == ''

Script:

(function executeRule(current, previous /*null when async*/) {

	// Add your code here
	current.u_first_group = current.assignment_group; // give your relevant field names

})(current, previous);

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Suryansh Verma]

@richardlore 

As suggested by other members in this thread also:

Create a reference field such as u_first_assignment_group pointing to sys_user_group. Populate it using a Before Insert/Update Business Rule only when the custom field is empty and the current Assignment Group is not empty. This captures the first non-empty assignment group and prevents later reassignment from overwriting it. The custom field can then be used directly for reporting. For historical records, backfill from sys_audit where audit history is available.