Bug #73209
closedStory #69617: FormEngine bugs
PAGE_TSCONFIG_ID not working anymore in TYPO3 9.5.x
100%
Description
In TYPO3 7.6.1 when I set PAGE_TSCONFIG_ID like this:
TCEFORM { tt_content { pi_flexform { PAGE_TSCONFIG_ID = 2 } } } }
and try to use it in FlexForms like this:
<foreign_table_where>AND tx_myext_domain_model_table.pid = ###PAGE_TSCONFIG_ID###</foreign_table_where>
it doesn't work. No records are shown in the selectbox, but the exact same thing is working in TYPO3 6.2.x.
Updated by Felix Nagel almost 9 years ago
Seems I'm having the same issue in 7.6.2
Updated by Wouter Wolters almost 9 years ago
- Status changed from New to Needs Feedback
Please try, if possible, with the TYPO3_7-6 branch.
I found a related ticket that got fixed recently https://forge.typo3.org/issues/72510 in this branch.
Does this resolve your problem?
Updated by Raphael Zschorsch almost 9 years ago
Hello Wouter,
thanks for the quick reply. Unfortunately, the problem still occurs on the TYPO3_7-6 branch.... :(
Updated by Mirko Kaufmann almost 9 years ago
The patch provided in https://forge.typo3.org/issues/72510 does not resolve this issue.
I have the same problem in 7.6.3. I used it in several projects to seperate sys_categories via pid.
e.g.:
<foreign_table_where> AND (sys_category.sys_language_uid = 0 OR sys_category.l10n_parent = 0) AND sys_category.pid = ###PAGE_TSCONFIG_ID###</foreign_table_where>
Updated by Frederick d. Maus almost 9 years ago
it works when i set the constant in the page-TSconfig (edit the page), so not in the normal template!!
TCEFORM.tx_extensionname_domain_model_entry.field.PAGE_TSCONFIG_ID = 20
Updated by Jan Schröder almost 9 years ago
I have the same problem.
I use the TYPO3 version 7.6.5
I try to set the PAGE_TSCONFIG_ID in the flexform like this:
<settings.mod3_category> <TCEforms> <label>Kategorie</label> <!--<displayCond><![CDATA[FIELD:switchableControllerActions:=:Collector->category]]></displayCond>--> <config> <type>select</type> <renderType>selectSingle</renderType> <foreign_table>tx_extensionName_domain_model_pagecategory</foreign_table> <foreign_table_where>AND tx_extensionName_domain_model_pagecategory.pid=###PAGE_TSCONFIG_ID###</foreign_table_where> <minitems>1</minitems> <maxitems>1</maxitems> <multiple>0</multiple> <size>1</size> <itemListStyle>Width:250px</itemListStyle> </config> </TCEforms> </settings.mod3_category>
And i set the PAGE_TSCONFIG_ID in the PageTSConfig.
I tried different variants like this:
TCEFORM.tx_auwpagesmeta_domain_model_pagecategory.uid.PAGE_TSCONFIG_ID = 5
or this
TCEFORM.tx_auwpagesmeta_domain_model_pagecategory.pid.PAGE_TSCONFIG_ID = 5
or this
TCEFORM.tt_content.pi_flexform.PAGE_TSCONFIG_ID = 5
I have no idea who it works :-(
any suggestions?
@Frederick d. Maus d. Maus can you explain what is exactly your field?
TCEFORM.tx_extensionname_domain_model_entry.*field*.PAGE_TSCONFIG_ID = 20
Updated by Gerrit Code Review over 8 years ago
- Status changed from Needs Feedback to Under Review
Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/47924
Updated by Gerrit Code Review over 8 years ago
Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/47924
Updated by Christian Kuhn over 8 years ago
confirmed, this also affects PAGE_TSCONFIG_ID, PAGE_TSCONFIG_IDLIST and PAGE_TSCONFIG_STR
With 7.6 the "global" flex form setting did not work anymore:
TCEFORM.tt_content.pi_flexform.PAGE_TSCONFIG_ID = 42
Instead, a page TSConfig for a specific field should be done:
TCEFORM.tt_content.pi_flexform.theDataStructure.theSheet.settings\.categories.PAGE_TSCONFIG_ID = 42
Note the flex form field name is "settings.categories" but in page TS, dots in field names have to be escaped: settings\.categories.
The pending patch for 7.6 fixes the bug that the global "TCEFORM.tt_content.pi_flexform.PAGE_TSCONFIG_ID = 42" did not work anymore with a hacky workaround, so the complains this issue is about should be fixed in 7.6 with the next version if the patch gets merged. For master however, the "global" solution is now working, but deprecated. Use specific settings for single flex fields as outlined above, instead. Note this solution in master does currently NOT allow PAGE_TSCONFIG_ID, PAGE_TSCONFIG_IDLIST and PAGE_TSCONFIG_STR for flex form section container elements: There is currently no overall concept to set page TSConfig for single flex form section container elements at all.
Updated by Gerrit Code Review over 8 years ago
Patch set 1 for branch TYPO3_7-6 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/47943
Updated by Christian Kuhn over 8 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset e1882ba10bc7e4dc47379eda9753b8b9367a30e7.
Updated by Gerrit Code Review over 8 years ago
- Status changed from Resolved to Under Review
Patch set 2 for branch TYPO3_7-6 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/47943
Updated by Christian Kuhn over 8 years ago
- Status changed from Under Review to Resolved
Applied in changeset ae09f8752a2cd28821106e58bdaffe1b156111b5.
Updated by Raphael Zschorsch about 5 years ago
- Subject changed from PAGE_TSCONFIG_ID not working anymore in TYPO3 7.6.1 to PAGE_TSCONFIG_ID not working anymore in TYPO3 9.5.x
- TYPO3 Version changed from 7 to 9
- PHP Version changed from 5.5 to 7.2
Same thing now with TYPO3 9.5.x
Updated by Markus Dübbert over 4 years ago
- Assignee set to Benni Mack
It still does not in TYPO3 9.5.19
@Benni Mack: can you please reopen this ticket?
Updated by Benni Mack over 4 years ago
Markus Dübbert wrote:
It still does not in TYPO3 9.5.19
@Benni Mack: can you please reopen this ticket?
Hey Markus,
well, as there was a change related to this ticket merged, we need to re-open a new ticket and reference both tickets. Can you do that please?
Updated by Bastian Stargazer about 4 years ago
- TYPO3 Version changed from 9 to 10
Was this issue fixed? I experience the same in TYPO3 v10.4.9:
- With no further SQL-Where configuration, all categories (some roots with some children) are displayed for my record (OK)
- If I add 'foreign_table_where' => ' AND sys_category.parent = ###PAGE_TSCONFIG_ID###' to the TCA without configuring TCEFORM yet, only the Root-Categories are displayed for my record (also OK, because PAGE_TSCONFIG_ID is 0 by default as the documentation says)
- Now, if I add TCEFORM.my_table.categories.PAGE_TSCONFIG_ID = 1 to the Root-PageTS, I'd expect that only categories with parent=1 will showing up, but instead I see no categories at all.
EDIT:
Got it working now removing the custom SQL-Where from TCA and used the following TsConfig: TCEFORM.my_table.categories.config.treeConfig.rootUid = 1. But still I don't get where PAGE_TSCONFIG_ID is than for... or am I doing something wrong here?