Magento News

Magento Inherit EAV collection

I have created a custom module and tables for that.

1) How can I use EAV Collection functions on my custom table collection – addExpressionAttributeToSelect, I have to use Count, SUM functions .

for example say I have tableA and tableB
table A has some SKU data, tableB has sales data for SKUs(Multilines for a SKU)

`$collection = Mage::getModel('Module/tableA')->getCollection();`,

Now I need one more column(sum of total sale) in this collection from tableB IF sold date is between two dates.

2) How to write inner queries While preparing collection.

Possibly Related Posts: