Module that will consist of 2 tables (like a database view)

[Therese Tolenti]

Hi Everyone,

Is it possible to create a module where in the list view will contain 2 joint tables just like a report with a database view as a source?

Has anyone successfully tried this? I can see that in creating a module, Only tables are available and database view are not. 

[Medi C · Accepted solution]

Hi @Therese Tolenti 

You can use the link type list of type "List of Records". Just use the database view name as a table name shown below.

In the below case- Request Approver is a database view name.

https://www.servicenow.com/community/developer-forum/database-view-as-module/m-p/1636216

[shubhamseth]

@Therese Tolenti 

Yes, you can create a module in ServiceNow where the list view displays data from two joined tables using a Database View. However, by default, database views are not available in the "Link to List View" option while creating a module.