(ofbiz-framework) branch release24.09 updated: Count only open communication event roles in getSystemInfoStatus

[mridulpathak]

This is an automated email from the ASF dual-hosted git repository.

mridulpathak pushed a commit to branch release24.09
in repository https://gitbox.apache.org/repos/asf/ofbiz-framework.git


The following commit(s) were added to refs/heads/release24.09 by this push:
     new 153645c425 Count only open communication event roles in 
getSystemInfoStatus
153645c425 is described below

commit 153645c42553c69dbba82aea41d14bfb542a5cc4
Author: Mridul Pathak <mridul...@gmail.com>
AuthorDate: Fri Oct 23 11:24:30 2026 +0530

    Count only open communication event roles in getSystemInfoStatus
    
    The minilang counted the open communication events on 
CommunicationEventRole, where statusId is the role status. The Groovy counts 
the rows of the CommunicationEventAndRole view and filtered them on statusId, 
which in that view is the status of the communication event, so completed role 
entries were counted as open. The query now filters on the roleStatusId alias 
of the view.
---
 .../org/apache/ofbiz/commonext/ofbizsetup/SystemInfoServices.groovy     | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git 
a/applications/commonext/src/main/groovy/org/apache/ofbiz/commonext/ofbizsetup/SystemInfoServices.groovy
 
b/applications/commonext/src/main/groovy/org/apache/ofbiz/commonext/ofbizsetup/SystemInfoServices.groovy
index 98f12dd3a3..edf2aaeb7a 100644
--- 
a/applications/commonext/src/main/groovy/org/apache/ofbiz/commonext/ofbizsetup/SystemInfoServices.groovy
+++ 
b/applications/commonext/src/main/groovy/org/apache/ofbiz/commonext/ofbizsetup/SystemInfoServices.groovy
@@ -87,7 +87,7 @@ Map getSystemInfoStatus() {
     List comms = from('CommunicationEventAndRole')
             .where(EntityCondition.makeCondition([
                     EntityCondition.makeCondition('partyId', 
userLogin.partyId),
-                    EntityCondition.makeCondition('statusId', 
EntityOperator.NOT_EQUAL, 'COM_ROLE_COMPLETED')
+                    EntityCondition.makeCondition('roleStatusId', 
EntityOperator.NOT_EQUAL, 'COM_ROLE_COMPLETED')
             ]))
             .orderBy('-entryDate')
             .queryList()