Priority value

superante

Versione osTicket v1.14.4 (5fc29c3)
Web Server Software Apache/2.4.37 (centos)
Versione MySQL 10.3.17
Versione PHP 7.0.33

Hi
what are the command on mysql for view and change the values in priority_desc?
Is it possible to delete "emergency" and "low"?
Thanks
Bye

ntozier

Priorities are listed on the ost_ticket_priority table. You would have to edit the table directly to do that.

As a side note since the levels are based off of the email RFC priorities altering this table could have unknown consequences for emailed tickets.

superante

Thank you
But I don't know how to edit the table ... I don't see the 4 values ...
Osticket (still empty) we only use it via the web and not via email so I think we can delete the 2 items?
Bye

ntozier

The information is not stored in the data structure/design. It is data in the table.

You need to edit the data in the table, not the table.

superante

ok i undestand, but how edit/delete them via ssh?

ntozier

SSH into server.
run the mysql command to log in
mysql -u <username> -p
and tell it what database to use.
use <dbname>

Then you would use the ALTER TABLE command to change what you want to change.
documentation:
https://dev.mysql.com/doc/refman/8.0/en/alter-table.html

superante

I used these commands for change priority desc:
To check

SELECT
     priority_id,
     priority,
     priority_desc
FROM
     ost_ticket_priority;

to modify

UPDATE
     ost_ticket_priority
SET
     priority_desc = 'Urgente'
WHERE
     priority_id = 3;

Thanks for the input.
But if I delete 2 items (Emergency and low) what problems are there?