Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / How can one set a Defa...
Microsoft Dynamics NAV (Archived)

How can one set a Default Filter Column from the source tables or programmatically?

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I have been doing some research into an issue. The client has customized their Item No. LookUp to open the Item List page, instead of using the built-in drop down menu. Because of this the user's cannot select the Search Description to be their default lookup column. I found out that this information is stored in the Page Data Personalization table. I tried to make a copy of the line that has this set for one of the users and update the User SIS and USER ID to a new user, but I get validation errors. I don't know what the BLOB is for the Value field. How can this be achieved? Maybe a processing report?

*This post is locked for comments

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: How can one set a Default Filter Column from the source tables or programmatically?

    I do not think you can directly copy this line as this is internal system table

  • RockwithNav Profile Picture
    RockwithNav 6,562 on at
    RE: How can one set a Default Filter Column from the source tables or programmatically?

    No you you can't do. System will not allow you as you cant play with the BLOB fields directly. Furthermost these tables are handled internally.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How can one set a Default Filter Column from the source tables or programmatically?

    Could I copy the line in a codeunit, and just change the User ID and User Sys ID?

  • Verified answer
    RockwithNav Profile Picture
    RockwithNav 6,562 on at
    RE: How can one set a Default Filter Column from the source tables or programmatically?

    Hey zaq1028,

    You really did a very good RND in terms of finding how exactly NAV stores information of the savevalues or the Default filter column, but I want just to share that this value column which is a BLOB field exactly saves the reference of the column which you cant handle manually.

    Use this table only if you want to clear some stored values

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans