I use prevalue get value from SQL database option form one contour drop download list, currently it sort value in alphabetically by default. How I can change sort by key (id) instead? Because I need one item always on top of dropdown list, and one always on bottom of list. Or I need create another prevalue type?
I have recently worked on site where i created my prevalues as umbraco nodes, this means client can edit through content section and also sort as the sort order is picked up from the content tree. You could also add field to your source table called sort id and have values there then your query that retrieves the data can also sort on that id.
Contour PreValue sort
I use prevalue get value from SQL database option form one contour drop download list, currently it sort value in alphabetically by default. How I can change sort by key (id) instead? Because I need one item always on top of dropdown list, and one always on bottom of list. Or I need create another prevalue type?
Thanks in advance!
Yan,
I have recently worked on site where i created my prevalues as umbraco nodes, this means client can edit through content section and also sort as the sort order is picked up from the content tree. You could also add field to your source table called sort id and have values there then your query that retrieves the data can also sort on that id.
Regards
Ismail
Hi Ismail, in the current contour prevalue sources type: sql database,
It only has three feilds that I can enter: table name, key column, value column
my question was contour related, I do have sort in ms db table. Just in using contour prevalue it didn't give feild to enter the sort and sort by.
is working on a reply...