TYPO3 Core

Hi,
this is the situation:
I have a relation 1:n between 2 tables;
I use IRRE for inline editing of the child records;
in the child table I have a field of type 'select' that implements another relation with another big table;
when I edit the child records I want to filter the items of this field,
so I use the ###REC_FIELD_[fieldname]### marker

when I create a new child record with IRRE,
the preprocessing of the ###REC_FIELD_[fieldname]### marker returns an empty string
if the filed is numeric I got an sql error an the child record doesn't render in the form

TCA example:

"childField" => Array (
"config" => Array (
"type" => "select",
"foreign_table" => "anotherTable",
"foreign_table_where" => " AND anotherTable.anotherField=###REC_FIELD_filterField### ORDER BY anotherTable.uid",

SQL result:

AND anotherTable.anotherField= ORDER BY anotherTable.uid

I propose a patch to return 0 in case of a numeric field

Ciao,
Aldo Polli

(issue imported from #M6455)