PatrickRQ Posted June 1, 2023 Share Posted June 1, 2023 Hi IPS, In Pages, I create a new database and custom field on it, OrderID, used to order the records in DB, it is Number type, however is being sorted as text, that means we have 1 11 2 22 3 instead 1 2 3 11 22 Link to comment Share on other sites More sharing options...
Marc Posted June 1, 2023 Share Posted June 1, 2023 Could you let me know which database, so I can take a look? Link to comment Share on other sites More sharing options...
PatrickRQ Posted June 1, 2023 Author Share Posted June 1, 2023 (edited) MySQL 5.6, InnoDB Edited June 1, 2023 by PatrickRQ Link to comment Share on other sites More sharing options...
Jim M Posted June 1, 2023 Share Posted June 1, 2023 46 minutes ago, PatrickRQ said: MySQL 5.6, InnoDB Sorry, there may be some confusion. My colleague is asking for the Pages Database name, not your MySQL database version. Link to comment Share on other sites More sharing options...
PatrickRQ Posted June 1, 2023 Author Share Posted June 1, 2023 This is custom Pages database, by default Pages app has no databases. I just created new pages database, and in Options selected OrderID field as the one used to order records. Link to comment Share on other sites More sharing options...
Jim M Posted June 1, 2023 Share Posted June 1, 2023 You would indeed need to give the Pages Database a name. Please let us know what that is and we can take a look at your configuration: We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. We look forward to further assisting you. Link to comment Share on other sites More sharing options...
PatrickRQ Posted June 1, 2023 Author Share Posted June 1, 2023 (edited) It really matters? I named the database Faq Edited June 1, 2023 by PatrickRQ Link to comment Share on other sites More sharing options...
Jim M Posted June 1, 2023 Share Posted June 1, 2023 As mentioned, please provide access: We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. We look forward to further assisting you. Link to comment Share on other sites More sharing options...
Marc Posted June 2, 2023 Share Posted June 2, 2023 Please bear with us on this. I have just tagged a developer on this as I believe it may be related to an issue which we are aware of. Link to comment Share on other sites More sharing options...
PatrickRQ Posted June 2, 2023 Author Share Posted June 2, 2023 53 minutes ago, Marc Stridgen said: Please bear with us on this. I have just tagged a developer on this as I believe it may be related to an issue which we are aware of. Oh great. Is that mean I do not need to provide access anymore? Thanks! Link to comment Share on other sites More sharing options...
Marc Posted June 2, 2023 Share Posted June 2, 2023 1 hour ago, PatrickRQ said: Oh great. Is that mean I do not need to provide access anymore? Thanks! For the minute no Link to comment Share on other sites More sharing options...
Management Matt Posted July 3, 2023 Management Share Posted July 3, 2023 The ordering issue isn't the same as the GH issue. I think we've (tried) to fix the sorting issue before. If you can give Marc some more information, we can take a look. Link to comment Share on other sites More sharing options...
PatrickRQ Posted July 3, 2023 Author Share Posted July 3, 2023 (edited) What other info you need? It looks like it sorts numbers as it would sort strings. If you will e.g. do two columns, VARCHAR and INT, and do ASC SORT.. the VARCHAR will get 1112223 and INT will get 1231122 Edited July 3, 2023 by PatrickRQ Link to comment Share on other sites More sharing options...
Marc Posted July 3, 2023 Share Posted July 3, 2023 Sorry, Im a little confused as to what you mean there. Both of those are sorted correctly as the first is correctly sorted as text (as thats the type you are using), and the latter as a number Link to comment Share on other sites More sharing options...
Management Matt Posted July 3, 2023 Management Share Posted July 3, 2023 We’d need access to your site and database to see what the query is. We do cast it int if it’s numeric so something is going wrong there. Link to comment Share on other sites More sharing options...
Recommended Posts