Feature #32149: add dynamic record collections - TYPO3 Core - TYPO3 Forge

Actions

Copy link

Feature #32149

closed

add dynamic record collections

Added by Steffen Ritter over 12 years ago. Updated about 7 years ago.

Status:

Closed

Priority:

Must have

Assignee:

Steffen Ritter

Category:

Backend API

Target version:

9.0

Start date:

2011-11-29

Due date:

% Done:

80%

Estimated time:

PHP Version:

5.3

Tags:

Complexity:

hard

Sprint Focus:

Description

you might want not to select tca-records just strictly on selection, but on criteria dynamically.

Add dynamic record collections based on a filter system.

Therefore
- define a filter-language
- create a filter-service which can filter arrays upon this filter-language and create SQL Where statements for this
- create a Dynamic-Collection using the filter-service for creating a where clause for the records to be filled dynamically

Actions

Copy link

Updated by Steffen Ritter over 12 years ago

Category set to Backend API
Assignee set to Steffen Ritter
% Done changed from 0 to 80
PHP Version set to 5.3
Complexity set to hard

Actions

Copy link

Updated by Oliver Hader over 12 years ago

Target version changed from 4.7.0-alpha2 to 4.7.0-alpha3

Actions

Copy link

Updated by Steffen Ritter about 12 years ago

Target version changed from 4.7.0-alpha3 to 4.7.0-beta1

Actions

Copy link

Updated by Steffen Ritter about 12 years ago

Status changed from Accepted to On Hold

Actions

Copy link

Updated by Steffen Ritter about 12 years ago

Target version deleted (~~4.7.0-beta1~~)

Actions

Copy link

Updated by Felix Kopp about 12 years ago

I have been working on functionality to do such queries for an OLAP / drill-down extension for List Module.
Is there already prototype code in some way? I would like to join forces.

Actions

Copy link

Updated by Steffen Ritter about 12 years ago

Felix Kopp wrote:

I have been working on functionality to do such queries for an OLAP / drill-down extension for List Module.
Is there already prototype code in some way? I would like to join forces.

There already has been working code - i fact it has been finished and would have needed some polishing. Due to the dropping of ExtJS4 we do not have any interface anymore to define such filters...
But: we have a service creating sql querys for such json filter strings with 5 build-in filters taking care of the searchfield settings in tca

In addition there is an interface defined, so that everyone could extend the system by own filters.
The dynamic record collection so just retrieved a where clause from the filter service.

filters have been:
fulltext,
field,
relation
collection (so recursive usage and re-usage is possible)

as well as supported operator AND and OR

Actions

Copy link