Project

General

Profile

Actions

Feature #70104

closed

QueryGenerator: Provide FIND_IN_SET option

Added by Philipp Kerling about 9 years ago. Updated almost 9 years ago.

Status:
Rejected
Priority:
Must have
Category:
Backend User Interface
Target version:
-
Start date:
2015-09-25
Due date:
% Done:

0%

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

Description

It would be tremendously helpful if the QueryGenerator provided an option use the MySQL FIND_IN_SET() function on fields.

Use case: direct_mail uses the QueryGenerator to let the user build recipient lists. In order to be able to create a recipient list that sends newsletters to all members of a specific frontend user group (for example the one with uid 12), the query must contain FIND_IN_SET(12, usergroup). It is not possible to model this query with the possibilities the QueryGenerator offers at the moment.

Actions #1

Updated by Gerrit Code Review about 9 years ago

  • Status changed from New to Under Review

Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/43563

Actions #2

Updated by Gerrit Code Review about 9 years ago

Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/43563

Actions #3

Updated by Gerrit Code Review about 9 years ago

Patch set 3 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/43563

Actions #4

Updated by Gerrit Code Review about 9 years ago

Patch set 4 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/43563

Actions #5

Updated by Markus Sommer about 9 years ago

  • Assignee set to Philipp Kerling
Actions #6

Updated by Philipp Kerling about 9 years ago

I see that you've assigned the issue to me, is there something I still have to do?

Actions #7

Updated by Georg Ringer almost 9 years ago

  • Status changed from Under Review to Rejected

even though this feature might be really helpful for you (and others), it won't make it into the core. TYPO3 tries to be less dependant on mysql and this is one of the last relicts which needs to be removed with CMS8.

therefore this feature is rejected. feel free to add it via extension using xlcass

Actions

Also available in: Atom PDF