Fetching specific table data.

[t7]

Hi Community, I am working on a story where I have one table and I need to fetch specific data and I need to display that table on portal page with that data only. For your clarity I am pasting screenshot also. In screenshot, I need to fetch the data whose product name is Wintel. PLEASE help me out.  

[Samaksh Wani · Accepted solution]

Hello @t7 

Take this as Reference and apply on your table accordingly.

HTML :-

Server Script :-

Now for your requirement you need to add one line in Server Script after line no. 2

inc_rec.addQuery('product_name', 'Wintel');

Plz Mark my Solution as Accept and Give me thumbs up, if you find it helpful.

Regards,

Samaksh

[Samaksh Wani · Accepted solution]

Hello @t7 

Plz mark my solution as Accept, If you got any help from it and close the thread.

Regards,

Samaksh

[Samaksh Wani · Accepted solution]

Hello @t7 

Take this as Reference and apply on your table accordingly.

HTML :-

Server Script :-

Now for your requirement you need to add one line in Server Script after line no. 2

inc_rec.addQuery('product_name', 'Wintel');

Plz Mark my Solution as Accept and Give me thumbs up, if you find it helpful.

Regards,

Samaksh

[Samaksh Wani · Accepted solution]

Hello @t7 

Plz mark my solution as Accept, If you got any help from it and close the thread.

Regards,

Samaksh

[amaradiswamy · Accepted solution]

Hi @t7 

There is an existing page called list which should display the list of records. Try the below URL

htpps://Instancename<replacewithcorrectvalue>.service-now.com/sp?id=list&table=tablename&filter=u_product=Wintel

You just need to pass the table name and filter via URL