Identity Datatype sorts like a string in a table. Anyway to correct this?

Support
#1

I am using identity as a primary key on a project. I am identifying individual records in a table with by exposing the ID column. This works well except for one issue. It does not sort like a number but rather a string.

Any tips on how to correct this? I was unsuccessful attempting to use native sql in the collection datasource

SQL(‘CAST(? as INT)’, e.id) as num_id

as this caused an internal error.

2017-02-11 18_51_19-DBS Operations

#2

Hi Thomas,

Thank you for reporting the problem. We have created a YouTrack issue, see the link on the right.
We’ll try to fix it in the next minor release of 6.4.

#3

Hi Thomas,
the problem is fixed in the platform version 6.4.1.

1 Like
#4

:ticket: See the following issue in our bug tracker:

https://youtrack.cuba-platform.com/issue/PL-8640