retrieve average rating on a join

This should help you out.

CodeIgniter 4 Users Guide - Query Builder Class - selectAvg

When i try adding selectAvg it returns only the rating field instead of the complete dataSet. 

Example of the code is below 

PHP Code:

function getAllBranches()
    {
        $db      = \Config\Database::connect();
        $builder = $db->table('branches');
        $builder->join('companies', 'companies.id = branches.companyId','left');
        $builder->join('businessprofile', 'businessprofile.companyId = branches.companyId'); 
        $builder->join('rating', 'rating.companyId = branches.companyId'); 
        $builder->selectAvg('rating'); 
    
        $builder->where('paymentstatus', 'active');
        $builder->groupBy(['name', 'location','category']);
        $query = $builder->get();
        
        return $query->getResult();
    } 


---

Thank you for the input. You have pointed me to the right direction. 

All I had to do was Add select('*) before selectAvg. Works as expected.

See code below 

PHP Code:

function getAllBranches()
    {
        $db      = \Config\Database::connect();
        $builder = $db->table('branches');
        $builder->join('companies', 'companies.id = branches.companyId','left');
        $builder->join('businessprofile', 'businessprofile.companyId = branches.companyId'); 
        $builder->join('rating', 'rating.companyId = branches.companyId'); 
        $builder->select('*'); 
        $builder->selectAvg('rating'); 
    
        $builder->where('paymentstatus', 'active');
        $builder->groupBy(['name', 'location','category']);
        $query = $builder->get();
        
        return $query->getResult();
    }