All records from table not showing on reference field
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-16-2021 07:20 AM
I have a reference field on a catalog item that is referencing a table with 18,000 records. User are reporting that all records are not appearing. Is there a cut off to the amount of records that will appear? If so is there a system property that I will need to adjust?
- Labels:
-
Service Catalog
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-16-2021 07:26 AM
Hi Ear19
Below are the few things you can verify
- Check if there are any conditions applied on the variable.
- Check if there are any read ACL's that is restricting the records.
- Check if there are any query business rules written on that table that is restricting the read access.
Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for
Kind Regards,
Rohila V
2022-25 ServiceNow Community MVP
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-16-2021 07:27 AM
Hi,
Possible things to check
1) Any query business rule is restricting the records
2) Any table level READ ACL is restricting the records
3) Any reference qualifier applied on that variable which is restricting the records
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader