Feature #62441

Backend search in IRRE tables

Added by Tobias Klepp about 5 years ago. Updated about 4 years ago.

Should have
FormEngine aka TCEforms
Target version:
Start date:
Due date:
% Done:


PHP Version:
Sprint Focus:


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.


#1 Updated by Georg Ringer about 5 years ago

hm this is really really not a simple task because there are many different ways how relations can be saved. however you can override the suggest mechanism instead of using a custom backend module.

#2 Updated by Riccardo De Contardi about 4 years ago

  • Category set to 978

Also available in: Atom PDF