[TYPO3-shop] Search for translated products

[Franz Holzinger]

Marcus Schwemer a écrit :
> Hallo Franz,
> 
> Franz Holzinger schrieb:
> 
>> This has already been implemented. I have rechecked it with the most
>> current tt_products-2.7.1.13 from today.
> 
> Me too ... ;-)
> 
> Here is the where statement I found in
> "view/class.tx_ttproducts_list_view.php" in line 558:
> 
> FROM:
> tt_products products,tt_products_language productslang
> 
> WHERE:
> products.pid IN (31,32,33,34,35,36,37,38)
> AND 1=1
> AND(products.title LIKE '%birdman%' OR products.subtitle LIKE
> '%birdman%' OR products.note LIKE '%birdman%')
> AND productslang.sys_language_uid=7
> AND products.deleted=0
> AND products.hidden=0
> AND (products.starttime<=1248857052)
> AND (products.endtime=0 OR products.endtime>1248857052)
> AND products.fe_group IN (' ',0,-1)
> 
> "birdman" is my english searchterm. This can only be found in the table
> "productslang", but there is no reference in the where statement to it.
> If I search for "vogelmann" (the german product title), I get the
> translated results ...
> 
> Mit freundlichen Grüßen / Best regards,
> Marcus Schwemer
> 

The new Table Library extension 0.1.29 fixes this.

- Franz