"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!

[Rajanmehta]

hi Tony,

I usually take help from following site for questions related to forming URL.

http://www.w3schools.com/tags/ref_urlencode.asp

Also for OR condition, I would use ^OR   ( %5eOR)

Hope this helps.

Regards,

Rajan Mehta

[srinivasthelu · Accepted solution]

Hi Anthony,

here is the example of a page with data table with URL.

https://instnace.service-now.com/sp/?id=test&table=incident&filter=active%3Dtrue

In the above url,

test: Page ID.

sp: portal ID

table: data table parameter: table

filter:   data table parameter : filter

[tobrien]

Thanks to you both but my question is actually much simpler...

Exactly WHERE in the form do I put this text?

The Data Table From URL seems to only allow me to pick a table from a drop down list. How do I instead enter the text manually?

[srinivasthelu]

Hi Anthony,

The table name will be   picked from the URL parameters.