Jump to content

Issue with sorting records in pages database


Recommended Posts

I'm developing a pages database similar to the "Recipe" example described in the "Help Guides".
This database contains a number of custom fields, some of them contain "number" fields. Now the idea is to be able to sort the records according to the number in the field, ascending or descending. 

I've activated a default sorting for the relevant field in Databases > Edit database > Option > Field Options
When loading the database, the sorting works as expected. 

Problem: When sorting the records according another custom (number) field, the sort order is not correct anymore. 
Using a default field to sort records works with all fields, however when using custom fields it will show two activated fields in the "sort by" menu (see picture, not sure if this is normal).
Sorting according fields like 'title', 'create date', 'last updated' works as expected. It seems though, that sorting according custom (number) fields does not work properly when using the "sort by" functionality. 

Does anyone have more info on this or can reproduce this on another pages database? 

Picture: Look of "sort by" when database called with default sorting active


Edited by evcom
Link to comment
Share on other sites

I might give it a try on my staging site. Hope to be able to do it in the coming days. Although, I did not plan to mess with any Beta version. But if I can contribute to get a an error fixed, then it's probably worth the effort. 

Link to comment
Share on other sites

Upgraded staging site to 4.5 and YES, the sorting now works. However, numerical fields will be sorted as DESCending. This is not always wanted and the sorting direction doesn't allow ASCending lists. Using the default sorting option, ASCending lists are possible though. 

Link to comment
Share on other sites

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...