what is database view in servicenow

devservicenow k
Tera Contributor

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

How to do that?

1 ACCEPTED SOLUTION

Pavankumar_1
Mega Patron

Hi @devservicenow k ,

Refer below article it will helps you.

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

If it helps please click Accept as Solution/hit the Thumb Icon.
ServiceNow Community MVP 2024.
Thanks,
Pavankumar

View solution in original post

7 REPLIES 7

Abhijit4
Mega Sage

Database view is basically functionality in ServiceNow where you can merge multiple table into one.

 

You can find more details here Database views 

 

Those tables can be merged into one by using common field between two table so in your case you would need to find out common field between time worked and time card table. You may refer existing database views to understand more.

 

Please mark answer as Correct or Helpful based on impact.

By marking my response as correct or helpful, you contribute to helping future readers with similar issues.
Regards,
Abhijit
ServiceNow MVP

 

i am finding it something wrong

What's the output currently?

By marking my response as correct or helpful, you contribute to helping future readers with similar issues.
Regards,
Abhijit
ServiceNow MVP

I need for Time worked and case