You’re offline. This is a read only version of the page.
2
There is a table in NAV with a column that I need to sort that table by however that column is not listed in the Sorting options. How can I go about selecting/setting the appropriate column to sort by? I have attached a screenshot of a similar situation of what I am talking about, however not the exact situation of a missing column from the sorting options.
*This post is locked for comments
They use it as a current task list for their hourly tasks. When they come close to finishing their tasks for the day, someone adds in the next days tasks into this list however the expected finishing date is the following day. The order becomes all messed up and it was requested to be able to sort by this date to keep the most current tasks at the top of the list. Scanning the list with their eyes was not an option for them....
Hi, Edward.
Before adding the new key in table, please be aware of the following:
Each key you add to the table is impacting the performance when NAV/SQL Server works with that table. I'm not gonna explain all this in deep right now. It's not advisable to add a key just so you could sort the records on a page in that way from time to time. If sorting by the field(s) in question is something really, really necessary and records will be sorted using the new key very often, then by all means, create the new key. If not, the alternative is to export data to Excel and sort them any way you want.
Of course, you will need a developer license :-)
You should design the table and edit the Keys: msdn.microsoft.com/.../dd301433.aspx
Good luck!
As per suresh post, you should create key for required field to sort the records.
Go to table and from design -> View -> Keys create a key for that field
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (