The default list layout of a database view table

[Anish Reghu]

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

[Maik Skoddow]

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

[Anish Reghu · Accepted solution]

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

[Maik Skoddow]

Hi @Anish Reghu 

Sorry, but I don't understand where you took a wrong turn.

In my above screenshot you can see that you have to go to Configure -> List Layout on the database view and NOT in one of the joined tables. Nor I said anything about configuring view fields.

Kind regards
Maik

[Anish Reghu]

Hi @Maik Skoddow, all I wanted to say is - the question was misunderstood. Configure --> List layout is a known thing. I was asking when a database view is just created and the list view of the table is accessed, we see a list layout, how is that getting populated. That's all was the question. And I got the answer as explained above with the steps performed.

What you have answered is how to change the list layout from the default one to a new default view.

Hope I am making it clear. Appreciate your response, but hope I have kept it clear.

Cheers,

Anish

[Maik Skoddow]

Hi @Anish Reghu 

thank you for the explanation. I think I got your point now.

You are right. For new custom database views, the first 10 (or so) columns in alphabetical order are taken, and then you have to configure the list layout accordingly. And for baseline database views, someone from ServiceNow did that job before.

Kind regards
Maik