Dear,
I can’t quite get to grips with the issue of sorting records in the database. I have an asin field (integer type). It contains the identifiers of the records. But the records are not sorted in the correct order. The data for the database was imported from a csv file, and then the asin field type was changed to integer. How can this issue be resolved? Many thanks in advance for your help.
Regards
Adam
What are you using to set these values as integers? The Numeric Data Types module?
Yes, I am using the Numeric Data Types module (1.1.13 version). I see two IDs in the sorting criteria. One ID alone and the other with the information added in brackets: numeric:integer. Both criteria generate a different order of the retrieved records.
The “numeric:integer” one is the one that should sort in proper numeric order.
What behavior/ordering are you seeing when you do that?
For example, with descending sorting, the record starts with the record with ID 25, reaches record 52 and then records from ID 1 start. Record 205 is followed by record 1218.
Are you sure the actual values you have now are integers? Setting or changing the resource template after making the items, for example, won’t change the type of the existing values.
Thank you. You are right. I have finally managed to solve this problem.