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

Could you let me know which database, so I can take a look?

MySQL 5.6, InnoDB

Edited June 1, 20231 yr by PatrickRQ

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.

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.

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. 

 

It really matters? I named the database Faq

Edited June 1, 20231 yr by PatrickRQ

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. 

 

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.

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!

1 hour ago, PatrickRQ said:

Oh great. Is that mean I do not need to provide access anymore? Thanks!

For the minute no

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.

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 

1
11
2
22
3

and INT will get

1
2
3
11
22

Edited July 3, 20231 yr by PatrickRQ

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

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.