(ofbiz-framework) branch trunk 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 trunk
in repository https://gitbox.apache.org/repos/asf/ofbiz-framework.git


The following commit(s) were added to refs/heads/trunk by this push:
     new 8564e7f492 Count only open communication event roles in 
getSystemInfoStatus
8564e7f492 is described below

commit 8564e7f492759a1c1b2006ad9187bcfc024eac8e
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 9f4109c638..8c58e72afa 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()