Sonya* Posted March 24, 2022 Share Posted March 24, 2022 (edited) I have a Pages database where products are stored. I have defined two fields of type Number: Storage Place and Price. Both fields are required. The list of what is not possible with the fields: Sorting by these fields in record listing does not make sense as it sorts by characters and not by numbers Required does not make sense, as the fields are always pre-filled with 0 and stored with this value without an error message The database to reproduce the behavior on default Pages templates is attached. The values I have entered to test are on the screenshot. This is a result of sorting by Storage Place. Sorting by Price does not change the order. Note: I know a technical background why this does not work. Please see this as a report from an end-user who tries to set up this kind of database in Pages. Large_database.xml Edited March 24, 2022 by Sonya* TDBF 1 Link to comment Share on other sites More sharing options...
TDBF Posted March 24, 2022 Share Posted March 24, 2022 This is one of my annoyances with this software in general. When displaying items by name, just about everything is not ordered by name. The Pages in the Menu Manager is a prime example of this. I really wish they would display items is alphabetical order rather then when created or updated with items like this. So much harder to find the items you are looking for when it is thrown at you like this. Link to comment Share on other sites More sharing options...
Marc Stridgen Posted March 24, 2022 Share Posted March 24, 2022 56 minutes ago, TDBF said: This is one of my annoyances with this software in general. When displaying items by name, just about everything is not ordered by name. The Pages in the Menu Manager is a prime example of this. I really wish they would display items is alphabetical order rather then when created or updated with items like this. So much harder to find the items you are looking for when it is thrown at you like this. Please could you post this as a suggestion rather than in someones support topic 🙂 Link to comment Share on other sites More sharing options...
TDBF Posted March 24, 2022 Share Posted March 24, 2022 2 minutes ago, Marc Stridgen said: Please could you post this as a suggestion rather than in someones support topic 🙂 Sure 🙂 Link to comment Share on other sites More sharing options...
Marc Stridgen Posted March 24, 2022 Share Posted March 24, 2022 Thank you for bringing this issue to our attention! I can confirm this should be further reviewed and I have logged an internal bug report for our development team to investigate and address as necessary, in a future maintenance release. Link to comment Share on other sites More sharing options...
Sonya* Posted April 18, 2022 Author Share Posted April 18, 2022 This is not solved for me on 4.6.12.1. It is still sorted by first character instead of numbers. See the Price column below: Link to comment Share on other sites More sharing options...
Marc Stridgen Posted April 18, 2022 Share Posted April 18, 2022 Please could you let me know which of your sites this relates to? I can then take a look Link to comment Share on other sites More sharing options...
Sonya* Posted April 18, 2022 Author Share Posted April 18, 2022 It is a localhost. You can see test data on the screen that are not available to the public. Should I upload a database attached above to one of my live communities and fill it with test data? Link to comment Share on other sites More sharing options...
Marc Stridgen Posted April 18, 2022 Share Posted April 18, 2022 I can, however as we can no longer replicate it on our end, we would need to see what is different. If you could, that would certainly be helpful 🙂 Sonya* 1 Link to comment Share on other sites More sharing options...
Sonya* Posted April 20, 2022 Author Share Posted April 20, 2022 I have created a database on invisionify.com/test-database for you (only for Admins, please log in to reproduce the following bugs): Required field Storage place never throws an error and saves the 0 value without warning. It is always preset with 0. Even if 0 is emptied, the record is saved with 0. The same for the field Price. Select sort by and see another bug, where the field Storage Place field is duplicated with sort_cms_custom_database_12.field_50 in the list of fields. (Hint: only reproducible if you set a database to sort by this field in AdminCP) Try to sort by Price. The sorting order will be 3.00, 11.00, 5.00, and 10.00. It should be 3.00, 5.00, 10.00, 11.00. Or vice versa if descending. Try to sort by Custom and deselect Special offer in the modal view. You will not be able to deselect. (Hint: only reproducible if you add filters block to the page) You are free to change the database, add records, edit, delete, remove and add blocks, everything you like. The database is only for Administrators. Link to comment Share on other sites More sharing options...
Marc Stridgen Posted April 20, 2022 Share Posted April 20, 2022 OK, it seems when looking through this I have caused a little confusion. My apologies for that. The fixes for these didnt make it through to the 4.6.12 release, so you will see these on the next release Sonya* 1 Link to comment Share on other sites More sharing options...
Marc Stridgen Posted July 11, 2022 Share Posted July 11, 2022 This issue has been resolved in 4.7.0 which has recently been released. Please upgrade to that version to resolve this, and of course, let us know if you are still seeing any issues. Link to comment Share on other sites More sharing options...
Recommended Posts