is there a way to change the priority of a bunch of tickets at once? Without a SQL query. For example a company doesn't pay their bill and we want to set all open tickets from them to low priority for the time being.
I can't think of a way to do this with out running a SQL query.
Sorry I meant without running an outside SQL query. Like outside in phpmyadmin. Of course it would have to be SQL query, but on the OS ticket website
If the tickets have various other priorities (medium, high, critical) how would you reset them to their original state once they pay their bill ? you would need another field in the data or something that says original state.
I think it would be ideal if the system knew what the previous priority was, so that you could easily go back once they did pay their bill.
Create a second list with a name like Previous Priority. Make the list items identical.When you go to update the priority, set that to what it is currently prior to updating.You could write a script to run on cron that does this. It would also need to talk to your accounting package though to find out if they haven't paid their bill.
