Company table data not showing
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yesterday - last edited yesterday
Hello everyone,
In a few ServiceNow instances, when we open the Company field data, no records are visible—even though data actually exists.
When I check the core_company table, the record count is displayed, but the records themselves do not appear. If I try to open a record directly, it shows "Record not found."
How can we fix this issue in ServiceNow?
We don't have any security rules in place.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yesterday
Greetings @SK Chand Basha. Have you checked the Access Control (ACL) table [sys_security_acl] to see which Role(s) is mapped to the "read" ACL? Below is a screenshot of one of the "read" ACLs from my Personal Developer Instance (PDI). Can you check either the ACL table or if the account you are testing with has one of these Roles: model_manager, itil or user_admin role?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yesterday
there must be some query business rule on core_company table which is restricting the data
💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yesterday - last edited yesterday
Hi @Ankur Bawiskar @lpruit2
If i we open with safari browser it is showing data sometimes , we don't have any security rules
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yesterday
I am referring to query business rule and not ACL
Did you check that?
💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader