Lookup Select Box values display Null in the native UI and not visible on the portal

Moe13 · ‎12-08-2023

Hello and thank you in advance for your help.

I created a new table with a list of locations to use for a variable in a catalog item. I removed the created ACL role to "read" the table and selected display. This particular catalog item was using a previous custom table but the client asked to created a new table for this variable. The problem I'm having is, the values are not visible on the portal (its there but you can't see it) and on the backend with the "try it" button, they are all listed as null. Please help, what am I doing wrong?

-O- · ‎12-08-2023

The ACLs look OK, seem to be standard ones.

However I seem to see a field labelled Organization - singular (in the 1st screen shot).

But Lookup label field(s) (in another screen shot) contains a field name in plural - u_organizations!

Are you sure u_organizations is the correct, valid field name?

View solution in original post

Moe13 · ‎12-08-2023

It is a string field.

Shamma Negi · ‎12-08-2023

Can you change the lookup value field from sys_id to some other field

Regards,Shamma Negi

Moe13 · ‎12-08-2023

I changed it to the lookup value field to another and no change.

Shamma Negi · ‎12-08-2023

Two things to check:

1. In read ACL make sure snc_internal role should be added. All user by default have the snc_internal added to their profile. So every ACL should atleast have this role.

2. Make one field as "Display" true. Also check, if this variable is Reference Field then should be okay. If the type is Lookup Select box then select the field by right clicking on configure then go to variable and select the right field.

Hope it helps.

Regards,Shamma Negi

Moe13 · ‎12-08-2023

Hi @Shamma Negi ,

You lost me at part B of #2 of if the type is Lookup Select Box. Could you expand on this on show the steps to achieve what you are directing me to do? BTW it displays when I set the type to Reference field. But I want to figure this out.