How to set default columns in the database views

[Anusha Anus]

I have created a database view for 3 tables. I have added required default columns in the view table fields also. 

Still I am not able to set default columns in the Database view. It is showing the four fields of 1st table only.

Thanks in advance.

Anusha.

[AndersBGS · Accepted solution]

Hi @Anusha Anus ,

Please see this community post from earlier this year which answer the question for default columns in database view: https://www.servicenow.com/community/developer-forum/can-we-configure-default-columns-in-a-database-...

As mentioned in the post: 

See screenshot, 

Use the "View Fields" related list to select the columns from that table.  do that for each table in the database view.

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

best regards

Anders