Can we use dot walking in the database view?

Go to solution
Dang Van
Tera Contributor

‎11-12-2023 05:50 AM

Hi guys! Can we use dot walking in the database view?

0 Helpfuls
  • 2,386 Views
1 ACCEPTED SOLUTION

Go to solution
Tai Vu
Kilo Patron
Kilo Patron

‎11-12-2023 08:40 PM - edited ‎11-12-2023 08:47 PM

Hi @Dang Van 

If you're trying to dot-walking a reference field in Where clause of the joining tables, it will be no you can't.

TaiVu_0-1699850285877.png

 

You can join more tables to achieve it.

Ref: Database view and Dot walking

 

Cheers,

Tai Vu

 

View solution in original post

5 REPLIES 5

Go to solution
Vamsi G
Giga Guru

‎11-13-2023 06:41 PM

Hello Dang,
Database view is basically functionality in ServiceNow all it is just a combination of more than one table so that you can integrate the data and display it in the form "where you can merge multiple tables into one" of reports .

 

yes, we can use dot-walk when you create a report based on a database view.

 

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.
 
Regards
Vamsi

 

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.