Filter Tickets (views) based on related data

Filter Tickets (views) based on related data

Hello,

how can I create a view that retrieves the tickets based on related data?

For example, I have a ticket that is linked to a contact person, who in turn is linked to a company. In the company record, some relevant information is stored, such as certain identifiers. Now I want to create a view that lists all tickets of all companies that have the specific indicators. I can NOT simply filter the companies directly or specify them in the filter criteria, as the data changes and there would also be far too many companies.

Regards,
Sven