t3lib_queryGenerator not respecting MM-relation when creating query
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.
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)
#2 Updated by Mark Boland about 6 years ago
Alexander Opitz wrote:
The issue is very old, does this issue exists in newer versions of TYPO3 CMS (4.5 or 6.1)?
I wrote a simple patch that adds the needed comparison '74' for tt_address_group_mm table to the instance of the QueryGenerator class. You can then select the new 'Address Group' relation from the Special Group for the field 'Group' of 'Address'.
This patch was inspired by the comment Georg Ringer added to issue #25899.
A far better solution would be to let QueryGenerator use MM relations when found in TCA.