Project

General

Profile

Actions

Bug #98993

closed

Flexform select with multiple fixed and DB values fails

Added by Bernhard Eckl over 1 year ago. Updated 6 months ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Backend User Interface
Target version:
-
Start date:
2022-11-03
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
10
PHP Version:
7.4
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

I have a flexform with a select and want to have two options (nothing and all) plus values from the database. If I select the second (fixed value) after saving the first value is selected again. Here is my code:

                    <settings.myfield>
                        <TCEforms>
                            <label>My label</label>
                            <config>
                                <type>select</type>
                                <renderType>selectSingle</renderType>
                                <items>
                                    <numIndex index="0">
                                        <numIndex index="0">---</numIndex>
                                        <numIndex index="1"></numIndex>
                                    </numIndex>
                                    <numIndex index="1">
                                        <numIndex index="0">Alle</numIndex>
                                        <numIndex index="1">all</numIndex>
                                    </numIndex>
                                </items>
                                <foreign_table>tablename</foreign_table>
                                <foreign_table_where>
                                ...
                                </foreign_table_where>
                            </config>
                        </TCEforms>
                    </settings.myfield>
Actions #1

Updated by Rico Drexler 9 months ago

This is probably not a bug. With foreign_table you can only store INT values, unless you set the value allowNonIdValues to true.

Look here:
https://docs.typo3.org/m/typo3/reference-tca/10.4/en-us/ColumnsConfig/Type/selectSingle.html#allownonidvalues

Actions #2

Updated by Christian Kuhn 6 months ago

  • Status changed from New to Closed

Thanks for the comment, Rico.

I did not actively test this, but it sounds as if you're correct with your assessment.

Since this issue did not gain much traction, I hope it's ok to close here for now.

Please re-open or create a new issue in case we missed something.

Actions

Also available in: Atom PDF