Ticket Filter rule on Ticket status change

gopalchand

Hi Team,

Currently, there is filter available for Ticket Status. Is this possible to add this option in Ticket Filter.

The requirement is whenever the ticket status change from status A, we want to add some action change the status A to B and then send email.

Kindly assist or add this option in future development if not possible in current version.

Thanks, Gopal Chand

KevinTheJedi

gopalchand

There is no way to do that at this time as Ticket Filters only apply on Ticket creation. If a Ticket has already been created Ticket Filters will not be applied.

Cheers.

gopalchand

Hi KevinTheJedi

Okay, Noted with thanks.

If possible can you answer my below query in this thread.

in which database table tickets Description and Comments are getting stored and link column.

KevinTheJedi

gopalchand

Can you provide further details? What Description and Comments fields specifically?

Cheers.

gopalchand

Hi KevinTheJedi

Please find the screenshot, might help you to understand:
Ticket Description:

Ticket Comments:

KevinTheJedi

gopalchand _thread_entry

gopalchand

in this table I can see body that is thread and which column should I use to join with the ticket.
And what about the comment section - which table should I use?
KevinTheJedi

KevinTheJedi

gopalchand https://docs.osticket.com/en/latest/Developer%20Documentation/Database%20ERDs.html