How to create report using database view?

[shrinivasprasa1]

Hi Community,

Good day!!!

We have requirement that to create report where report contains Escalation number(which is in the sn_customerservice_escalation table)and all the all the fileds which are present in the sn_customerservice_case table,

i have created database view but i cant see data in it i hope i have missed the where cause anyone kinldy help on the condition.

thanks in advance,

shrinivasprasad

[Anubhav24]

Hi @shrinivasprasa1 ,

Under your where clause it should be est_source_record = ct_sys_id

Please mark helpful/correct if my response helped you.

[shrinivasprasa1]

Hi @Anubhav24 

i tried it by changing it to sys_id but i cant see the data.

Thanks,

Shrinivasprasad

[Anubhav24]

@shrinivasprasa1 

If you try it  under database view definition does it shows any data ?

[shrinivasprasa1]

@Anubhav24 

you can see above report it is under database view, no, i dont see any data