How to create database views for reports generating

Gopal14
Tera Contributor

‎10-25-2022 11:01 PM

Hi Team,

 

I need to generate one report using two different table fields.

 

sc_req_item table(5 fields) and task_sla table(I have 2 fields)

 

For this I have created a database view, Below is my database view

Gopal14_0-1666763578097.png

 

Now I am trying to create a report, In source type I have selected table and selected my table(u_sla_7)

When I click on next it is showing No records to display,

Gopal14_1-1666763961009.png

 

Any suggestions why data is not showing, or Do I need to change anything in database views

 

@Ankur Bawiskar 

0 Helpfuls
  • 752 Views
2 REPLIES 2

suvro
Mega Sage
Mega Sage

‎10-25-2022 11:06 PM

where clause should be ts.task=sri.sys_id

0 Helpfuls

younes_sebti
Kilo Sage

‎10-25-2022 11:49 PM

I second Suvro's replies but database views doesn't like comma.

It would rather be ts_task=sri_sys_id

0 Helpfuls