How to set the number of records in the Report in the dashboard

SanikaK
Tera Contributor

I have requirement where I have created the Dashboard. In that dashboard I have added the report through widget. The Report shows the list of total numberof records in the table. I need to show only the 1st 10 records in that report. How should I configure this. 

Attaching the current dashboard for reference.

13 REPLIES 13

SanikaK
Tera Contributor

Hi All,
Thanks for your responses. But Unfortunately, It is not working.
Can anyone please guide me with some different approach?

Hi @SanikaK ,

The approach I have shared should work
please share the the screenshot of the things that you have tried 

will check and try and help you

 

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

SanikaK
Tera Contributor

Hi @Chaitanya ILCR,

Please find the attached screenshots for your reference

Hi @SanikaK ,

 

thanks for providing the screenshots

 

looks like you are using sysid is in the report's condition use IS ONE OF instead of IS

in the condition builder use sysID is On Of javascript:new sn_cim.RecordFetcher().getTop10SysIds()

on the script include there is a field called sandbox enabled please update it as true

if you don't find it in the form you will find it in the list view 

 

if you still don't find in the list view too client callable should work

 

refer screenshots from my 1st response for the same I have highlighted sandbox enabled field

 

please make the changes and if still doesn't work please share the updated screenshots

 

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

@SanikaK 

what's the business requirement here to show 1st 10 records?

What purpose it serves?

You want to see 1st 10 records created or 1st 10 records which are recently updated etc?

If my response helped please mark it correct and close the thread so that it benefits future readers.

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