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

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)’, as num_id

as this caused an internal error.

2017-02-11 18_51_19-DBS Operations

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.

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

1 Like

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