Backend search in IRRE tables
I have a contact extension that saves the contacts in the data structure of an Outlook contact. That means, I have a person master record and then extra tables for addresses, phone numbers and email addresses. With IRRE I can save to a person any number of addresses, telephone numbers and email addresses. Now I would like to search for a city in the backend to list all the people with the city in their addresses. That is not possible, because the city field is not part of the persons master table. The IRRE tables are hidden with 'hideTable' => TRUE. Using the global search I could find the address, if I configure search fields. But this is useless, because then I just get the child record and not the parent master record.
I have no idea what I can do to search easily in the backend over all contact data and get only parent master records as results. Sure, I can program an backend extension for searching the contact tables but I hope, there is a better idea.
It would be nice, if I can configure in the TCA searchFields configuration something like tablename:fieldname to include additional fields from child records.