Data Table Widget

[sgmartin]

Using the Data Table widget in the Service Portal that comes with Helsinki.   Cloned it so that I could make it work for me.   I added the table name (change_request) and added the fields I wanted to see.   That however doesn't seem to be what that field means when I edit the widget.   The widget defaults to 4 fields (Number,Category,Short Description and Approval).   I did not select all of these and actually added a couple others I wanted to see but they don't show.   I love the look of the table that it presents, but it's just not acting the way I expected.   What am I missing about customizing/configuring a widget?

[Rama Chandra D]

Thank you Philip.

Regards,

Rama

[Rama Chandra D]

Hi Stanley

If you ever want to change the fields ,probably you need to change the code again.I got to this part as well while looking at the code. Since 'data.fields' is not populated before, I changed the script as,

if (!options.fields) {

  if (data.view)

  data.fields = $sp.getListColumns(data.table, data.view);

  else

  data.fields = options.field_list; //$sp.getListColumns(data.table);

  }

Regards,

Darshak

[jai_rangam]

Hey,

This post popped up when I was in a similar predicament.

I'm using a cloned version of the 'Data Table from URL Definition' widget on the 'list' page looking at the task table. I was able to define what fields I want visible on through the widget.

Where widget parameters are defined via "$sp.getListColumns(data.table , data.view)", if the view is a parameter in input is unspecified or null (inspect via console), you'll always see default columns. You can specify this manually using e.g. data.fields = 'number,sys_class_name,short_description';

This has worked for me. Great if it helps someone else.

Jai

[philengles]

Hi Stanley,
    I was wondering if you could share what your client and server script looked like as the finished product. I am also working on trying to take advantage of the

Data Table from Instance Definition widget. However I have not cracked it yet; I was wondering if you could point me in the right direction as to what I am missing for enabling this table to populate with the data that I am feeding it within the server side widgetParams. I was using the sys_user table as an example but really once I figure out the basics I should be able to figure out the rest. Thank you for the help and I really do appreciate the time you spent previously.

Best,
    Philip Engles

[sgmartin]

I have changed anything since I posted the code above.   We've noticed a number of oddities in our Dev instance.   We recently cloned our Prod instance down to Test and recently had that instance upgraded to Patch 5.   I'm going to start recreating these pages in our test instance to see if they are still acting the same.