Coding

Magento: add new value in select, sum, multiplication, divide - addExpressionFieldToSelect

So for example, this is possible with addExpressionFieldToSelect(), but not with addFieldToSelect():
 
$collection->addExpressionFieldToSelect(
    'name_in_upper_case',
    new Zend_Db_Expr('UPPER(name)'),
    []
);
and results in an SQL query with
 
SELECT UPPER(name) as name_in_upper_case FROM ...
The placeholders for fieldnames are just syntactic sugar on top.

0 Bình luận

Trở về
  • HTML5 Canvas
  • HTML5 Canvas

     The <canvas> element is used to draw graphics, on the fly, on a web page. Draw a red rectangle, a gradient rectangle,...