How does one set a Default Filter Column in for a LookUp programmatically?

zaq1028

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?

RockWithNAV

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

RockWithNAV

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