Tip #56 | Fix Error : Sorting cannot be done based on the XX field

Datetime:2016-08-23 04:05:09          Topic: SQL           Share

Today I’ve spent some time in NAV2016 figuring out this error message:

As you know in NAV2016 you can sort on each column even if there is no key and even if it’s a flowfield. So why am I getting this error?

In my case the Test field is a Flowfield of the type COUNT to another table. This should work fine, so why doesn’t it work here.

Reason is that the SQL Data Type is Integer instead of VarChar. A very old trick to make a SQL Database sort a Code field just like the Native database.

The SQL Data Type in the “Other” table does not match this SQL Type hence the sorting fails.

Since I could not find any info online on this message I thought it was worth sharng.





About List