Personalize List Columns has no columns Listed

iDNS · ‎10-24-2017

Hi,

We have a user created column in our instance & this column when accessed manually via column_name.list shows me the required Columns.

Also the Configure List Layout lets me choose the desired columns but when I click on Personalize button the slush button has no columns available.

The same appears in Reports where the slush bucket has no column names. Any suggestions?

michaelskae · ‎10-26-2017

Hi Dalvi,

Another thought... the "Personalize columns" form will be populating the available columns using an AJAX call.

When the form is loading, inspect the Network traffic of the web browser to find the xmlhttp.do calls being made to retrieve the data.

I wonder if the columns for the table are being returned in XML format, but one of the columns contains an invalid character that returns an error in the AJAX call.

If the issue was not seen before your new column was added, check the definition of the new column in sys_dictionary and ensure the Column Label and Column Name do not contain "funky" characters.

Mike

View solution in original post

michaelskae · ‎10-24-2017

Hi Dalvi,

I have seen this before when an ACL is configured with operation "add_to_list" for all tables meaning users who do not satisfy the ACL's conditions cannot personalize their list layout.

Do a search for this operation on the ACL list view:

/nav_to.do?uri=/sys_security_acl_list.do%3Fsysparm_query%3Doperation.name%253Dadd_to_list

By default, only one ACL should match this for name = wf_condition_default.*

Mike

iDNS · ‎10-24-2017

Thanks Mike for your response. I tried to hit the URL & see that below as you mentioned.

Do we expect anything else or need changes here?

This is something that I am seeing for the first time & not sure where to start

michaelskae · ‎10-24-2017

Hi Dalvi,

Thanks for the screenshot. That suggests the issue is not caused by an "add_to_list" ACL. The fact that no columns appear in the "Selected" bucket means it has not found any columns at all, even the ones already in the list view!

Does this occur for certain users, or for all users?

What happens if you edit the List Layout for the table?

Configure the list layout

Is this table custom? I wonder if there is an issue with the definition of the table - do you see any errors or warnings in the System Logs?

Mike

iDNS · ‎10-24-2017

Hi Mike,

Yes, You are right, this is a custom column & it seems to occur for all users

When I edit the list layout I see the columns in slush buckets & tried looking for any warnings/errors but none related.

Thank You