- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-08-2022 01:57 AM
Hey Developers,
I want to Modify Popular Item Widget.
Ex:- From past 1 year (A & B) items are used often & visible under Popular Items.
I wanna know the period (1 year , 6 months, etc..). How does it gets calculated & visible under the Widget.
I also want to reduce the time span under the widget.(Once I know the OOB time span of calculation).
Ex:- If OOB is calculating the Items used in 1year then I want to reduce it to 6 or 3 months. Because it takes longer time to Load.
Can you please help me understand how this widget works & how can I achieve my task.
Thank you.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-08-2022 06:22 AM - edited 12-08-2022 06:23 AM
@Naveen87 They are showing the only 9 or any limit added in the instance options. Please data.limit variable.
Out of all the RITMs they are taking 9 or any number added in instance options. (Checking the data,limit condition in while loop)
If you want it to be within 6 months then add an extra query like below
Please mark as correct answer if this solves your issue.
ServiceNow Community Rising Star, Class of 2023
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-16-2022 01:19 AM
@Naveen87 I think we have more queries and groupBy as well. So this response time looks good for me. And don't find anything else we can add.
Please mark the answer as correct and close the thread if this solved your issue.
ServiceNow Community Rising Star, Class of 2023
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-18-2022 10:11 PM
Well, My manager isn't happy with 14sec.
He want's this in 3-5sec.
I tried to restrict the limits for 3 & commented groupBy but no luck.
Thanks for your support on this.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-18-2022 10:29 PM
@Naveen87 I think the data is more and we have already done everything in script.
ServiceNow Community Rising Star, Class of 2023