Using database view can we make all case fields in columns?

[Shreya]

Using database view we are able to merge two tables but we are not able to get the data in columns example: if we are merging time worked and case table using database view but service types in case table are not getting in columns for reporting purpose.

[Danish Bhairag2]

Hi @Shreya  ,

Is service type column present on case table?

If yes then it should definitely come.

Possible to share some snips

Thanks,

Danish

[Rampriya-S]

If Service types is different table and you are trying to get the fields by dot walk-in, it won't work. 

You have to link the service type table by merging with where clause, then you will get the fields.

Mark my answer Helpful & Accepted if I have answered your question

[AndersBGS]

Hi @Shreya  ,

Is the service types present in one of the two merging tables? Can you please share some snips of your issue?

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

Best regards

Anders