Glide Record not working in Database view

Garima Pant1
Tera Contributor

I created a database view for 3 tables- cmdb_ci (Configuration Item), cmdb_software_instance (Software Instances), cmdb_ci_spkg (Software Packages). When I try to glide into the table and get the number of records, it shows me incorrect value.

Database view: u_softwares_on_windows_servers
TableOrderLeft joinActiveVariable prefixWhere clause
cmdb_ci100truetruecmdbci(cmdbci_sys_id = si_installed_on) 
cmdb_software_instance200falsetruesi  
cmdb_ci_spkg300falsetruespsi_software = sp_sys_id

Total records in database view: 1,000,954

Records shown when gliding the table: 10,001

Background script : 

var incidents = new GlideRecord("u_softwares_on_windows_servers");
incidents.query();
gs.print(incidents.getRowCount());

1 ACCEPTED SOLUTION

Nikita30
Mega Sage

Hi Garima,


Please edit the property glide.db.max_view_records to manage the number of records in the database view.

Please mark the response as Helpful/Correct, if applicable. Thanks!

View solution in original post

2 REPLIES 2

Ravi9
ServiceNow Employee
ServiceNow Employee

See if this helps !
doc link

Nikita30
Mega Sage

Hi Garima,


Please edit the property glide.db.max_view_records to manage the number of records in the database view.

Please mark the response as Helpful/Correct, if applicable. Thanks!