dongtang6718 2018-10-10 15:06
浏览 41

Typo3 8.7.x Flexform:从选定的记录存储页面获取所有sys_categories

I'm trying to get all sys_categories from the selected record storage pages, but I get only the sys_categories from the first entry at the record storage list.

<settings.categories>
    <TCEforms>
        <displayCond>FIELD:parentRec.pages:REQ:true</displayCond>
        <label>Categories</label>
        <config>
            <type>select</type>
            <renderType>selectTree</renderType>
            <autoSizeMax>15</autoSizeMax>
            <foreign_table>sys_category</foreign_table>
            <foreign_table_where> AND sys_category.sys_language_uid IN (-1, 0) AND sys_category.pid IN (SELECT pages FROM tt_content WHERE uid=###THIS_UID###) ORDER BY sys_category.sorting ASC</foreign_table_where>
            <maxitems>9999</maxitems>
            <size>10</size>
            <treeConfig>
                <appearance>
                    <expandAll>1</expandAll>
                    <showHeader>1</showHeader>
                </appearance>
                <parentField>parent</parentField>
            </treeConfig>
        </config>
    </TCEforms>
</settings.categories>

It's working, if I write the ID static:

...AND sys_category.pid IN (430,459)...

I found out that the subqueries result looks like this

...AND sys_category.pid IN ('430,459')...

but I need it like the static example. It's also not working, if I try the following

...AND sys_category.pid IN (###REC_FIELD_pages###)...
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 虚幻5 UE美术毛发渲染
    • ¥15 CVRP 图论 物流运输优化
    • ¥15 Tableau online 嵌入ppt失败
    • ¥100 支付宝网页转账系统不识别账号
    • ¥15 基于单片机的靶位控制系统
    • ¥15 真我手机蓝牙传输进度消息被关闭了,怎么打开?(关键词-消息通知)
    • ¥15 下图接收小电路,谁知道原理
    • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
    • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
    • ¥15 手机接入宽带网线,如何释放宽带全部速度