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.