[TYPO3-dev] Re: [Typo3-directmail] Missing feature: Special Query

[Peter Russ]

--- Original Nachricht ---
Absender:   Peter Russ
Datum:       26.03.2009 22:02:
> I was totally suprised seeing the capabilities to build the query.
> Good concept!
> 
> But I think one important feature is missing (at least in the TER 
> version 2.6.2):
> 
> If you select a group as a criteria it doesn't respect that this field 
> is a MM-table realtion. Instead it equals numbers of relations instead 
> of groups. Seams to me that none tried that before.
> 
> Exp: Groups
> Mailorder 1
> Party 2
> Common 3
> 
> Generated query:
> SELECT uid,pid,deleted FROM tt_address WHERE ( hidden != '1' AND 
> tx_fdfxaddresschecker_check_hidden = '0' AND 
> tx_fdfxaddresschecker_check_errorcode = '-2' AND addressgroup = '1') AND 
> tt_address.deleted=0
> 
> Due to the fact that addressgroup is MM related with the addressgroup we 
> have the count of realtions in this field. So performing above query 
> will not check for the right group but for the relations :-(
> 
> Any update in pipeline.
> 
> Peter.

As this this core related (t3lib_queryGenerator) I filed a bug report 
http://bugs.typo3.org/view.php?id=10826

Regs. Peter.

-- 
Fiat lux! Docendo discimus.
_____________________________
uon GbR

http://www.uon.li
http://www.xing.com/profile/Peter_Russ