Archive for January 2018

Where Magento keeps configuration data

Posted on January 29, 2018, 3:19 pm, by admin, under Magento 1.x, Tips.

SELECT * FROM magento01.core_config_data WHERE path LIKE ‘modulename%’;

66 Comments | Read the rest of this entry »

Magento default settings

Posted on January 26, 2018, 11:02 am, by admin, under Magento 1.x, Tips.

In config.xml <?xml version="1.0"?> <config> <default> <modulename> <parametergroup> <param>value</param> </parametergroup> </modulename> </default> </config>

111 Comments | Read the rest of this entry »

Magento collection add join and filter

Posted on January 9, 2018, 2:28 pm, by admin, under Magento 1.x, Tips.

$tableDataCollection = Mage::getResourceModel(’modulename/tablename_collection’)->setPageSize(50);   $tableDataCollection->getSelect() ->join(array(’alias’ => Mage::getSingleton(’core/resource’)->getTableName(’modulename/tablename’)), ‘main_table.id=alias.id’, ‘*’) ->where(’alias.condition = ?’, true);

595 Comments | Read the rest of this entry »

Get table name

Posted on January 9, 2018, 10:43 am, by admin, under Magento 1.x, Tips.

Mage::getSingleton(’core/resource’)->getTableName(’tablename’)

225 Comments | Read the rest of this entry »