Change the List Fields on a Data Table for Instance Definition

[ritaaudi]

Hi:

On the Service Portal, I can't seem to change the list fields:

If I ctrl right click, I get the following, which is for the incident table:

How can I configure the list fields for the project table?

Thank you!

[JennyHu]

Hi Rita,

You should be able to configure the fields by clicking on the pencil icon for that Data Table for Instance widget using Page Designer.  

Or try going to Instance with Tables module by typing sp_instance_table.list in the application filter and search for the "Data Table from Instance Definition" widget with the title "Projects".   Once you found the record, you can edit the fields from that Instance with Tables record.   See screenshots below.

Hope this helps.

Thanks,

Jenny

Please Hit like, Helpful or Correct depending on the impact of the response.

[ritaaudi]

Hi Jenny: The list I am using for Project is a Data Table from URL Definition not Data Table from Instance Definition. I know I can modify the fields for the Instance Definition but have not been able to do so for the URL Definition. I would use the Instance Definition, but the problem with it is that there is no search capability on top of the page that you see with the URL definition:

Any ideas on how to add the search box to the Data Table from Instance Definition or modify the list fields on Data Table from URL Definition?

Thank you!

[JennyHu]

Hi Rita,

This thread might help you Data Table From URL Definition Widget

Cheers,

Jenny

[JennyHu · Accepted solution]

Hi Rita,

I think I figured out how to configure this for the Data Table from URL Definition easily!

1. Go to the page where you have the Data Table from URL Definition widget (e.g. https://xxx.service-now.com/sp/?spa=1&table=pm_project&id=data_from_url&filter=&p=1&o=number&d=desc

2. Ctrl and right click and select Widget Options Schema

3. Click on the + icon to add a new option, and save the record.

Label:   Fields

Name:   fields

Type: string

Default Value: <comma separated list of fields>

4. Ctrl and right click to select Instance Options.   Here you should be able to see the configurable options for your widget instance.   Since we just added the Fields option, you can configure the fields you would like to display for this widget instance if you want to overwrite the default as set in the previous step.

Hope this helps!

Thanks,

Jenny

Please Hit like, Helpful or Correct depending on the impact of the response.