List collect showing "No matches found"

Eric Gilmore · ‎12-11-2019

I have a list collector that points to a table for it's values. If a non ITIL role user tries to use the variable, they get "No matches found". The table only has the default ACL & user it was setup with. What's going on here? Has anyone else run into this?

Eric Gilmore · ‎12-13-2019

So I did this workaround.

The background is that users without any roles assigned, or NOT associated with roles like ITIL or maybe admin, can't see the reference field values.

So, as a work around I changed the field on my record producer from a reference field to a select box with no values. I then created a script include with a getter function to lookup the entries in the reference table. Next I created a client script on the variable set that uses a GlideAjax script to make a call from the client side to server side to retrieve our data from the reference table.

I filter the returned entries in the script include via an addQuery() function, to return a subset of the possible values in the reference table. Using these returned entries on the client side I do a g_form.addOptions() to load our selectbox with the options we want and their associated sys_ids.

Now since I did a lookup on my reference table, I'm using the actual sys_ids I need to properly set the other form field on the Incident form. Because of this, the values are properly set using the correct sys_ids. No muss, no fuss, no more values not showing up in my drop down.

So what I essentially did was to bypass whatever process is used to authenticate that a user has the proper role to see the values in my reference table. 😮

View solution in original post

prasannakumard · ‎12-11-2019

Hi Eric,

If it is a customization table, check that ACL's having any role inside that and remove roles from that ACLs.

Thanks & Regards,

Prasanna Kumar

Eric Gilmore · ‎12-11-2019

Ok, I unchecked access roles, deleted the default acls that were created. Logged off and back on, and I still getting the "No matches found". I'll try creating a new read ACL now.

Stephen Sturde · ‎12-11-2019

Hi Eric -

You'll need to create a new read ACL record for the table that users need to select values from. The ACL will be table.* with no roles associated.

Let me know if you have any additional questions.

-Stephen

Eric Gilmore · ‎12-11-2019

Just a random ACL? So, do I just re-check "Create Access Roles" then go add an ACL? Or do I just add another ACL in the Access controls section w/o checking the box?