"Data table from URL" example please

[tobrien]

Hi,

We're on Helsinki.

I am crafting a Service Portal and attempting to use the Data Table From URL widget. I do not understand how to enter the url and parameters... it always wants to drop down a list of tables.

Where does the URL part come in?

I am attempting to add this to the URL:

?id=list&table=u_vtracking&filter=active%3Dtrue^short_descriptionISNOTEMPTY&spa=1&p=1

All suggestions are most welcome!

[tobrien]

Thanks, Srini but I still don't "get it" :<

Here's how the widget initially appears, and I have put it the url parms... the table 'u_vtracking' is a valid table but you can see that it says NO MATCHES FOUND

And when I click off, it reverts back to EMPTY ---

What am I missing?? I am sure it has something to do with the widget statement "... or specify on URL ..."  

Am I supposed to put the entire URL in there? Like ==>

https://<instanceName>.service-now/sp?id=list&table=u_vtracking&filter=active%3Dtrue^short_descriptionISNOTEMPTY&spa=1&p=1

[tobrien]

OK, I just figured out that this URL ***is*** the actual URL such as:

https://<instanceName>.service-now/sp?id=list&table=u_vtracking&filter=active%3Dtrue^short_descripti...

And is not part of the widget configuration at all !

So can I also specify the COLUMNS I want shown instead of the columns it is showing me by default?

[tobrien]

I am going to close this as I've discovered that I can use the data table instance widget, specify the TABLE, and COLUMNs (and their order) I want, but then simply add the filtering functionality I am after, by adding THAT to the URL such as:

https://<instanceName>service-now.com/sp?spa=1&p=1

Thanks to all

[Eli Guttman]

Hi Anthony,

Do you mind explaining how you solved it? not sure i understand from your last comment.

i can't find a way to control the columns and their order.

Thanks in advance!

[tobrien]

Sure...

I had found that the Data Table WIDGET has the ability to start with a table, apply a filter and order the columns as seen here ==>

It is the FIELDS that will drop down a list ofd the COLUMNS in the selected table and let you pick them in the order you want them presented.