Bumped by Community user

occurred Feb 25, 2018 at 3:33

Bumped by Community user

occurred Jan 25, 2018 at 3:23

Bumped by Community user

occurred Dec 25, 2017 at 13:47

Bumped by Community user

occurred Nov 23, 2017 at 18:14

Bumped by Community user

occurred Oct 19, 2017 at 3:52

Bumped by Community user

occurred Sep 18, 2017 at 21:06

Bumped by Community user

occurred Aug 19, 2017 at 2:43

Bumped by Community user

occurred Jul 13, 2017 at 22:08

Bumped by Community user

occurred Jun 12, 2017 at 5:52

Bumped by Community user

occurred May 8, 2017 at 8:20

Bumped by Community user

occurred Apr 6, 2017 at 18:16

Bumped by Community user

occurred Mar 5, 2017 at 11:32

Bumped by Community user

occurred Jan 30, 2017 at 21:12

Bumped by Community user

occurred Dec 27, 2016 at 23:47

Bumped by Community user

occurred Nov 18, 2016 at 21:55

Bumped by Community user

occurred Oct 18, 2016 at 23:08

Bumped by Community user

occurred Sep 12, 2016 at 21:23

improves formatting

Source Link

edit approved Aug 13, 2016 at 18:52

Siarhey Uchukhlebau

16.2k
11
55
88

iI wrote the join query with customer table. the query is, when iI execute this query they will return 5 records:

$collection = $this->getCollection()
    ->addAttributeToSelect('userid')
    ->addAttributeToSelect('firstname')
    ->addAttributeToSelect('lastname')
    ->addAttributeToSelect('profile_image')
    ->addAttributeToSelect('specialist')
    ->addAttributeToFilter('group_id', 5);
$collection->getSelect()
    ->joinLeft(
        $collection->getSelect()->joinLeft(array('rating'=>'flrating''rating' => 'flrating'), 
        'e.entity_id = rating.reviewed_user_id', 
        array('total_rating'=>'count'total_rating' => 'count(rating.review_id)'));
            );
$collection->getSelect()
    ->group('e.entity_id');

butBut when iI execute the simple query they will return correct result (6 records):

  $collection = $this->getCollection()
    ->addAttributeToSelect('userid')
    ->addAttributeToSelect('firstname')
    ->addAttributeToSelect('lastname')
    ->addAttributeToSelect('profile_image')
    ->addAttributeToSelect('specialist')
    ->addAttributeToFilter('group_id', 5);
        return $collection;

even iEven I put the following code in collection table also the code is:

 public function getSelectCountSql()
    {
        $countSelect = parent::getSelectCountSql();
        $countSelect->reset(Zend_Db_Select::GROUP);
        return $countSelect;
    }

canCan you please explain what is my problem and how to overcome the pagination issue, for your further information see the below screen.:

   **result with join query:**

enter image description here Result with join query:

resultResult with simple query:

enter image description here Result with simple query

i wrote the join query with customer table. the query is, when i execute this query they will return 5 records

$collection = $this->getCollection()->addAttributeToSelect('userid')->addAttributeToSelect('firstname')->addAttributeToSelect('lastname')->addAttributeToSelect('profile_image')->addAttributeToSelect('specialist')->addAttributeToFilter('group_id',5);
            $collection->getSelect()->joinLeft(array('rating'=>'flrating'),'e.entity_id = rating.reviewed_user_id',array('total_rating'=>'count(rating.review_id)'));
            $collection->getSelect()->group('e.entity_id');

but when i execute the simple query they will return correct result(6 records)

  $collection = $this->getCollection()->addAttributeToSelect('userid')->addAttributeToSelect('firstname')->addAttributeToSelect('lastname')->addAttributeToSelect('profile_image')->addAttributeToSelect('specialist')->addAttributeToFilter('group_id',5);
        return $collection;

even i put the following code in collection table also the code is

 public function getSelectCountSql()
    {
        $countSelect = parent::getSelectCountSql();
        $countSelect->reset(Zend_Db_Select::GROUP);
        return $countSelect;
    }

can you please explain what is my problem and how to overcome the pagination issue, for your further information see the below screen.

   **result with join query:**

enter image description here

result with simple query

enter image description here

I wrote the join query with customer table. the query is, when I execute this query they will return 5 records:

$collection = $this->getCollection()
    ->addAttributeToSelect('userid')
    ->addAttributeToSelect('firstname')
    ->addAttributeToSelect('lastname')
    ->addAttributeToSelect('profile_image')
    ->addAttributeToSelect('specialist')
    ->addAttributeToFilter('group_id', 5);
$collection->getSelect()
    ->joinLeft(
        array('rating' => 'flrating'), 
        'e.entity_id = rating.reviewed_user_id', 
        array('total_rating' => 'count(rating.review_id)')
    );
$collection->getSelect()
    ->group('e.entity_id');

But when I execute the simple query they will return correct result (6 records):

$collection = $this->getCollection()
    ->addAttributeToSelect('userid')
    ->addAttributeToSelect('firstname')
    ->addAttributeToSelect('lastname')
    ->addAttributeToSelect('profile_image')
    ->addAttributeToSelect('specialist')
    ->addAttributeToFilter('group_id', 5);
return $collection;

Even I put the following code in collection table also the code is:

public function getSelectCountSql()
{
    $countSelect = parent::getSelectCountSql();
    $countSelect->reset(Zend_Db_Select::GROUP);
    return $countSelect;
}

Can you please explain what is my problem and how to overcome the pagination issue, for your further information see the below screen:

Result with join query:

Result with simple query:

Result with simple query

Bumped by Community user

occurred Aug 13, 2016 at 16:36

Bumped by Community user

occurred Jul 9, 2016 at 3:31

Bumped by Community user

occurred Jun 8, 2016 at 3:11

Bumped by Community user

occurred May 8, 2016 at 4:21

deleted 6 characters in body

Source Link

edited Jul 7, 2015 at 10:07

Keyur Shah

18.1k
6
67
80

i wrote the join query with customer table. the query is, when i execute this query they will return 5 records

i wrote the join query with customer table. the query is, when i execute this query they will return 5 records 
    
    $collection = $this->getCollection()->addAttributeToSelect('userid')->addAttributeToSelect('firstname')->addAttributeToSelect('lastname')->addAttributeToSelect('profile_image')->addAttributeToSelect('specialist')->addAttributeToFilter('group_id',5);
            $collection->getSelect()->joinLeft(array('rating'=>'flrating'),'e.entity_id = rating.reviewed_user_id',array('total_rating'=>'count(rating.review_id)'));
            $collection->getSelect()->group('e.entity_id');

 
but when i execute the simple query they will return correct result(6 records)

but when i execute the simple query they will return correct result(6 records)

  $collection = $this->getCollection()->addAttributeToSelect('userid')->addAttributeToSelect('firstname')->addAttributeToSelect('lastname')->addAttributeToSelect('profile_image')->addAttributeToSelect('specialist')->addAttributeToFilter('group_id',5);
        return $collection;

even i put the following code in collection table also the code is

even i put the following code in collection table also the code is

 public function getSelectCountSql()
    {
        $countSelect = parent::getSelectCountSql();
        $countSelect->reset(Zend_Db_Select::GROUP);
        return $countSelect;
    }
can you please explain what is my problem and how to overcome the pagination issue, for your further information see the below screen.

can you please explain what is my problem and how to overcome the pagination issue, for your further information see the below screen.

   **result with join query:**

enter image description here

result with simple query

enter image description here

i wrote the join query with customer table. the query is, when i execute this query they will return 5 records 
    
    $collection = $this->getCollection()->addAttributeToSelect('userid')->addAttributeToSelect('firstname')->addAttributeToSelect('lastname')->addAttributeToSelect('profile_image')->addAttributeToSelect('specialist')->addAttributeToFilter('group_id',5);
            $collection->getSelect()->joinLeft(array('rating'=>'flrating'),'e.entity_id = rating.reviewed_user_id',array('total_rating'=>'count(rating.review_id)'));
            $collection->getSelect()->group('e.entity_id');

 
but when i execute the simple query they will return correct result(6 records)

  $collection = $this->getCollection()->addAttributeToSelect('userid')->addAttributeToSelect('firstname')->addAttributeToSelect('lastname')->addAttributeToSelect('profile_image')->addAttributeToSelect('specialist')->addAttributeToFilter('group_id',5);
        return $collection;

even i put the following code in collection table also the code is

 public function getSelectCountSql()
    {
        $countSelect = parent::getSelectCountSql();
        $countSelect->reset(Zend_Db_Select::GROUP);
        return $countSelect;
    }
can you please explain what is my problem and how to overcome the pagination issue, for your further information see the below screen.

   **result with join query:**

enter image description here

result with simple query

enter image description here

i wrote the join query with customer table. the query is, when i execute this query they will return 5 records

$collection = $this->getCollection()->addAttributeToSelect('userid')->addAttributeToSelect('firstname')->addAttributeToSelect('lastname')->addAttributeToSelect('profile_image')->addAttributeToSelect('specialist')->addAttributeToFilter('group_id',5);
            $collection->getSelect()->joinLeft(array('rating'=>'flrating'),'e.entity_id = rating.reviewed_user_id',array('total_rating'=>'count(rating.review_id)'));
            $collection->getSelect()->group('e.entity_id');

but when i execute the simple query they will return correct result(6 records)

  $collection = $this->getCollection()->addAttributeToSelect('userid')->addAttributeToSelect('firstname')->addAttributeToSelect('lastname')->addAttributeToSelect('profile_image')->addAttributeToSelect('specialist')->addAttributeToFilter('group_id',5);
        return $collection;

even i put the following code in collection table also the code is

 public function getSelectCountSql()
    {
        $countSelect = parent::getSelectCountSql();
        $countSelect->reset(Zend_Db_Select::GROUP);
        return $countSelect;
    }

can you please explain what is my problem and how to overcome the pagination issue, for your further information see the below screen.

   **result with join query:**

enter image description here

result with simple query

enter image description here

Source Link

asked Jul 7, 2015 at 9:18

senthil

1.7k
2
27
56

magento customer table join query group by make problem in pagination

i wrote the join query with customer table. the query is, when i execute this query they will return 5 records 
    
    $collection = $this->getCollection()->addAttributeToSelect('userid')->addAttributeToSelect('firstname')->addAttributeToSelect('lastname')->addAttributeToSelect('profile_image')->addAttributeToSelect('specialist')->addAttributeToFilter('group_id',5);
            $collection->getSelect()->joinLeft(array('rating'=>'flrating'),'e.entity_id = rating.reviewed_user_id',array('total_rating'=>'count(rating.review_id)'));
            $collection->getSelect()->group('e.entity_id');


but when i execute the simple query they will return correct result(6 records)

  $collection = $this->getCollection()->addAttributeToSelect('userid')->addAttributeToSelect('firstname')->addAttributeToSelect('lastname')->addAttributeToSelect('profile_image')->addAttributeToSelect('specialist')->addAttributeToFilter('group_id',5);
        return $collection;

even i put the following code in collection table also the code is

 public function getSelectCountSql()
    {
        $countSelect = parent::getSelectCountSql();
        $countSelect->reset(Zend_Db_Select::GROUP);
        return $countSelect;
    }
can you please explain what is my problem and how to overcome the pagination issue, for your further information see the below screen.

   **result with join query:**

enter image description here

result with simple query

enter image description here

Stack Exchange Network

Return to Question

magento customer table join query group by make problem in pagination