Forums

Order Read Data in CF6

cyberspyder 11 Sep, 2019
I'm trying to order this read data by the title field but when I put in the order fields 'Location.title', 'title', or 'table_name.title' it either does nothing or makes the drop down that it auto fills become blank. Am I putting in the wrong format for order fields or is it something else?

healyhatman 12 Sep, 2019
You should give your form fields a useful name like "location_title" or something instead of "select58"

You're also supposed to provide TWO fields, not three.
cyberspyder 12 Sep, 2019
Thank you very much for the reply. I really appreciate your time and attention. I removed the extra field provided (published) and still - no sorting. I just need to order these alphabetically by title.

What do we type in where it says order fields? We have tried only the column name for that table, which is "title". We have tried the tablename.title, we have tried our dataset Location.title nothing works. Most of them break the form.
healyhatman 12 Sep, 2019
You need to include the direction too.

title/asc or title/desc
cyberspyder 13 Sep, 2019
The default for making an order field is Ascending so we left it there and the form does nothing to sort the dropdown. Here's a screenshot of the form and the backend section.
healyhatman 13 Sep, 2019
Sorry forgot dropdowns are automatically sorted by key. Dunno where in the code it makes it like that soz
This topic is locked and no more replies can be posted.