[TYPO3-shop] How to use the "sql.where" statement in typoscript?

[Franz Holzinger]

Gunnar Jonsson a écrit :
> discountprice {
>   10.type = count
>   10.field = price  10.additive = 1
>   10.where =
>   10.prod.1 = 4.99
>   10.prod.100 = 2.49
>   10.prod.1050 = 2.39

> I also see that some are using "sql.where" in stead of just "where". Does it 
> not matter which one you choose?
> 
> I have also seen some using and refering to tt_products 2.7.0:
> sql.where = color = 'rot'
> 
> Does that mean that the "where" statement does not work until tt_products 
> 2.7.0 is released? 

Yes, you must use 2.7.0 or higher.
sql has been added.

pricecalc {
  10.type = count
  10.field = price
  10.sql.where =
  10.prod.1 = 4.99
  10.prod.2 = 8.99
  10.prod.5 = 19.99


- Franz