All records from table not showing on reference field

Ear19
Giga Expert

‎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:
0 Helpfuls
  • 1,873 Views
2 REPLIES 2

Voona Rohila
Mega Patron
Mega Patron

‎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
0 Helpfuls

Ankur Bawiskar
Tera Patron
Tera Patron

‎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

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader
0 Helpfuls