Project

General

Profile

Actions
Copy link

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
Assignee:
Philipp Kerling
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
Copy link

Also available in: Atom PDF