You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "BJ Freeman (JIRA)" <ji...@apache.org> on 2006/06/29 20:52:29 UTC

[jira] Created: (OFBIZ-66) Delete botton in ListCommunications does not delete underlying data.

Delete botton in ListCommunications does not delete underlying data.
--------------------------------------------------------------------

         Key: OFBIZ-66
         URL: http://issues.apache.org/jira/browse/OFBIZ-66
     Project: The Open For Business Project
        Type: Bug

  Components: content, party  
    Versions: SVN trunk    
    Reporter: BJ Freeman


Incommingemails 
creates communications event
Communicationevent roles
and Content
all linked together.

in commforms.xml->ListPartyCommEvents()
the remove link
            <hyperlink also-hidden="false" description="${uiLabelMap.CommonDelete}" target="deletePartyCommunicationEvent?partyId=${partyId}&amp;communicationEventId=${communicationEventId}"/>

working back thru the controller  and the services I don't see any thing that deals with removing the text or attachments of an email.





-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


[jira] Commented: (OFBIZ-66) Delete botton in ListCommunications does not delete underlying data.

Posted by "BJ Freeman (JIRA)" <ji...@apache.org>.
    [ http://issues.apache.org/jira/browse/OFBIZ-66?page=comments#action_12418514 ] 

BJ Freeman commented on OFBIZ-66:
---------------------------------

correct info
ListLookupCommEvents not ListPartyCommEvents
and 
the remove is
            <hyperlink also-hidden="false" description="${uiLabelMap.CommonDelete}" target="deleteCommunicationEvent?communicationEventId=${communicationEventId}"/>



> Delete botton in ListCommunications does not delete underlying data.
> --------------------------------------------------------------------
>
>          Key: OFBIZ-66
>          URL: http://issues.apache.org/jira/browse/OFBIZ-66
>      Project: The Open For Business Project
>         Type: Bug

>   Components: content, party
>     Versions: SVN trunk
>     Reporter: BJ Freeman

>
> Incommingemails 
> creates communications event
> Communicationevent roles
> and Content
> all linked together.
> in commforms.xml->ListPartyCommEvents()
> the remove link
>             <hyperlink also-hidden="false" description="${uiLabelMap.CommonDelete}" target="deletePartyCommunicationEvent?partyId=${partyId}&amp;communicationEventId=${communicationEventId}"/>
> working back thru the controller  and the services I don't see any thing that deals with removing the text or attachments of an email.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


[jira] Closed: (OFBIZ-66) Delete botton in ListCommunications does not delete underlying data.

Posted by "Jacopo Cappellato (JIRA)" <ji...@apache.org>.
     [ http://issues.apache.org/jira/browse/OFBIZ-66?page=all ]

Jacopo Cappellato closed OFBIZ-66.
----------------------------------

    Resolution: Fixed

This has been recently discussed and fixed.


> Delete botton in ListCommunications does not delete underlying data.
> --------------------------------------------------------------------
>
>                 Key: OFBIZ-66
>                 URL: http://issues.apache.org/jira/browse/OFBIZ-66
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: Bug
>          Components: content, party
>    Affects Versions: SVN trunk
>            Reporter: BJ Freeman
>            Priority: Minor
>
> Incommingemails 
> creates communications event
> Communicationevent roles
> and Content
> all linked together.
> in commforms.xml->ListPartyCommEvents()
> the remove link
>             <hyperlink also-hidden="false" description="${uiLabelMap.CommonDelete}" target="deletePartyCommunicationEvent?partyId=${partyId}&amp;communicationEventId=${communicationEventId}"/>
> working back thru the controller  and the services I don't see any thing that deals with removing the text or attachments of an email.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Commented: (OFBIZ-66) Delete botton in ListCommunications does not delete underlying data.

Posted by "BJ Freeman (JIRA)" <ji...@apache.org>.
    [ http://issues.apache.org/jira/browse/OFBIZ-66?page=comments#action_12424303 ] 
            
BJ Freeman commented on OFBIZ-66:
---------------------------------

Ok validated that it does not delete any of the realted entities, which orphans them.

create proc #jdbc#7815(@P1 nvarchar(4000)) as SELECT COMMUNICATION_EVENT_TYPE_ID, ORIG_COMM_EVENT_ID, PARENT_COMM_EVENT_ID, STATUS_ID, CONTACT_MECH_TYPE_ID, CONTACT_MECH_ID_FROM, CONTACT_MECH_ID_TO, ROLE_TYPE_ID_FROM, ROLE_TYPE_ID_TO, PARTY_ID_FROM, PARTY_ID_TO, ENTRY_DATE, DATETIME_STARTED, DATETIME_ENDED, SUBJECT, CONTENT_MIME_TYPE_ID, CONTENT, NOTE, CONTACT_LIST_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM COMMUNICATION_EVENT WHERE COMMUNICATION_EVENT_ID=@P1

create proc #jdbc#7816(@P1 nvarchar(4000)) as DELETE FROM COMMUNICATION_EVENT WHERE COMMUNICATION_EVENT_ID=@P1

As I see it, the communication event can have many related entites. So the code has to be intelligent enough to walk thru them all. That is beyond my abilities.

So for my purposes will create a view then delete on it.
Unless I recieve other input.



> Delete botton in ListCommunications does not delete underlying data.
> --------------------------------------------------------------------
>
>                 Key: OFBIZ-66
>                 URL: http://issues.apache.org/jira/browse/OFBIZ-66
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: Bug
>          Components: content, party
>    Affects Versions: SVN trunk
>            Reporter: BJ Freeman
>
> Incommingemails 
> creates communications event
> Communicationevent roles
> and Content
> all linked together.
> in commforms.xml->ListPartyCommEvents()
> the remove link
>             <hyperlink also-hidden="false" description="${uiLabelMap.CommonDelete}" target="deletePartyCommunicationEvent?partyId=${partyId}&amp;communicationEventId=${communicationEventId}"/>
> working back thru the controller  and the services I don't see any thing that deals with removing the text or attachments of an email.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Commented: (OFBIZ-66) Delete botton in ListCommunications does not delete underlying data.

Posted by "BJ Freeman (JIRA)" <ji...@apache.org>.
    [ http://issues.apache.org/jira/browse/OFBIZ-66?page=comments#action_12423897 ] 
            
BJ Freeman commented on OFBIZ-66:
---------------------------------

I am looking at the services:

  <simple-method method-name="deleteCommunicationEvent" short-description="Delete a CommunicationEvent">
        <check-permission permission="PARTYMGR" action="_CME_DELETE">
            <fail-property resource="PartyUiLabels" property="PartyUpdateCommunicationEventPermissionError"/>
        </check-permission>
        <check-errors/>

        <entity-one entity-name="CommunicationEvent" value-name="event"/>
        <remove-value value-name="event"/>
    </simple-method>

I have not found any info that tells me if this deletes the underlying entities connected to this ID.

As far as I undertand the entity code, it does not walks the entity relationships to find ones with the communicaitonID.

So if I am one the right path, there should be list of calls to the underlying entities that are deleted before the communicationsevent is deleted.

any input is appreciated. 

> Delete botton in ListCommunications does not delete underlying data.
> --------------------------------------------------------------------
>
>                 Key: OFBIZ-66
>                 URL: http://issues.apache.org/jira/browse/OFBIZ-66
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: Bug
>          Components: content, party
>    Affects Versions: SVN trunk
>            Reporter: BJ Freeman
>
> Incommingemails 
> creates communications event
> Communicationevent roles
> and Content
> all linked together.
> in commforms.xml->ListPartyCommEvents()
> the remove link
>             <hyperlink also-hidden="false" description="${uiLabelMap.CommonDelete}" target="deletePartyCommunicationEvent?partyId=${partyId}&amp;communicationEventId=${communicationEventId}"/>
> working back thru the controller  and the services I don't see any thing that deals with removing the text or attachments of an email.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Updated: (OFBIZ-66) Delete botton in ListCommunications does not delete underlying data.

Posted by "Jacopo Cappellato (JIRA)" <ji...@apache.org>.
     [ http://issues.apache.org/jira/browse/OFBIZ-66?page=all ]

Jacopo Cappellato updated OFBIZ-66:
-----------------------------------

    Priority: Minor  (was: Major)

> Delete botton in ListCommunications does not delete underlying data.
> --------------------------------------------------------------------
>
>                 Key: OFBIZ-66
>                 URL: http://issues.apache.org/jira/browse/OFBIZ-66
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: Bug
>          Components: content, party
>    Affects Versions: SVN trunk
>            Reporter: BJ Freeman
>            Priority: Minor
>
> Incommingemails 
> creates communications event
> Communicationevent roles
> and Content
> all linked together.
> in commforms.xml->ListPartyCommEvents()
> the remove link
>             <hyperlink also-hidden="false" description="${uiLabelMap.CommonDelete}" target="deletePartyCommunicationEvent?partyId=${partyId}&amp;communicationEventId=${communicationEventId}"/>
> working back thru the controller  and the services I don't see any thing that deals with removing the text or attachments of an email.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira