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.

No record is displayed after successfully created database view

Pra
Tera Contributor

‎05-05-2022 03:11 PM

I have created a database view. Join the employee table and the peer review table. It seems that the DB View is created successfully because i can see columns from the both tables. But when I run the report no data is displayed. 

Can anyone tell me where am I doing wrong?

find_real_file.png

Labels:
Preview file
50 KB
Preview file
50 KB
0 Helpfuls
  • 1,572 Views
5 REPLIES 5

sachin_namjoshi
Kilo Patron
Kilo Patron

‎05-05-2022 03:36 PM

Did you check join conditions of your database view?

 

Regards,

Sachin

Pra
Tera Contributor
In response to sachin_namjoshi

‎05-06-2022 09:53 AM

I checked the join condition and it is working now. I had to replace "=" sign with period in where clause and it worked. 

Thanks you much

0 Helpfuls

sachin_namjoshi
Kilo Patron
Kilo Patron
In response to Pra

‎05-06-2022 02:15 PM

Great, please mark answer as correct if your issue is resolved.

 

Regards,

Sachin

0 Helpfuls

Jyoti Ranjan Se
Tera Contributor
In response to Pra

‎07-24-2023 12:29 AM

i did but its not working

0 Helpfuls