Searching by Company for Deleted Companies?

Question

How can you search for tickets by company for a company that has been deleted?

The system is still aware of deleted companies as they still exist in the database and are just flagged as "deleted" so it doesn't seem unreasonable to be able to search for tickets by companies that have been deleted.

Please let me know if/how this is possible, thanks!

fluffy_midnight · Accepted Answer

Hi byrona​,

The deletion option within the help desk is a soft delete, in this scenario this means you cannot locate the company you have deleted without going into the back-end database.

If you do this then you should find a company table (or something similar), locate the corresponding company name and find the ID referenced in the table. With this ID you can then query the tickets table and find all the tickets by that ID.

They may have changed this in the latest versions whereby you can skip getting the ID and just locate the company name, however I doubt this has happened.

-Midnight