[TYPO3-english] Flexform : foreign_table_where is not working properly when we use REC_FIELD

[David Bruchmann]

Hi Jainish,

this is not working without FlexForms but with common definition in TCA too.
I just have the same problem where I want to limit of found data.
So your problem is related to the core but not to FlexForms.

David


Date: Fri, 03 Jun 2016 16:00:06 +0530
> From: Jainish Senjaliya <jainishsenjaliya at gmail.com>
>



> Hello All,
>
> Here i am going to show records from table depends upon category selection.
>
> Here i have used following code.
>
> <foreign_table_where> TABLE_NAME.category =
> ###REC_FIELD_settings.category### </foreign_table_where>
>
> But this is not working at all
>
> My flexform configuration are below
>
> <settings.category>
>         <TCEforms>
>                 <label>Category</label>
>                 <onChange>reload</onChange>
>                 <config>
>                         <type>select</type>
>                         <foreign_table>CATEGORY_TABLE_NAME</foreign_table>
>                         <size>1</size>
>                         <maxitems>1</maxitems>
>                         <minitems>1</minitems>
>                         <show_thumbs>1</show_thumbs>
>                 </config>
>         </TCEforms>
> </settings.category>
>
> <settings.grid>
>         <TCEforms>
>                 <label>Product</label>
>                 <config>
>                         <type>select</type>
>                         <foreign_table>PRODUCT_TABLE_NAME</foreign_table>
>                         <foreign_table_where> PRODUCT_TABLE_NAME.category
> = ###REC_FIELD_settings.category### </foreign_table_where>
>                         <size>5</size>
>                         <maxitems>100</maxitems>
>                         <minitems>4</minitems>
>                         <autoSizeMax>20</autoSizeMax>
>                         <show_thumbs>1</show_thumbs>
>                 </config>
>         </TCEforms>
> </settings.grid>
>
>