How to create database view for 2 tables

[Tharun_M]

Hello everyone,

I'm new to database view.

I have two tables

Table1 extends task

Table1 has 2 fields 

field1 - String (Example. Phone)

field2 - Reference to table2 (Example. Samsung)

Table2 does not extend any table

Table2 has 2 fields 

field1 - String(this is the reference record used in table1) (Example. Samsung)

field2 - String(Example. note 15)

Is there any way where I could see field1, field2 of table1 and field1 field2 of table2. (Phone Samsung Samsung Note 15) using database view?

[Anand Kumar P]

Hi @Tharun_M ,

You can take below link as reference on incident and problem table
https://www.servicenow.com/community/developer-forum/database-view-select-data-from-2-tables/m-p/135...  

Mark it as helpful and solution proposed if it serves your purpose.
Thanks,
Anand

[Sonam_Tiwari]

Hi,

Create the database view with view tables - Table1 and Table 2 and

add a left join with a where clause as - WHERE Table1<var prefix>.field2 = Table2<var prefix>.field1

Try once

[SANDEEP28]

@Tharun_M Below blog will definitely help you to understand the database view. Also see the video linked in it.

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

For your case, it is possible to create database view and get all fields of table1 & table2 in single view. You can refer below OOB database view for reference.

If I could help you with your Query then, please hit the Thumb Icon and mark as Correct !!

[AndersBGS]

Hi @Tharun_M 

According to your description, you state that table1 field2 and table2 field 1 is both string fields but also reference fields - what is correct? If it is reference fields, then you can just dot-walk without the need of a database view. Note that your table1.field2 and table2.field1 is Samsung. I would assume that there are several samsung models, so not the best option to do a database view upon. To create a Database view, you should have a 1-1 or a 1-m relationship between the two tables. 

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

Best regards

Anders