Hello @Abhishek Kathe
If its a Incident table then it will be depending on urgency and impact but if its different table lets say custom one and in there as well if the priority is depending on urgency and impact then you can do it there as well but you need to see the dependencies first.
Please refer the script below and make the changes as per your requirement.
After Update Business Rule:
(function executeRule(current, previous) {
// Check if priority is changed to 1
if (current.priority == 1 && current.priority != previous.priority) {
// Update other records with priority 1 to 'none'
var gr = new GlideRecord('xyz_table');
gr.addQuery('priority', 1);
gr.addQuery('sys_id', '!=', current.sys_id); // Exclude the current record
gr.query();
while (gr.next()) {
gr.priority = 'none';
gr.update();
}
}
})(current, previous);
Let me know your views on this and Mark ✅Correct if this solves your query and also mark 👍Helpful if you find my response worthy based on the impact.
Thanks,
Aniket
