Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

pedro22's avatar

Using sort / orderby on view with pluck

Hello,

I would like sort / orderby my select option directly on my view

                        {{
                            Form::select(
                                'office[' . $index . '][home_id]',
                                App\Models\Team::pluck('name', 'id'),
                                isset($office['home_id']) ? $office['home_id'] : null,
                                [
                                    'class' => 'form-control'
                                ]
                            )
                        }}

I tried :

     App\Models\Team::orderBy('name')->'pluck('name', 'id'),
..
     App\Models\Team::sortBy('name')->'pluck('name', 'id'),

If you have an idea thank you

0 likes
5 replies
Snapey's avatar

orderBy on an eloquent query, sortBy on a collection.

App\Models\team::orderBy('name')->pluck('name', 'id')

Try this one line in isolation in tinker ?

Does your model start with lower case t?

I hate Form:: so I'm not going to attempt to untangle that unholy mess.

3 likes
pedro22's avatar

Hi,

Thx, I tried orderby.

On tinker :

{"4":"Va","3":"CA","8":"TR","1":"No","10":"PS","6":"PN","11....} 

Does your model start with lower case t? => no uppercase, sorry a fix my sample

Snapey's avatar

Strange. I wonder why I get a collection and you get json

>>> App\Airport::orderBy('name')->pluck('name','id')->take(20)
=> Illuminate\Support\Collection {#4753
     all: [
       2549 => "A De Barros",
       3949 => "Aachen Merzbruck Arpt",
       3 => "Aalborg Arpt",
       3590 => "Aarhus Bus Service",
       960 => "Aasiaat Arpt",
       3515 => "Aba Tenna D Yilma Arpt",
       3944 => "Abadan Arpt",
       3946 => "Abakan Arpt",
       3533 => "Abbotsford Arpt",
       12 => "Aberdeen Arpt",
       3624 => "Aberdeen ScotRail Station",
       61 => "Abha Airport",
       8 => "Abilene Municipal Arpt",
       4073 => "Abu Simbel Arpt",
       13 => "Abuja Intl",
       2052 => "Achmad Uani Arpt",
       33 => "Ada Municipal Arpt",
       4050 => "Adak Island Ns",
       25 => "Adana Airport",
       2394 => "Addington Field",
     ],
   }
>>>
pedro22's avatar

If i you dd() its Collection :

Collection {#756 ▼
  #items: array:12 [▼
    4 => "VA"
    3 => "CA"
    8 => "TR"
    1 => "No"
    10 => "PS"
  ....
    2 => "NE"
  ]
}
pedro22's avatar

I found my data are sorted well but they are encrypted, I will fix it in js

Thank you

Please or to participate in this conversation.