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

[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

[Therese Tolenti]

I added List of records as link type then in the table I tried searching for the database view name or label but unfortunately it was not in the choices or no matches found.

[Medi C · Accepted solution]

@Therese Tolenti 

Is the DB View created in the Global scope? Could you check if the module you are creating is within the same scope as your DB View?

[Dominik Simunek]

It is possible for sure. Db views are in the list of tables as well. I used that in the past, e.g. for example for Approvals of KB articles to show also details of the article in the list.