Created a custom Table and Created a variable on a record producer which is reference to that custom

[VenkataMouC]

1. I have created a custom table in CSM scoped application. and I have created a record producer to create the records in that custom table.

2. On that record producer I have created a reference type variable which is referenced to that custom table.

3. As a admin  I can see the data in that reference field and I can search with attributes like Product name in english, product name in japan

4. but for some other users(non admins) if the display field is a custom field they cant see the data in the reference field. if i make number field as display field they can able to see the data in reference field but they cant able to search with the custom attributes.

5. I have created table level read acl and table.* acl and field level (table.field) acl but still they cant see the data and they cant search with custom attributes.

6. On the custom table it is accessible in all scoped applications as true.

can you please respond immediately if you know the solution.

[GlideFather]

Hi @VenkataMouC,

if it is variable, you might need to add variable formatter to display the data from a record producer in the backend view or workspace..

Read this Service Catalog variable editors and let me know if that solves your issue

[VenkataMouC]

On Service Portal(abw Portal), We have a record Producer on that we have a select box "Type" with choices New, Edit. If they click on new, new form fields will visible and after clicking on submit a record will created in the custom table.

If the user selects Edit then we are showing a reference variable to that custom table.
On the custom table, If we put display field as custom attribute--> then the existing data is not showing on the record producer on the portal.

If we put display field as auto number field, data is showing in that field but they cant search with the custom attrubutes.

[Ankur Bawiskar]

@VenkataMouC 

is your table task extended?

non-admin is unable to see data in reference variable while submitting on portal or native?

share some screenshots

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[VenkataMouC]

Hi Ankur,
On Service Portal(abw Portal), We have a record Producer on that we have a select box "Type" with choices New, Edit. If they click on new, new form fields will visible and after clicking on submit a record will created in the custom table.

If the user selects Edit then we are showing a reference variable to that custom table.
On the custom table, If we put display field as custom attribute--> then the existing data is not showing on the record producer on the portal.

If we put display field as auto number field, data is showing in that field but they cant search with the custom attrubutes.