Need to dynamically change columns on list view of reference field lookup window based on logged in user's role.

[sharma_161]

Hi all,

Can we dynamically change columns on list of records on   reference field   lookup window based on logged in person's role

We have a requirement to show columns differently on reference lookup window list of records when ESS user( without any roles) is raising the request and should see 4 columns from referenced table and if ITIL user is doing the same it should show just 3 columns. So can we configure different list views somehow based on role of logged in User.

Please suggest.

Thanks in advance.

[David OBrien]

I'm pretty sure the pop up list that shows when you search from a reference field always uses the sys_popup view which you can only have one of.   I'm not aware of a way around this.

I did see someone tried to do it with access controls on the fields in the list.   See Different sys_popup per view. One of the replies towards the end suggested having the fields in the view but restricting them with ACLs.   That may have other impacts though depending on what fields you're using and where else they may be used.