Gsyfuy

How to visualize the Riemann-Roch theorem from complex analysis or geometric topology considerations?

Does Skippy chunky peanut butter contain trans fat?

Why did the villain in the first Men in Black movie care about Earth's Cockroaches?

Can I announce prefix 161.117.25.0/24 even though I don't have all of /24 IPs?

Do "fields" always combine by addition?

Potential client has a problematic employee I can't work with

Square Root Distance from Integers

What would you call a real market that is close to perfect competition?

Identify KNO3 and KH2PO4 at home

Why is it that Bernie Sanders is always called a "socialist"?

Why are all my replica super soldiers young adults or old teenagers?

How do I append a character to the end of every line in an excel cell?

Why does magnet wire need to be insulated?

I have trouble understanding this fallacy: "If A, then B. Therefore if not-B, then not-A."

What is the difference between rolling more dice versus fewer dice?

After checking in online, how do I know whether I need to go show my passport at airport check-in?

Non-Cancer terminal illness that can affect young (age 10-13) girls?

Avoid page break between paragraphs

Am I a Rude Number?

Is a new boolean field better than null reference when a value can be meaningfully absent?

Building an exterior wall within an exterior wall for insulation

Can the following process be justified?

How can I play a serial killer in a party of good PCs?

How should I handle players who ignore the session zero agreement?

magento 1.9 order grid collection and order count wrong showing

Adding custom sales order attribute to order gridMagento filtering showing wrong counthow can i add shipping carrier column in admin page1.9 - Add custom column to Sales Order Create Gridshow all order count of a customer in order gridmagento 1.9 custom order grid conditionPagination count issue in custom varient collectionLeft join order grid collection using observer method. Magento 1.9Magento - Add customer attribute to order gridPayment Method Sales/Order grid - Magento 1.9

0

i have use default order grid collection but

when Adding a skus to the order grid.

my order count showing wrong

   protected function _getCollectionClass()

    {

        return 'sales/order_grid_collection'; // Default order grid collection

    }



    protected function _prepareCollection()

    {

        $collection = Mage::getResourceModel($this->_getCollectionClass());

        $collection->join('sales/order_item','`sales/order_item`.order_id=`main_table`.entity_id',array('skus' => new Zend_Db_Expr('group_concat(`sales/order_item`.sku SEPARATOR ", ")'),));

        $collection->getSelect()->group('main_table.entity_id');

        $this->setCollection($collection);

        return parent::_prepareCollection();

    }

above i have join query added in collection

magento-1.9 order-grid

share|improve this question

edited 5 mins ago

Rakesh Donga

asked 14 mins ago

Rakesh DongaRakesh Donga

1,273316

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  What is showing wrong? I don't see
  
  – Black
  8 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  if i remove join query then order count show correct but when i run this join query order count showing wrong
  
  – Rakesh Donga
  7 mins ago
  

  
  
  
  

add a comment | 

0

i have use default order grid collection but

when Adding a skus to the order grid.

my order count showing wrong

   protected function _getCollectionClass()

    {

        return 'sales/order_grid_collection'; // Default order grid collection

    }



    protected function _prepareCollection()

    {

        $collection = Mage::getResourceModel($this->_getCollectionClass());

        $collection->join('sales/order_item','`sales/order_item`.order_id=`main_table`.entity_id',array('skus' => new Zend_Db_Expr('group_concat(`sales/order_item`.sku SEPARATOR ", ")'),));

        $collection->getSelect()->group('main_table.entity_id');

        $this->setCollection($collection);

        return parent::_prepareCollection();

    }

above i have join query added in collection

magento-1.9 order-grid

share|improve this question

edited 5 mins ago

Rakesh Donga

asked 14 mins ago

Rakesh DongaRakesh Donga

1,273316

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  What is showing wrong? I don't see
  
  – Black
  8 mins ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  if i remove join query then order count show correct but when i run this join query order count showing wrong
  
  – Rakesh Donga
  7 mins ago
  

  
  
  
  

add a comment | 

i have use default order grid collection but

when Adding a skus to the order grid.

my order count showing wrong

   protected function _getCollectionClass()

    {

        return 'sales/order_grid_collection'; // Default order grid collection

    }



    protected function _prepareCollection()

    {

        $collection = Mage::getResourceModel($this->_getCollectionClass());

        $collection->join('sales/order_item','`sales/order_item`.order_id=`main_table`.entity_id',array('skus' => new Zend_Db_Expr('group_concat(`sales/order_item`.sku SEPARATOR ", ")'),));

        $collection->getSelect()->group('main_table.entity_id');

        $this->setCollection($collection);

        return parent::_prepareCollection();

    }

above i have join query added in collection

magento-1.9 order-grid

share|improve this question

edited 5 mins ago

Rakesh Donga

asked 14 mins ago

Rakesh DongaRakesh Donga

1,273316

   protected function _getCollectionClass()

    {

        return 'sales/order_grid_collection'; // Default order grid collection

    }



    protected function _prepareCollection()

    {

        $collection = Mage::getResourceModel($this->_getCollectionClass());

        $collection->join('sales/order_item','`sales/order_item`.order_id=`main_table`.entity_id',array('skus' => new Zend_Db_Expr('group_concat(`sales/order_item`.sku SEPARATOR ", ")'),));

        $collection->getSelect()->group('main_table.entity_id');

        $this->setCollection($collection);

        return parent::_prepareCollection();

    }

share|improve this question

edited 5 mins ago

Rakesh Donga

asked 14 mins ago

Rakesh DongaRakesh Donga

1,273316

share|improve this question

edited 5 mins ago

Rakesh Donga

asked 14 mins ago

Rakesh DongaRakesh Donga

1,273316

asked 14 mins ago

Rakesh DongaRakesh Donga

1,273316

asked 14 mins ago

Rakesh DongaRakesh Donga

1,273316