Reference field values are not visible in Portal

[Ranjit Singh Ra]

I have an HR Service (Scope - Human Resources: Core) in the ESC Portal. 

I have created a custom table "Routing ID" in Global scope which extends CMDB CI Table. 

I have a variable in the HR Service which is referenced to the custom table. I have records in the custom table but still I am unable to see any records from the Portal. It says "no matching records found"

I have given the custom table Read ACL to my user, and also given the cmdb_read role to my user, still the same issue.

Please let me know what I can check to get this fixed.

Thank you.

[ersureshbe]

Hi, From above screen can you check the 'Controls' tab. Any role associated with the table. If yes, you can remove the role and check the status. In case, the reference field associated with sys_choice table you should check the role for choice table.

[Ranjit Singh Ra]

I checked the Controls table and we have a field called "User Role", we have table specific role there, I removed and added the sn_hr_core.basic role and logged out and logged back in and checked, no difference.

I also checked to uncheck the Auto-create ACL, that is also not making any difference.

[Nilesh Wahule]

Hi Ranjit, 
Can you confirm that you are not using any reference qualifier condition for variable which is referencing to your custom table?

Also, If there is any error saying access denied cause of restricted called access, You can check RCA Table once ...

---

Nilesh Wahule

[Ranjit Singh Ra]

Hi Nilesh,

There isn't any reference qualifier:

I have also checked the RCA and have done sort of "z to a" and I do not see any recent records there. 

Is there anything I can check?

Thank you for your suggestions!

[RaghavSh]

Can you set the Display field on your table, maybe "name" or any other field and then check.