Phalcon Volt SELECT with ORDER BY FIELD ?

Question

Phalcon Volt SELECT with ORDER BY FIELD ?

Mahen 3D Jan '16

Created Jan '16	Last Reply Jan '16	Replies 3	Views 799	Votes 1

Mahen 3D 13.4k

Jan '16

I have following code in volt. which i use to genenerat the country list for a select box

                                               {{ select(
                                                'country',
                                                geo_country ,
                                                'using': ['country_id','country_title'],
                                                'onchange': 'showState()',
                                                'class' : 'required',
                                                'useEmpty': 'true',
                                                'emptyText' : 'Please Choose',
                                                'emptyValue' : ''
                                                ) }}

But i want to generate this by order by field value like

ORDER BY FIELD(country_title, "Canada", "India", "other"), country_id ASC

How do i archieve this expected value ?

1

Izo · Answer 1 · 2016-01-05T06:03:39-07:00

Izo
85.5k

edited Jan '16
Jan '16

what is this geo_country ?

Mahen 3D · Answer 2 · 2016-01-05T06:25:18-07:00

Mahen 3D
13.4k

in reply to

Izo

Jan '16

it's the table name.

what is this geo_country ?

Izo · Answer 3 · 2016-01-05T06:33:40-07:00

ah ok my bad, i dont use volt.

but i am not sure you can do that, maybe wait for someone else to respond. The way i use it cna be found here :

https://forum.phalcon.io/discussion/2486/multiple-fields-order-and-using-in-phalcon-tag-select

le51 · Answer 4 · 2016-01-05T11:02:11-07:00

Hi,

maybe you can do the db search in the controller (and then use raw sql if ever your query is too complicated for the basic ORM), pass the result to the view as an array and use selectStatic in the view.