what is database view in servicenow

[devservicenow k]

Using Database View i need to create a report for case ,time worked and time card .

How to do that?

[PavanK960672992 · Accepted solution]

Hi @devservicenow k ,

Refer below article it will helps you.

https://www.servicenow.com/community/developer-blog/what-is-servicenow-database-view-create-servicen...

[PavanK960672992]

Hi @devservicenow k ,

You can use the Task type field as Case to get the case data on report.

[PavanK960672992]

Hi @devservicenow k ,

if you are looking for the report from the time card(time_card) table and need only case and case task data.

On Task table Task Type field which indicates the case, casetask, incident, workorder, problem, etc..

we can filter data based the Tasktype. 

Refer below conditions on the report.