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

[tommeacham (Thomas Meacham)]

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.

[subbotin (Andrey Subbotin)]

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.

[subbotin (Andrey Subbotin)]

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

[system]

See the following issue in our bug tracker:

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