Add/edit fields in 'Data Table from URL Definition' widget

VJ4 · ‎08-14-2017

When clicking 'view all' on a request/incident widget takes you to a full list of requests/incidents, displayed in a tabular format.

This widget also has options to add more fields but that doesn't make any difference as far as I can see. There's a requirement to add an extra field, date the request was opened, and wondered how this could be implemented? I had a look at the server script and it seems to be returning only the above four fields in data.fields? Any idea how this could be extended to add the fields using instance options?

Still running Helsinki and not sure if this option is available in later versions but wanted to check if anyone had any ideas about the implementation.

Many thanks,

VJ

Rushit Patel2 · ‎08-14-2017

Hi,

widget "data table from URL defination" used "widget-data-table" widget to show the list view of any table.

it expects "view" option. if you dont pass view it takes view called "mobile" as default view(which is happening rightnow in this widget).

you need to update this view in order to show extra fields you want or pass view as option.

follow below steps to update "mobile" view for task table.

1)on side navigation type "task.list"

2)list view will open of all task. select view as "mobile"

3)right click on number colum and got to configure-->list layout.

4)add any fields you want to right side of bucket and save it.

(please mark helpful/like/correct if it helps)

View solution in original post

VJ4 · ‎08-14-2017

It's all working as expected Rushit! Thanks a lot!

VJ4 · ‎08-14-2017

On the same subject, what's the instance options > fields entry supposed to do then? I thought that's where you'd define what columns to show?

Rushit Patel2 · ‎08-14-2017

yes..instance options are configurable properties which you can read in your code and do logic accordingly...so instead of hard coding table, filter , view all those things in your code..you make them as widget options..so you can use list widget to show list of different table.

ideally if you dont pass any view, it should read list columns from widget option, but its not doing that..it is looking for view named "mobile", that's how they have coded it out of the box.

VJ4 · ‎08-14-2017

Thanks again, Rushit!

VJ4 · ‎09-22-2017

Hi Rushit,

I'm resurrecting this thread as I have another query regarding the same widget and wondered if you could help me?

As you've elaborated clearly on the first reply, I configured the mobile view to display the necessary columns but this configuration is different from user to user so some users have complained that the columns were missing. Is there a way we could specify a list of columns to show in the data table, which is the same for all Service Portal users?

Any help is greatly appreciated.

Thanks,

VJ