[jira] Created: (OFBIZ-2581) Update communication event status as read in CommunicationEvent entity on the basis of status updated in CommunicationEventRole entity.

[Nicolas Malin (Jira)]

Update communication event status as read in CommunicationEvent entity on the basis of status updated in CommunicationEventRole entity.
----------------------------------------------------------------------------------------------------------------------------------------

                 Key: OFBIZ-2581
                 URL: https://issues.apache.org/jira/browse/OFBIZ-2581
             Project: OFBiz
          Issue Type: Improvement
            Reporter: Ratnesh Upadhyay
            Priority: Minor


- In marketing > Reports > Email Status Report

The resultant report is not showing the status of all those communication events which are in read status. In present system it is handled in CommunicationEventRole entity. Here we have "COM_ROLE_READ" status for all those communication events that are opened by the user (read by the recipient) but when we saw those communication events from report tab they are listed as completed status, because displayed list is prepared via "CommunicationEvent "  entity and there is no any status update in case of read. (because updated in CommunicationEventRole entity)

Apart from this if we have a look on those communication events that are in bounced status due to invalid email address , are updated in CommunicationEvent entity as well.

So for updating status of a communication event as read , we wrote an ECA rule, to  update CommunicationEvent  entity's record to COM_READ ,  when the status of CommunicationEventRole is changed to  COM_ROLE_READ. So that we can get all those communication events, that has read status from "CommunicationEvent" entity.

Please suggest the proper approach from the above given solution. Or any other better approach, if any.

Thanks in advance.
--
Ratnesh Upadhyay

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-2581?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ratnesh Upadhyay updated OFBIZ-2581:
------------------------------------

        Fix Version/s: SVN trunk
    Affects Version/s: SVN trunk

> Update communication event status as read in CommunicationEvent entity on the basis of status updated in CommunicationEventRole entity.
> ----------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: OFBIZ-2581
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2581
>             Project: OFBiz
>          Issue Type: Improvement
>    Affects Versions: SVN trunk
>            Reporter: Ratnesh Upadhyay
>            Priority: Minor
>             Fix For: SVN trunk
>
>
> - In marketing > Reports > Email Status Report
> The resultant report is not showing the status of all those communication events which are in read status. In present system it is handled in CommunicationEventRole entity. Here we have "COM_ROLE_READ" status for all those communication events that are opened by the user (read by the recipient) but when we saw those communication events from report tab they are listed as completed status, because displayed list is prepared via "CommunicationEvent "  entity and there is no any status update in case of read. (because updated in CommunicationEventRole entity)
> Apart from this if we have a look on those communication events that are in bounced status due to invalid email address , are updated in CommunicationEvent entity as well.
> So for updating status of a communication event as read , we wrote an ECA rule, to  update CommunicationEvent  entity's record to COM_READ ,  when the status of CommunicationEventRole is changed to  COM_ROLE_READ. So that we can get all those communication events, that has read status from "CommunicationEvent" entity.
> Please suggest the proper approach from the above given solution. Or any other better approach, if any.
> Thanks in advance.
> --
> Ratnesh Upadhyay

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-2581?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Arun Patidar updated OFBIZ-2581:
--------------------------------

    Attachment: com-read-status-ofbiz-2581.patch

Here is a patch for this  proposed solution, I created an eca for updating status of CommunicationEvent when status of  CommunicationEventRole is set to 'READ'  status.

> Update communication event status as read in CommunicationEvent entity on the basis of status updated in CommunicationEventRole entity.
> ----------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: OFBIZ-2581
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2581
>             Project: OFBiz
>          Issue Type: Improvement
>    Affects Versions: SVN trunk
>            Reporter: Ratnesh Upadhyay
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: com-read-status-ofbiz-2581.patch
>
>
> - In marketing > Reports > Email Status Report
> The resultant report is not showing the status of all those communication events which are in read status. In present system it is handled in CommunicationEventRole entity. Here we have "COM_ROLE_READ" status for all those communication events that are opened by the user (read by the recipient) but when we saw those communication events from report tab they are listed as completed status, because displayed list is prepared via "CommunicationEvent "  entity and there is no any status update in case of read. (because updated in CommunicationEventRole entity)
> Apart from this if we have a look on those communication events that are in bounced status due to invalid email address , are updated in CommunicationEvent entity as well.
> So for updating status of a communication event as read , we wrote an ECA rule, to  update CommunicationEvent  entity's record to COM_READ ,  when the status of CommunicationEventRole is changed to  COM_ROLE_READ. So that we can get all those communication events, that has read status from "CommunicationEvent" entity.
> Please suggest the proper approach from the above given solution. Or any other better approach, if any.
> Thanks in advance.
> --
> Ratnesh Upadhyay

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-2581?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ashish Vijaywargiya reassigned OFBIZ-2581:
------------------------------------------

    Assignee: Ashish Vijaywargiya

> Update communication event status as read in CommunicationEvent entity on the basis of status updated in CommunicationEventRole entity.
> ----------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: OFBIZ-2581
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2581
>             Project: OFBiz
>          Issue Type: Improvement
>    Affects Versions: SVN trunk
>            Reporter: Ratnesh Upadhyay
>            Assignee: Ashish Vijaywargiya
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: com-read-status-ofbiz-2581.patch
>
>
> - In marketing > Reports > Email Status Report
> The resultant report is not showing the status of all those communication events which are in read status. In present system it is handled in CommunicationEventRole entity. Here we have "COM_ROLE_READ" status for all those communication events that are opened by the user (read by the recipient) but when we saw those communication events from report tab they are listed as completed status, because displayed list is prepared via "CommunicationEvent "  entity and there is no any status update in case of read. (because updated in CommunicationEventRole entity)
> Apart from this if we have a look on those communication events that are in bounced status due to invalid email address , are updated in CommunicationEvent entity as well.
> So for updating status of a communication event as read , we wrote an ECA rule, to  update CommunicationEvent  entity's record to COM_READ ,  when the status of CommunicationEventRole is changed to  COM_ROLE_READ. So that we can get all those communication events, that has read status from "CommunicationEvent" entity.
> Please suggest the proper approach from the above given solution. Or any other better approach, if any.
> Thanks in advance.
> --
> Ratnesh Upadhyay

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-2581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12717921#action_12717921 ]

Ashish Vijaywargiya commented on OFBIZ-2581:
--------------------------------------------

Ratnesh,

Can you please upload those two images that we have discussed to better understand the problem?

--
Ashish

> Update communication event status as read in CommunicationEvent entity on the basis of status updated in CommunicationEventRole entity.
> ----------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: OFBIZ-2581
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2581
>             Project: OFBiz
>          Issue Type: Improvement
>    Affects Versions: SVN trunk
>            Reporter: Ratnesh Upadhyay
>            Assignee: Ashish Vijaywargiya
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: com-read-status-ofbiz-2581.patch
>
>
> - In marketing > Reports > Email Status Report
> The resultant report is not showing the status of all those communication events which are in read status. In present system it is handled in CommunicationEventRole entity. Here we have "COM_ROLE_READ" status for all those communication events that are opened by the user (read by the recipient) but when we saw those communication events from report tab they are listed as completed status, because displayed list is prepared via "CommunicationEvent "  entity and there is no any status update in case of read. (because updated in CommunicationEventRole entity)
> Apart from this if we have a look on those communication events that are in bounced status due to invalid email address , are updated in CommunicationEvent entity as well.
> So for updating status of a communication event as read , we wrote an ECA rule, to  update CommunicationEvent  entity's record to COM_READ ,  when the status of CommunicationEventRole is changed to  COM_ROLE_READ. So that we can get all those communication events, that has read status from "CommunicationEvent" entity.
> Please suggest the proper approach from the above given solution. Or any other better approach, if any.
> Thanks in advance.
> --
> Ratnesh Upadhyay

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-2581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12717922#action_12717922 ]

Ashish Vijaywargiya commented on OFBIZ-2581:
--------------------------------------------

Hello Hans,

Can you please find some time to see what Ratnesh is proposing?
And please let us know if you have any issues with this change.

I have reviewed the things and the solution that he is proposing looks good to me.
Very soon I would like to commit the code.

Thanks in advance!
--
Ashish

> Update communication event status as read in CommunicationEvent entity on the basis of status updated in CommunicationEventRole entity.
> ----------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: OFBIZ-2581
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2581
>             Project: OFBiz
>          Issue Type: Improvement
>    Affects Versions: SVN trunk
>            Reporter: Ratnesh Upadhyay
>            Assignee: Ashish Vijaywargiya
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: com-read-status-ofbiz-2581.patch
>
>
> - In marketing > Reports > Email Status Report
> The resultant report is not showing the status of all those communication events which are in read status. In present system it is handled in CommunicationEventRole entity. Here we have "COM_ROLE_READ" status for all those communication events that are opened by the user (read by the recipient) but when we saw those communication events from report tab they are listed as completed status, because displayed list is prepared via "CommunicationEvent "  entity and there is no any status update in case of read. (because updated in CommunicationEventRole entity)
> Apart from this if we have a look on those communication events that are in bounced status due to invalid email address , are updated in CommunicationEvent entity as well.
> So for updating status of a communication event as read , we wrote an ECA rule, to  update CommunicationEvent  entity's record to COM_READ ,  when the status of CommunicationEventRole is changed to  COM_ROLE_READ. So that we can get all those communication events, that has read status from "CommunicationEvent" entity.
> Please suggest the proper approach from the above given solution. Or any other better approach, if any.
> Thanks in advance.
> --
> Ratnesh Upadhyay

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-2581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12717923#action_12717923 ]

Ratnesh Upadhyay commented on OFBIZ-2581:
-----------------------------------------

Sure, I'll upload them shortly.

Thanks !

--
Ratnesh

> Update communication event status as read in CommunicationEvent entity on the basis of status updated in CommunicationEventRole entity.
> ----------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: OFBIZ-2581
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2581
>             Project: OFBiz
>          Issue Type: Improvement
>    Affects Versions: SVN trunk
>            Reporter: Ratnesh Upadhyay
>            Assignee: Ashish Vijaywargiya
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: com-read-status-ofbiz-2581.patch
>
>
> - In marketing > Reports > Email Status Report
> The resultant report is not showing the status of all those communication events which are in read status. In present system it is handled in CommunicationEventRole entity. Here we have "COM_ROLE_READ" status for all those communication events that are opened by the user (read by the recipient) but when we saw those communication events from report tab they are listed as completed status, because displayed list is prepared via "CommunicationEvent "  entity and there is no any status update in case of read. (because updated in CommunicationEventRole entity)
> Apart from this if we have a look on those communication events that are in bounced status due to invalid email address , are updated in CommunicationEvent entity as well.
> So for updating status of a communication event as read , we wrote an ECA rule, to  update CommunicationEvent  entity's record to COM_READ ,  when the status of CommunicationEventRole is changed to  COM_ROLE_READ. So that we can get all those communication events, that has read status from "CommunicationEvent" entity.
> Please suggest the proper approach from the above given solution. Or any other better approach, if any.
> Thanks in advance.
> --
> Ratnesh Upadhyay

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-2581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12717956#action_12717956 ]

Hans Bakker commented on OFBIZ-2581:
------------------------------------

I would like to suggest to use the CommunicationEventAndRole view for this report and use the status roleStatusId. currently can have the values: entered, read and completed(closed).
Use the roleTypeId for the role of the particular party whic can be addressee, recipient, CC and BCC.

Because this status is party dependent we should not use the status on the communicationevent for this.

Please also note that the COM_READ status is removed because this status is only applicable for a certain party and not applicable for the communication event in general.

Regards,
Hans

> Update communication event status as read in CommunicationEvent entity on the basis of status updated in CommunicationEventRole entity.
> ----------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: OFBIZ-2581
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2581
>             Project: OFBiz
>          Issue Type: Improvement
>    Affects Versions: SVN trunk
>            Reporter: Ratnesh Upadhyay
>            Assignee: Ashish Vijaywargiya
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: com-read-status-ofbiz-2581.patch
>
>
> - In marketing > Reports > Email Status Report
> The resultant report is not showing the status of all those communication events which are in read status. In present system it is handled in CommunicationEventRole entity. Here we have "COM_ROLE_READ" status for all those communication events that are opened by the user (read by the recipient) but when we saw those communication events from report tab they are listed as completed status, because displayed list is prepared via "CommunicationEvent "  entity and there is no any status update in case of read. (because updated in CommunicationEventRole entity)
> Apart from this if we have a look on those communication events that are in bounced status due to invalid email address , are updated in CommunicationEvent entity as well.
> So for updating status of a communication event as read , we wrote an ECA rule, to  update CommunicationEvent  entity's record to COM_READ ,  when the status of CommunicationEventRole is changed to  COM_ROLE_READ. So that we can get all those communication events, that has read status from "CommunicationEvent" entity.
> Please suggest the proper approach from the above given solution. Or any other better approach, if any.
> Thanks in advance.
> --
> Ratnesh Upadhyay

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-2581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12717964#action_12717964 ]

Ashish Vijaywargiya commented on OFBIZ-2581:
--------------------------------------------

Thanks a lot Hans for your comment.
Ratnesh, please discuss things straight with Hans on this issue if you think otherwise or you have some more thoughts.

--
Ashish

> Update communication event status as read in CommunicationEvent entity on the basis of status updated in CommunicationEventRole entity.
> ----------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: OFBIZ-2581
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2581
>             Project: OFBiz
>          Issue Type: Improvement
>    Affects Versions: SVN trunk
>            Reporter: Ratnesh Upadhyay
>            Assignee: Ashish Vijaywargiya
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: com-read-status-ofbiz-2581.patch
>
>
> - In marketing > Reports > Email Status Report
> The resultant report is not showing the status of all those communication events which are in read status. In present system it is handled in CommunicationEventRole entity. Here we have "COM_ROLE_READ" status for all those communication events that are opened by the user (read by the recipient) but when we saw those communication events from report tab they are listed as completed status, because displayed list is prepared via "CommunicationEvent "  entity and there is no any status update in case of read. (because updated in CommunicationEventRole entity)
> Apart from this if we have a look on those communication events that are in bounced status due to invalid email address , are updated in CommunicationEvent entity as well.
> So for updating status of a communication event as read , we wrote an ECA rule, to  update CommunicationEvent  entity's record to COM_READ ,  when the status of CommunicationEventRole is changed to  COM_ROLE_READ. So that we can get all those communication events, that has read status from "CommunicationEvent" entity.
> Please suggest the proper approach from the above given solution. Or any other better approach, if any.
> Thanks in advance.
> --
> Ratnesh Upadhyay

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-2581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12718025#action_12718025 ]

Ratnesh Upadhyay commented on OFBIZ-2581:
-----------------------------------------

Hi Hans,

Thanks for your comments, we are not updating the status of parent communication event here instead of that we are just update the status of all those communication events which are associated with parties. In other words we have the same communication event records in CommunicationEvent entity as we have in CommunicationEventRole entity for the same party but in case of mark as read the status will be updated only in communicationEventRole entity. Our patch will update the status of only those events in "CommunicationEvent" entity, who have statusId as "COM_ROLE_READ" in " CommunicationEventRole" entity.

Here are the demo data which helps you to understand the scene :

<CommunicationEvent communicationEventId = "10002" communicationEventTypeId = "EMAIL_COMMUNICATION" parentCommEventId = "10000" statusId = "COM_COMPLETE" contactMechTypeId = "EMAIL_ADDRESS" partyIdFrom = "Company" partyIdTo = "10000"/>
<CommunicationEventRole communicationEventId = "10002" partyId = "10000" roleTypeId = "ADDRESSEE" contactMechId = "10000" statusId = "COM_ROLE_CREATED"/>

<!-- After execution of mare as read event -->
<CommunicationEventRole communicationEventId = "10002" partyId = "10000" roleTypeId = "ADDRESSEE" contactMechId = "10000" statusId = "COM_ROLE_READ"/>

<!-- once the status changed from any to "COM_ROLE_READ" out ECA will trigger and update the status of same communication event id in CommunicationEvent entity -->
<CommunicationEvent communicationEventId = "10002" communicationEventTypeId = "EMAIL_COMMUNICATION" parentCommEventId = "10000" statusId = "COM_READ" contactMechTypeId = "EMAIL_ADDRESS" partyIdFrom = "Company" partyIdTo = "10000"/>


What we are doing here in above two records when status updates for communicationEventId = "10002" and partyId="10000" in CommunicationEventRole entity we simply update the status in CommunicationEvent entity for the same communicationId. It means that we are updating status of communicationEventId="10002" here you can see that the partyId is also same and the old status is "COM_COMPLETE" to "COM_READ".

AFAIK, that when we send the mails from contact list It will create the different communication events for all the parties who are added as recipient in the list.
Suppose there are two parties are associated with contact list and mail is sent to contact list then three communication event records are created one is created as parent record with communicationEventTypeId = "AUTO_EMAIL_COM" and another two are having "COM_COMPLETE" so we are updating the status of another two records which are specific to party and not for the parent communication event.

Note : I looked CommunicationEventAndRole entity, It has only three status values (entered, read and completed) all these are available from roleStatusId field but the bounce status is not available there.

Suggestions are most welcome.

Thanks !

Regards,
-- Ratnesh Upadhyay

> Update communication event status as read in CommunicationEvent entity on the basis of status updated in CommunicationEventRole entity.
> ----------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: OFBIZ-2581
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2581
>             Project: OFBiz
>          Issue Type: Improvement
>    Affects Versions: SVN trunk
>            Reporter: Ratnesh Upadhyay
>            Assignee: Ashish Vijaywargiya
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: com-read-status-ofbiz-2581.patch
>
>
> - In marketing > Reports > Email Status Report
> The resultant report is not showing the status of all those communication events which are in read status. In present system it is handled in CommunicationEventRole entity. Here we have "COM_ROLE_READ" status for all those communication events that are opened by the user (read by the recipient) but when we saw those communication events from report tab they are listed as completed status, because displayed list is prepared via "CommunicationEvent "  entity and there is no any status update in case of read. (because updated in CommunicationEventRole entity)
> Apart from this if we have a look on those communication events that are in bounced status due to invalid email address , are updated in CommunicationEvent entity as well.
> So for updating status of a communication event as read , we wrote an ECA rule, to  update CommunicationEvent  entity's record to COM_READ ,  when the status of CommunicationEventRole is changed to  COM_ROLE_READ. So that we can get all those communication events, that has read status from "CommunicationEvent" entity.
> Please suggest the proper approach from the above given solution. Or any other better approach, if any.
> Thanks in advance.
> --
> Ratnesh Upadhyay

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-2581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12718314#action_12718314 ]

Mridul Pathak commented on OFBIZ-2581:
--------------------------------------

My suggestion would be to add a new column for the roleStatusId in the report and show that status in that column.  So that user can view both the statuses, CommunicationEvent and CommunicationEventRole.  And this should solve the purpose here.

Regards,
Mridul Pathak

> Update communication event status as read in CommunicationEvent entity on the basis of status updated in CommunicationEventRole entity.
> ----------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: OFBIZ-2581
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2581
>             Project: OFBiz
>          Issue Type: Improvement
>    Affects Versions: SVN trunk
>            Reporter: Ratnesh Upadhyay
>            Assignee: Ashish Vijaywargiya
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: com-read-status-ofbiz-2581.patch
>
>
> - In marketing > Reports > Email Status Report
> The resultant report is not showing the status of all those communication events which are in read status. In present system it is handled in CommunicationEventRole entity. Here we have "COM_ROLE_READ" status for all those communication events that are opened by the user (read by the recipient) but when we saw those communication events from report tab they are listed as completed status, because displayed list is prepared via "CommunicationEvent "  entity and there is no any status update in case of read. (because updated in CommunicationEventRole entity)
> Apart from this if we have a look on those communication events that are in bounced status due to invalid email address , are updated in CommunicationEvent entity as well.
> So for updating status of a communication event as read , we wrote an ECA rule, to  update CommunicationEvent  entity's record to COM_READ ,  when the status of CommunicationEventRole is changed to  COM_ROLE_READ. So that we can get all those communication events, that has read status from "CommunicationEvent" entity.
> Please suggest the proper approach from the above given solution. Or any other better approach, if any.
> Thanks in advance.
> --
> Ratnesh Upadhyay

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-2581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12718320#action_12718320 ]

Hans Bakker commented on OFBIZ-2581:
------------------------------------

i would even go one step further: for marketing it is only interesting if the message was read or not...so replace the comevent statusId with the roleStatusId

> Update communication event status as read in CommunicationEvent entity on the basis of status updated in CommunicationEventRole entity.
> ----------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: OFBIZ-2581
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2581
>             Project: OFBiz
>          Issue Type: Improvement
>    Affects Versions: SVN trunk
>            Reporter: Ratnesh Upadhyay
>            Assignee: Ashish Vijaywargiya
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: com-read-status-ofbiz-2581.patch
>
>
> - In marketing > Reports > Email Status Report
> The resultant report is not showing the status of all those communication events which are in read status. In present system it is handled in CommunicationEventRole entity. Here we have "COM_ROLE_READ" status for all those communication events that are opened by the user (read by the recipient) but when we saw those communication events from report tab they are listed as completed status, because displayed list is prepared via "CommunicationEvent "  entity and there is no any status update in case of read. (because updated in CommunicationEventRole entity)
> Apart from this if we have a look on those communication events that are in bounced status due to invalid email address , are updated in CommunicationEvent entity as well.
> So for updating status of a communication event as read , we wrote an ECA rule, to  update CommunicationEvent  entity's record to COM_READ ,  when the status of CommunicationEventRole is changed to  COM_ROLE_READ. So that we can get all those communication events, that has read status from "CommunicationEvent" entity.
> Please suggest the proper approach from the above given solution. Or any other better approach, if any.
> Thanks in advance.
> --
> Ratnesh Upadhyay

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-2581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12718322#action_12718322 ]

Mridul Pathak commented on OFBIZ-2581:
--------------------------------------

Currently status for bounced email is set in commevent status, which I think, is a interest of marketing.  So, if we remove commevent status column, user won't be able to see the list of bounced emails.  In that case, there is an option to change the functionality for bounced emails to set the status is commeventrole status, which will need to add another status type "COM_ROLE_BOUNCED" for commeventrole.  Or, for now, show both the statuses.

> Update communication event status as read in CommunicationEvent entity on the basis of status updated in CommunicationEventRole entity.
> ----------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: OFBIZ-2581
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2581
>             Project: OFBiz
>          Issue Type: Improvement
>    Affects Versions: SVN trunk
>            Reporter: Ratnesh Upadhyay
>            Assignee: Ashish Vijaywargiya
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: com-read-status-ofbiz-2581.patch
>
>
> - In marketing > Reports > Email Status Report
> The resultant report is not showing the status of all those communication events which are in read status. In present system it is handled in CommunicationEventRole entity. Here we have "COM_ROLE_READ" status for all those communication events that are opened by the user (read by the recipient) but when we saw those communication events from report tab they are listed as completed status, because displayed list is prepared via "CommunicationEvent "  entity and there is no any status update in case of read. (because updated in CommunicationEventRole entity)
> Apart from this if we have a look on those communication events that are in bounced status due to invalid email address , are updated in CommunicationEvent entity as well.
> So for updating status of a communication event as read , we wrote an ECA rule, to  update CommunicationEvent  entity's record to COM_READ ,  when the status of CommunicationEventRole is changed to  COM_ROLE_READ. So that we can get all those communication events, that has read status from "CommunicationEvent" entity.
> Please suggest the proper approach from the above given solution. Or any other better approach, if any.
> Thanks in advance.
> --
> Ratnesh Upadhyay

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-2581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12718351#action_12718351 ]

Ratnesh Upadhyay commented on OFBIZ-2581:
-----------------------------------------

Mridul's suggestion looks good to me. Hans what do you think about it.

--
Ratnesh

> Update communication event status as read in CommunicationEvent entity on the basis of status updated in CommunicationEventRole entity.
> ----------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: OFBIZ-2581
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2581
>             Project: OFBiz
>          Issue Type: Improvement
>    Affects Versions: SVN trunk
>            Reporter: Ratnesh Upadhyay
>            Assignee: Ashish Vijaywargiya
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: com-read-status-ofbiz-2581.patch
>
>
> - In marketing > Reports > Email Status Report
> The resultant report is not showing the status of all those communication events which are in read status. In present system it is handled in CommunicationEventRole entity. Here we have "COM_ROLE_READ" status for all those communication events that are opened by the user (read by the recipient) but when we saw those communication events from report tab they are listed as completed status, because displayed list is prepared via "CommunicationEvent "  entity and there is no any status update in case of read. (because updated in CommunicationEventRole entity)
> Apart from this if we have a look on those communication events that are in bounced status due to invalid email address , are updated in CommunicationEvent entity as well.
> So for updating status of a communication event as read , we wrote an ECA rule, to  update CommunicationEvent  entity's record to COM_READ ,  when the status of CommunicationEventRole is changed to  COM_ROLE_READ. So that we can get all those communication events, that has read status from "CommunicationEvent" entity.
> Please suggest the proper approach from the above given solution. Or any other better approach, if any.
> Thanks in advance.
> --
> Ratnesh Upadhyay

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-2581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12718352#action_12718352 ]

Hans Bakker commented on OFBIZ-2581:
------------------------------------

sounds fine to me....although 'bounced' should also be for a certain party and not for the commevent as a whole.....we can do that later.....

> Update communication event status as read in CommunicationEvent entity on the basis of status updated in CommunicationEventRole entity.
> ----------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: OFBIZ-2581
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2581
>             Project: OFBiz
>          Issue Type: Improvement
>    Affects Versions: SVN trunk
>            Reporter: Ratnesh Upadhyay
>            Assignee: Ashish Vijaywargiya
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: com-read-status-ofbiz-2581.patch
>
>
> - In marketing > Reports > Email Status Report
> The resultant report is not showing the status of all those communication events which are in read status. In present system it is handled in CommunicationEventRole entity. Here we have "COM_ROLE_READ" status for all those communication events that are opened by the user (read by the recipient) but when we saw those communication events from report tab they are listed as completed status, because displayed list is prepared via "CommunicationEvent "  entity and there is no any status update in case of read. (because updated in CommunicationEventRole entity)
> Apart from this if we have a look on those communication events that are in bounced status due to invalid email address , are updated in CommunicationEvent entity as well.
> So for updating status of a communication event as read , we wrote an ECA rule, to  update CommunicationEvent  entity's record to COM_READ ,  when the status of CommunicationEventRole is changed to  COM_ROLE_READ. So that we can get all those communication events, that has read status from "CommunicationEvent" entity.
> Please suggest the proper approach from the above given solution. Or any other better approach, if any.
> Thanks in advance.
> --
> Ratnesh Upadhyay

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-2581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12718353#action_12718353 ]

Divesh Dutta commented on OFBIZ-2581:
-------------------------------------

In my opinion Bounced and Read both the status should be handled in a single entity. Either in CommunicationEvent entity or CommunicationEventRole entity. And for handling both the cases I think CommunicationEvent entity is the best place to handle.

Because after reading Ratnesh's comment and looking into the patch I found that, Read status is changed only for the records which are specific to parties of contact list, and not the parent communication event.

So +1 for the Mridul and Ratnesh.

Hans can you please suggest, is there any problem in this approach.

> Update communication event status as read in CommunicationEvent entity on the basis of status updated in CommunicationEventRole entity.
> ----------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: OFBIZ-2581
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2581
>             Project: OFBiz
>          Issue Type: Improvement
>    Affects Versions: SVN trunk
>            Reporter: Ratnesh Upadhyay
>            Assignee: Ashish Vijaywargiya
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: com-read-status-ofbiz-2581.patch
>
>
> - In marketing > Reports > Email Status Report
> The resultant report is not showing the status of all those communication events which are in read status. In present system it is handled in CommunicationEventRole entity. Here we have "COM_ROLE_READ" status for all those communication events that are opened by the user (read by the recipient) but when we saw those communication events from report tab they are listed as completed status, because displayed list is prepared via "CommunicationEvent "  entity and there is no any status update in case of read. (because updated in CommunicationEventRole entity)
> Apart from this if we have a look on those communication events that are in bounced status due to invalid email address , are updated in CommunicationEvent entity as well.
> So for updating status of a communication event as read , we wrote an ECA rule, to  update CommunicationEvent  entity's record to COM_READ ,  when the status of CommunicationEventRole is changed to  COM_ROLE_READ. So that we can get all those communication events, that has read status from "CommunicationEvent" entity.
> Please suggest the proper approach from the above given solution. Or any other better approach, if any.
> Thanks in advance.
> --
> Ratnesh Upadhyay

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-2581?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

awdesh singh parihar updated OFBIZ-2581:
----------------------------------------

    Attachment: email-status-report-ofbiz-2581.patch

As per the discussions i have implemented functionality to show both status of CommunicationEvent and CommunicationEventRole , for this i am fetching the final list from view entity  CommunicationEventAndRole on the basis of selected conditions.

Thanks Ratnesh and All for finalize this issue

--
Awdesh Singh Parihar

> Update communication event status as read in CommunicationEvent entity on the basis of status updated in CommunicationEventRole entity.
> ----------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: OFBIZ-2581
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2581
>             Project: OFBiz
>          Issue Type: Improvement
>    Affects Versions: SVN trunk
>            Reporter: Ratnesh Upadhyay
>            Assignee: Ashish Vijaywargiya
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: com-read-status-ofbiz-2581.patch, email-status-report-ofbiz-2581.patch
>
>
> - In marketing > Reports > Email Status Report
> The resultant report is not showing the status of all those communication events which are in read status. In present system it is handled in CommunicationEventRole entity. Here we have "COM_ROLE_READ" status for all those communication events that are opened by the user (read by the recipient) but when we saw those communication events from report tab they are listed as completed status, because displayed list is prepared via "CommunicationEvent "  entity and there is no any status update in case of read. (because updated in CommunicationEventRole entity)
> Apart from this if we have a look on those communication events that are in bounced status due to invalid email address , are updated in CommunicationEvent entity as well.
> So for updating status of a communication event as read , we wrote an ECA rule, to  update CommunicationEvent  entity's record to COM_READ ,  when the status of CommunicationEventRole is changed to  COM_ROLE_READ. So that we can get all those communication events, that has read status from "CommunicationEvent" entity.
> Please suggest the proper approach from the above given solution. Or any other better approach, if any.
> Thanks in advance.
> --
> Ratnesh Upadhyay

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-2581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12718878#action_12718878 ]

Ashish Vijaywargiya commented on OFBIZ-2581:
--------------------------------------------

For now changes are in trunk revision at 784152.
It is giving some conflicts on releasebranch 9.04.

So as soon as we get the patch for release branch I will commit the code first and then will close this issue.

Thanks Awdesh, Ratnesh, Mridul & Hans.

--
Ashish

> Update communication event status as read in CommunicationEvent entity on the basis of status updated in CommunicationEventRole entity.
> ----------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: OFBIZ-2581
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2581
>             Project: OFBiz
>          Issue Type: Improvement
>    Affects Versions: SVN trunk
>            Reporter: Ratnesh Upadhyay
>            Assignee: Ashish Vijaywargiya
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: com-read-status-ofbiz-2581.patch, email-status-report-ofbiz-2581.patch
>
>
> - In marketing > Reports > Email Status Report
> The resultant report is not showing the status of all those communication events which are in read status. In present system it is handled in CommunicationEventRole entity. Here we have "COM_ROLE_READ" status for all those communication events that are opened by the user (read by the recipient) but when we saw those communication events from report tab they are listed as completed status, because displayed list is prepared via "CommunicationEvent "  entity and there is no any status update in case of read. (because updated in CommunicationEventRole entity)
> Apart from this if we have a look on those communication events that are in bounced status due to invalid email address , are updated in CommunicationEvent entity as well.
> So for updating status of a communication event as read , we wrote an ECA rule, to  update CommunicationEvent  entity's record to COM_READ ,  when the status of CommunicationEventRole is changed to  COM_ROLE_READ. So that we can get all those communication events, that has read status from "CommunicationEvent" entity.
> Please suggest the proper approach from the above given solution. Or any other better approach, if any.
> Thanks in advance.
> --
> Ratnesh Upadhyay

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.