Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now

SQL Query

Hello, does someone know the tables/columns that need to be queried so that I can bulk close tickets that have no already been closed? e.g. Select * from tickets where status != "Closed" then I will use an update statement to update the ticket. Thanks!

Comments

  • The table is [your table prefix]tickets. So if you ran with the defaults ost_ticket
Sign In or Register to comment.