The default list layout of a database view table

Anish Reghu · ‎03-26-2022

Where is the default list layout of a database view table being set? When I am on the 'incident_sla' DB view table I can see only 4 columns on the default list layout. I would like to know how only 4 fields are set as the default list layout.

The Product documentation says - If no fields are defined in the View Fields list, all fields are returned. If any fields are defined, then only those fields are returned.

I see all fields from incident and task_sla available for selection on the Configure --> List Layout, but only 4 are selected, the query is on what basis are these 4 fields selected?

Cheers,

Anish

Anish Reghu · ‎04-03-2022

Thanks for bringing me on this thread Maik. I tried the following:

a) On a database view called - u_ritm_incident - I had no view fields configured for either of them initially.

b) With no view fields defined in either of the tables - the list layout that came up has the first 10 fields sorted by alphabetical order from the first View table defined.

c) If I define View field (Assigned to) on one view table -incident - Then the list layout remains the same, but if we go to the personalize list layout, one can see only the View field configured to be selected although the list shows all the fields.

d) If I add View field (Catalog) for my second View table - sc_req_item, the newly added view field is not shown on the Selected box in rather it shows in the Available section which is curtailed to show only some system fields and the configured Catalog field.

So, this tells that the default list layout is set based on:

a) Whether View fields are defined or not

b) If not, then it is the alphabetical sorted 'Name' of the columns in the first defined View table.

Please correct me if I am wrong, or else I can consider this as the answer to my query.

Cheers,

Anish

View solution in original post

Maik Skoddow · ‎03-26-2022

Hi @Anish Reghu

the columns of a database view are defined the same way as for normal tables:

Kind regards
Maik

Anish Reghu · ‎03-26-2022

Hi @Maik Skoddow, thanks that answers - how to set the list layout if someone sets it manually (even if it is the admin doing it, it is a manual work.

But here, these tables (database views) are created OOTB. So, there should be some script or configuration which is configuring the list layout. Isn't it?

Cheers,

Anish

Maik Skoddow · ‎03-26-2022

Hi @Anish Reghu

no, absolutely not.

OOTB instance are provisioned with OOTB configurations. Someone from ServiceNow did the configurations (including table list configurations) and then for all new instances just a copy of that preconfigured instance is deployed.

So why do you think there is any script? It isn't it that complicated as you suppose.

Kind regards
Maik

Maik Skoddow · ‎03-30-2022

Hi @Anish Reghu

In case you think I was able to answer your question, I would be happy if you mark the appropriate response as "correct" so that the question will appear as resolved for other users who may have a similar question in the future.

If not, please tell me what you are still missing!

Many thanks & kind regards
Maik