[Typo3-dev] gremlin here? ###REC_FIELD_ Problem in ext_tables.php

["Rafael Schär [beYou media]"]

Hi folx

built SQL not working properly. (only when ###REC_FIELD is used on a 
select field, with multiple choice.)

Is this a feature non-documented or a bug/ gremlin, can this behaviour 
be changed in TSCONFIG?

I habe serious problems here ;-)
I hope anyone can help me out here..
Thank you very much in advance for a short feedback.


Here is the case, a bit clearer (I hope so)


this ext_tables.php configuration doesn't work, no Idea why,...

It should work like this.
I choose values from a multiple select (tx_bumindexer_keyword_language), 
and the second field (tx_bumindexer_keywords) customizes the list of 
given keywords depending on what is selected in the select 
(tx_bumindexer_keyword_language)


$tempColumns = Array (

	"tx_bumindexer_keyword_language" => Array (		
		"exclude" => 1,		
		"label" =>
"LLL:EXT:bumindexer/locallang_db.php:tt_news.tx_bumindexer_keyword_language"
,		
		"config" => Array (
			"type" => "select",
			
			"items" => Array (
	
Array("LLL:EXT:bumindexer/locallang_db.php:tt_news.tx_bumindexer_keyword_lan
guage.I.0", "99"),
	
Array("LLL:EXT:bumindexer/locallang_db.php:tt_news.tx_bumindexer_keyword_lan
guage.I.1", "0"),
	
Array("LLL:EXT:bumindexer/locallang_db.php:tt_news.tx_bumindexer_keyword_lan
guage.I.2", "1"),
	
Array("LLL:EXT:bumindexer/locallang_db.php:tt_news.tx_bumindexer_keyword_lan
guage.I.3", "2"),
	
Array("LLL:EXT:bumindexer/locallang_db.php:tt_news.tx_bumindexer_keyword_lan
guage.I.4", "3"),
	
Array("LLL:EXT:bumindexer/locallang_db.php:tt_news.tx_bumindexer_keyword_lan
guage.I.5", "4"),
			),
			"size" => 6,	##
WOP:[fields][2][fields][2][conf_relations_selsize]
			"maxitems" => 6,	
		)
	),


	"tx_bumindexer_keywords" => Array (		
		"exclude" => 1,		
		"label" =>
"LLL:EXT:bumindexer/locallang_db.php:tt_news.tx_bumindexer_keywords",

		"config" => Array (
			"type" => "select",	
			"foreign_table" => "tx_bumindexer_keywords",	
			"foreign_table_where" => "ORDER BY
tx_bumindexer_keywords.sys_language_uid,tx_bumindexer_keywords.name",
			"foreign_table_where" => "AND
tx_bumindexer_keywords.sys_language_uid IN
(###REC_FIELD_tx_bumindexer_keyword_language###) ORDER BY 
tx_bumindexer_keywords.name",	
			"size" => 50,	
			"minitems" => 0,
			"maxitems" => 100,	
			"MM" => "tt_news_tx_bumindexer_keywords_mm",
		)
	),
);


-----------------------------------------------------------------------
so... but... ###REC_FIELD_tx_bumindexer_keyword_language### doesn't work
i don't get the proper values form the table field
"tx_bumindexer_keyword_language" but I recieve something like this in 
the query for a value

1|LLL:EXT:bumindexer/locallang_db.php:tt_news.tx_bumindexer_keyword_lan
guage.I.2

this looks like this for the built query:

AND
tx_bumindexer_keywords.sys_language_uid IN
(1|LLL:EXT:bumindexer/locallang_db.php:tt_news.tx_bumindexer_keyword_lan
guage.I.2, 
2|LLL:EXT:bumindexer/locallang_db.php:tt_news.tx_bumindexer_keyword_lan
guage.I.3) ORDER BY tx_bumindexer_keywords.name

instead of

AND
tx_bumindexer_keywords.sys_language_uid IN
(1,2) ORDER BY tx_bumindexer_keywords.name