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]

@shrinivasprasa1 

Because it is already added on the right slush bucket. By default escalation number is already added on the list view.

Please mark helpful/correct if my response helped you.

[shrinivasprasa1]

Hi @AndersBGS ,

i tried to dotwalking to source record but there is no option

thanks,

Shrinvasprasad

[Anubhav24]

@shrinivasprasa1 

Looks like Source Record is a Document ID field , and I think it can not be dot walked.

Please mark helpful/correct if my response helped you.

[shrinivasprasa1]

there is no option to dotwolkin to source record