[TYPO3-dev] TYPO3 6.2 LTS: make IRRE records searchable

[Tobias Klepp]

Hello TYPO3 developers,
 
I have a problem for which I can not find anything in the official TYPO3 documentation and generally in Google. Maybe you can help me.

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.

Greetings,
Tobias

Tobias Klepp B.A.
Designer and Web Developer

STIMME DER HOFFNUNG Adventist Media Center

Sandwiesenstr. 35
D - 64665 Alsbach-Haehnlein

Tel: +49 (0) 62 57 - 5 06 53-17
Fax: +49 (0) 62 57 - 5 06 53-70
E-Mail: tobias.klepp at stimme-der-hoffnung.de

STIMME DER HOFFNUNG e.V.
VR 1293, Amtsgericht Darmstadt
Steuer-Nr. 007 250 80653
Ust-ID: DE111671780

www.bibelstudien-institut.de
www.bibelinfo.de
www.hope-channel.de
www.ichwillleben.eu
www.stimme-der-hoffnung.de