Project

General

Profile

Actions

Feature #62441

closed

Backend search in IRRE tables

Added by Tobias Klepp over 9 years ago. Updated about 4 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
FormEngine aka TCEforms
Target version:
-
Start date:
2014-10-24
Due date:
% Done:

0%

Estimated time:
PHP Version:
Tags:
Complexity:
Sprint Focus:

Description

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.

Actions #1

Updated by Georg Ringer over 9 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.

Actions #2

Updated by Riccardo De Contardi over 8 years ago

  • Category set to 978
Actions #3

Updated by Susanne Moog about 4 years ago

  • Status changed from New to Closed

Due to low demand / low priority I'm going to close this issue now. If anyone takes time to implement it, simply open a new issue please. Thanks.

Actions

Also available in: Atom PDF