The requests are closed complete then also its showing the number in requests tab

divyal09
Tera Contributor

 

The requests are closed complete then also its showing the number of requests in Requests tab. How can we fix this?

For me its 3 but for other users the number is greater. Please just the way so that this issue can be fixed.

 

divyal09_1-1709628909394.png

2 REPLIES 2

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @divyal09 

 

https://www.servicenow.com/community/employee-center-forum/request-count-under-my-active-items-not-c...

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Sohithanjan G
Kilo Sage
Kilo Sage

Hi @divyal09 

 

I believe I have found a solution (Rome/San Diego) to only count active requests instead of all requests.

 

1. Open the ActivityConfigurationUtilSNC Script Include:

/sys_script_include.do?sys_id=1dc8fe7253b03010067cddeeff7b1243&sysparm_view=&sysparm_domain=null&sysparm_domain_scope=null

2. Navigate to Line 423

3. Add reqQuery.addQuery('active', true); ...Before reqQuery.query();

Final result should look like this:

        for (var i = 0; i < myReqConfigList.length && reqCount <= this.ITEM_SUMMARY_COUNT_LIMIT; i++) {
            var myReqConfigRecord = myReqConfigList[i];
            var reqQuery = this._getMyReqRecQuery(myReqConfigRecord, true);
			reqQuery.addQuery('active', true);
            reqQuery.query();
            if (reqQuery.next())
                reqCount += Number(reqQuery.getAggregate('COUNT'));

        }
        return reqCount;
    },

 

🙂

Please mark as Accepted Solution if this solves your query and HIT Helpful if you find my answer helped you. This will help other community mates too..:)