Column not showing up in widget table (Instance with Table)

[Farah5]

Hi all,

I have a widget in the portal that is an Instance with Table. I am specifying the list view in the server script, and then telling it pull all the columns in that view and display those in the widget. For some reason, it's pulling all the correct columns, except for one (it was showing up before). This is not a new field, and no changes have been made to it anytime recently. I also noticed that the same is happening in other widgets, so it's not just specific to mine, and I haven't made any changes to any other widgets where this problem is occurring. 

In my script the part where I'm pulling the fields looks like this: 

data.view = "apps_unavailable";
if (data.view) {
	data.fields = $sp.getListColumns(data.table, data.view);

} 

// also tried doing, same result: 
var fieldsTEST = new GlideSPScriptable().getListColumns('x_smart_app',data.view)

console.log("Table: " + data.table + ", View: " + data.view); // it is logging the correct table and the correct view
console.log('FIELD TEST: '+fieldsTEST) // 1 missing column
console.log('sp get columns:' + $sp.getListColumns(data.table, data.view)) // 1 missing column 

Because this is happening in other widgets, I'm inclined to believe this isn't an error in the code for my widget. It seems like something more is going on. I've checked that:

- the field is active

- the field IS included in the list layout for that view

- no view rules exist on this table

- there are no ACLs that would restrict access to this field

- no UI Policies/Client Scripts that would affect visibility for this field

- no changes made to this field for over a year

[SumanKumarM]

Hello Farah,

Please try below steps,

Would you please check again in the platform whether you are able to see that column. Execute background script and see if you are able to get that column.

Please mark helpful, if above steps helps in debugging the issue.

BR,

Suman.

[Farah5]

HI Suman, 

I've tried writing a query in the widget editor to see if I can even access that field and its' values and I can. I don't get any errors. It's just not being pulled into the table widget.

[alexaria]

@Farah5 

FYI. the getListColumns() returns the default columns as you may know.

Default columns can be configured via 2 steps:

- Open your list > Cog menu > click 'Reset to column defaults' button

- Then on the list again > click 3-dot on one of the columns > Configure > List layout

I hope that fixes your issue.