Get a first look at what's coming. The Developer Passport Australia Release Preview kicks off March 12. Dive in! 

Database views is not showing records but showing the count

Hareesha
Tera Contributor

‎04-18-2022 06:43 PM

Database views is not showing records but showing the count.

Below are the where clause i have used.

 

find_real_file.png

Preview file
18 KB
0 Helpfuls
  • 1,354 Views
19 REPLIES 19

Ankur Bawiskar
Tera Patron
In response to Hareesha

‎04-18-2022 09:42 PM

share the where clause when you are using 5 tables

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

Hareesha
Tera Contributor
In response to Ankur Bawiskar

‎04-18-2022 09:49 PM

0 Helpfuls

Ankur Bawiskar
Tera Patron
In response to Hareesha

‎04-18-2022 10:21 PM

Hi,

update where clause for sys_user_group as this

usergrp_parent=grpmem_group

Regards
Ankur

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

Hareesha
Tera Contributor
In response to Ankur Bawiskar

‎04-18-2022 10:35 PM

I am getting No records found

0 Helpfuls

Ankur Bawiskar
Tera Patron
In response to Hareesha

‎04-18-2022 10:42 PM

share your latest conditions

Also are you sure you have records satisfying the where clause.

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