Re: Find DISTINCT

On Thursday, September 19, 2013 10:33:46 PM UTC+5:30, advantage+ wrote:

Can someone provide a little help on this?

 

I am trying to get a DISTINCT field from one table based on another table's value.

 

 

public function getActiveStates(){

                               

                $params = array(

                                'contain' => 'Community',

                                'conditions' => array(

                                                'Community.status' => array('Active','Pending')),

                                'fields' => array(

                                                'DISTINCT State.name'));

                return $this->find('list', $params);                         

}

--------------------------------------------------------------------------------------------------------------------

 $this->Model->find('all',  array('fields' => array('DISTINCT Model.fieldname'),
        'conditions' => array('Model.fieldName' => 'Active')
    ));

 

I am trying to get the DISTINCT State.name based on the Community table based on the Community.status so end up with a list like Alaska, Georgia, Illinois….. and so on

 

They do have a Community belongsTo <-> State hasMany all set up

 

Thanks,

 

Dave

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
 
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/groups/opt_out.