Portal Popular Items Modification

Naveen87
Tera Guru

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.

Naveen87_0-1670493496035.png

 

 

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.

1 ACCEPTED SOLUTION

@Naveen87 They are showing the only 9 or any limit added in the instance options. Please data.limit variable.

 

jaheerhattiwale_0-1670509093908.png

 

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

jaheerhattiwale_1-1670509380995.png

 

 

Please mark as correct answer if this solves your issue.

Please mark the answer as correct or helpful based on impact
ServiceNow Community Rising Star, Class of 2023

View solution in original post

7 REPLIES 7

@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.

Please mark the answer as correct or helpful based on impact
ServiceNow Community Rising Star, Class of 2023

@jaheerhattiwale ,

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.

Naveen87_0-1671430302341.png

 

@Naveen87 I think the data is more and we have already done everything in script.

Please mark the answer as correct or helpful based on impact
ServiceNow Community Rising Star, Class of 2023