Can we configure default columns in a Database view?

Mark Nguyen
Tera Guru

Hello ServiceNow community,

 

I have a visualization using a database view in the Platform Analytics Workspace. I want to configure default columns on the database view so that when a user clicks on the visualization it opens predefined columns.

MarkNguyen_0-1690498481120.png

 

Is it possible to configure default columns in a database view?

 

Thanks!
Mark

 

 

1 ACCEPTED SOLUTION

Bert_c1
Kilo Patron

Yes it is, open the Database view record, and in the View Tables list, click one to open, then specify the table columns.

 

See screenshot, 

 

Screenshot 2023-07-27 210814.png

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

View solution in original post

2 REPLIES 2

Bert_c1
Kilo Patron

Yes it is, open the Database view record, and in the View Tables list, click one to open, then specify the table columns.

 

See screenshot, 

 

Screenshot 2023-07-27 210814.png

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

Thank you!