when I change the priority of my xyz table record to 1 then all other records which has a

[Abhishek Kathe]

when I change the priority of my xyz table record to 1 then all other records which has a priority 1 should change automatically to none.

[Abhishek Kathe]

Hello Maik, 
Hope you are doing well 
my ticket size is limited which may be 10 or max 20 so I just need this type of functionality.

[Sandeep Rajput]

@Maik Skoddow Hello Maik,

Thanks for reaching out.

The intent of sharing the post was to show the possibilities on how he can achieve the desired outcome. I never asked him to run that solution in production directly. One should always practice caution while running any scripts be it dev, QA or production.