How to display the table data in ui page?

Hulk1 · ‎01-12-2021

Table data:

{
  "userId": 1,
  "id": 1,
  "title": "delectus aut autem",
  "completed": false

  "userId": 2,
  "id": 2,
  "title": "delectus aut autem",
  "completed": false

  "userId": 3,
  "id": 3,
  "title": "delectus aut autem",
  "completed": true

}

How to retrieve these data from table and show it in ui page.

asifnoor · ‎01-12-2021

Nothing. Just update the html code with the one i gave and test it. In the html in this place you need to put your table name and add conditions if any using addQuery

<g:evaluate jelly="true">
		var gr = new GlideRecord('sys_user');
		gr.setLimit(3);
		gr.query();		
	</g:evaluate>

View solution in original post

Hulk1 · ‎01-12-2021

It will helpful to this task.

https://community.servicenow.com/community?id=community_question&sys_id=9aadeb8b1ba924101e579979b04bcb8d

But i need to display all the records from the table in ui page.

Ankur Bawiskar · ‎01-12-2021

Hi,

then you can use this

HTML:

<?xml version="1.0" encoding="utf-8" ?>
<j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null">

	<iframe id="incident" src="/incident_list.do?sysparm_query=active%3Dtrue%5Eassigned_to%3Djavascript%3AgetMyAssignments()&amp;sysparm_view=" scrolling="no" style="height:500px; width:50%"></iframe>

</j:jelly>

Output:

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 10x ServiceNow MVP || ✨ ServiceNow Community Leader