Magento collection expression

Question

How to use expressions in a collection.

More specific, I want to SELECT CAST(qty_shipped AS UNSIGNED).

I have tried something like this: addExpressionFieldToSelect('qty_shipped','CAST(qty_shipped AS UNSIGNED)',null) , but it appends the table name for some reason.

Thanks.

FYI, method addExpressionFieldToSelect() won't work with flat models. — MagePsycho, Mar 31 '12 at 20:07

MagePsycho · Accepted Answer · 2012-04-01T07:08:58.897

10

Try as:

$collection->getSelect()->columns(array('qty_shipped' => new Zend_Db_Expr ('CAST(qty_shipped AS UNSIGNED)')));

Where $collection = Collection Object

Let me know if that works for you.

edited Apr 01 '12 at 07:08

answered Mar 31 '12 at 20:05

MagePsycho

1,944
2
29
60

Yep, it worked, there was just a typo. Should be "Zend_Db_Expr" Thanks man. – user635818 Mar 31 '12 at 22:03
Fixed: Zend_Db_Exp -> Zend_Db_Expr. Thanks – MagePsycho Apr 01 '12 at 07:10

Magento collection expression

1 Answers1