65
Hello
I am using Nav 2016
how can I sort contact list created by date?
our developer says that we can not sort it created by date.so please gives me some alternate.
Regards
Monik
*This post is locked for comments
Hi,
Sorting option in contact list page is disabled in NAV2016 and this is due to 'IndentationColumnName' property of Repeater group. You can try removing this property and you will be able to sort the page. This property is not set in contact list page of NAV2017. Please check community.dynamics.com/.../233782
In the Contact table (5050) there is "Last Date Modified" field (msdn.microsoft.com/.../hh165543(v=nav.90).aspx). When you change information on the contact card, the program automatically updates the Last Date Modified field to show the current system date. It is also filled in with current date when you create the contact. If you do not modify the contacts much, perhaps this field would satisfy your requirement to some point. You would need just to reveal it on the contacts list page.
Another standard option is to enable Change Log (msdn.microsoft.com/.../hh169208(v=nav.90).aspx), and setup logging of insert records to Contact table. Later on extract from the log the information when certain contacts were created.
You can also make a small modification and add a new field to Contact table, and fill it in automatically with current date each time a new contact is created.
Monik
Depends on what you mean by created date? Which field? Standard Nav has a last modified date and you can manage changes in terms of creation via the change log. So have you got a bespoke field called created date or are you referring to the change log?
Neil
#1
André Arnaud de Cal...
292,494
Super User 2025 Season 1
#2
Martin Dráb
231,305
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
