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 ,

I am able to get some data in my report , please see below screenshots:

Database View definition:

Please mark helpful/correct if my response helped you.

[shrinivasprasa1]

Are you getting both table data in single report

number filed from sn_customerservice_escalation table and all the fileds from sn_customerservice_case table?

[Anubhav24]

@shrinivasprasa1 

I have not customised the columns , I just created a database view and ran a report on it. If you have modified the columns I would suggest to first create the view and run a report and then modify the columns. Even before creating the report you can just try the view to see if it returns any data or not. Try it and update us.

[AndersBGS]

Hi @shrinivasprasa1 ,

Why a database view? You can just create a report based on the sn_customerservice_escalation and then dot-walk the source record to have fields from the sn_customerservice_case table? This will give you what you're looking for whiteout the need of database view. 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders 

[shrinivasprasa1]

Hi @AndersBGS ,

Thanks for your reply, i tried it but i cant see escalation number in left bucket.

Thanks