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,329 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