Find distinct not working

Question

Find distinct not working

Stefjoe Dec '16

Created Dec '16	Last Reply Dec '16	Replies 2	Views 621	Votes 0

Stefjoe 59.9k

Dec '16

Hi,

why is this not working?

    $country = new Select(
            "country",
            Country::find(['distinct' => 'country', 'order' => 'country']), 
            ["using" => ["country", "country"],
            'class'=> "form-control"]
        );
    $country -> setLabel('Country');
    $this->add($country);

order is working but distinct not.

Wojciech Ślawski
145.0k

Accepted
answer

edited Dec '16
Dec '16

Beacause there is no such argument as distinct.

Try to use:

'columns' => 'DISTINCT country'

Stefjoe · Answer 1 · 2016-12-29T14:15:34-07:00

Stefjoe
59.9k

Dec '16

Yes, thx Wojciech :-)

Nikolay Mihaylov · Answer 2 · 2016-12-29T14:36:17-07:00

Nikolay Mihaylov
93.7k

Dec '16

Maybe he got confused with the aggregate examples in the docs here.

Stefjoe · Answer 3 · 2016-12-29T16:06:53-07:00

Stefjoe
59.9k

Dec '16

Yes Nikolay, i took this example from the docs.