How to fetch the values from the custom table and show it in service portal?

Dinesh Kumar5
Kilo Contributor

Hi All,

I need to get the value of the fields from my custom table which i posted below. And i want to show the fetched values in service portal . How will i achieve this. If anyone know please let me know.

 

Thanks,

Dinesh Kumar G

 

find_real_file.png

3 REPLIES 3

veerababu
Tera Contributor

Using list page you can show custom table records on portal.

follow this url: https://<instance-name>/sp?id=list&table=<custom_table name>&filter=<query>.

asifnoor
Kilo Patron

Hi Dinesh,

In your Service portal, you can use the Data from Table widget. Drag this widget on your service portal page

and this widget will allow you to select the table and the fields that you want to show along with the filters.

There are also other widget Data from Instance Definition or Data from URL, all does more/less same.

You can play around with these widgets and can decide which widget meets your requirement and use that.

Mark the comment as a correct answer and helpful if it answers your question.

Kamlesh Pimple
Mega Expert

Hi Dinesh,

 

There is OOB widget is there you can use Data Table from instance definition.

 

find_real_file.png

 

Drag and drop this widget to a page and after that click on edit button.

Select your custom table name in option schema as follows.

 

find_real_file.png

 

Then click on Save.

Click on preview to see changes.

 

For other queries you can revert,

Hope it helps,

 

 

Regards,

Kamlesh.