Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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
  • 958 Views
19 REPLIES 19

Ankur Bawiskar
Tera Patron
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  ||  ✨ 9x 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
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  ||  ✨ 9x 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
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  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader
0 Helpfuls