Issue Feature Rejected

#70104QueryGenerator: Provide FIND_IN_SET option

Philipp Kerling 09/25/15, 10:42 updated 12/09/15, 16:42

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.

Reviews 1