Project

General

Profile

Actions
Copy link

Bug #20264

closed

t3lib_queryGenerator not respecting MM-relation when creating query

Added by Peter Russ over 15 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
Candidate for Major Version
Start date:
2009-04-02
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.2
PHP Version:
5.1
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

Description

At direct mail special query using t3lib_queryGenerator to build the query t3lib_queryGenerator doesn't respect MM-relation when bulding the query.

Create several address groups e.g.
Mailorder, Party, Common

In direct mail create a recipient list using special query and do a select on one of the addressgroups
In the editor everything look fine as you get the names of the groups correctly. But the compile query is wrong as it doesn't reflect the join.
Example:
Party has the uid 2 in the adressgroup.
The compiled query:
SELECT uid,pid,deleted FROM tt_address WHERE addressgroup = '2' AND tt_address.deleted=0

But as addressgroup is a MM-relation the value of the field is just the count of realtions.
So performing that query will only return only address with two addressgroups added and NOT with addressgroup=2

(issue imported from #M10826)

Files

tt_address_groups.patch (808 Bytes) tt_address_groups.patch Patch for direct_mail <-> tt_address_group_mm Mark Boland, 2013-05-28 17:12
Actions
Copy link

Also available in: Atom PDF