show filter option of reference field to end user?

[Gudu]

Hello Developers,

I have created a catalog form where one field called as "select the cmdb application" which is reference to cmdb_ci_appl table and when i click on maginfying glass it is showing me the related records with filter option as below.

But this filter option is not populating to end user when they want to access the catalog as below 

could anyone please guide if it is fisible to show the filters to end user. 

is this something , the user is not having to access to cmdb_ci_appl table. 

Please do let me know if anyone having any doubt in my query?

[Mark Manders]

Without access to the table, an end user can't see anything it needs to select. If you use a reference to a table, make sure the users have access to it.

[Ankur Bawiskar]

@Gudu 

when they click the lookup icon they are not seeing any records?

did you add any filter condition in the variable?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Gudu]

Hi Ankur,

No they can see the records but filter option is not coming like the first image i have shared. 

This is what i am saying, as an admin we can search each record here but this filters are not showing to end user.

When i am impersonating the user, they are getting below 

Here you can see , data is visible but filter option like search options are not coming as like the above image . 

I believe this is due to they don't have access to cmdb_ci_appl table.

[Ankur Bawiskar · Accepted solution]

@Gudu 

yes it must be only for admin role.

when you click lookup on cmdb_ci_appl table in the variable.

1) right click on list header

2) configure list control

3) see which role is added in Filter roles field -> if admin is there then non-admin can't apply filter

If my response helped please mark it correct and close the thread so that it benefits future readers.