depreciate fields

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
11 messages Options
Reply | Threaded
Open this post in threaded view
|

depreciate fields

Hans Bakker
I would like to propose to depreciate the fields "partyIdFrom and
PartyIdTo and related roles and contact mech in the communication event.

All these fields fields are duplicated in the communicationEventRoles.

if no objections i will slowly phase them out...first in the entity
reference and then in forms and screens.

--
http://www.antwebsystems.com :
Quality OFBiz support for competitive rates....

Reply | Threaded
Open this post in threaded view
|

Re: depreciate fields

David E Jones-3

What about all the other places where this pattern is used, ie where  
there are partyId and/or roleTypeId fields along with a *Role entity?  
There are probably dozens of them...

The main idea of these is to have the most common, and often  
necessary, roles represented on the main entity.

Also, if we remove these fields how would we know which is the from  
and to, along with allowing various different roles for the from and  
to parties?

-David


On Mar 10, 2009, at 12:11 AM, Hans Bakker wrote:

> I would like to propose to depreciate the fields "partyIdFrom and
> PartyIdTo and related roles and contact mech in the communication  
> event.
>
> All these fields fields are duplicated in the communicationEventRoles.
>
> if no objections i will slowly phase them out...first in the entity
> reference and then in forms and screens.
>
> --
> http://www.antwebsystems.com :
> Quality OFBiz support for competitive rates....
>

Reply | Threaded
Open this post in threaded view
|

Re: depreciate fields

hans_bakker
As I said all that data is duplicated in the roles entity...
the role tells where it comes from, it can more than one destination and
can have many more participants in various other roles.....
In the case of the communication event it even contains the contactMech
used and status per participant.....vary important in an email
communication event.

The partyIdTo is even confusing if it was an email send to several
persons....

i also do not say it is applicable to other entities, only for
communication event...

Everywhere the entity Communicationevent is used it needs to it replaced
by the CommunicationEventAndRole view to have the same info.....

anybody else any opinions?

Regards,
Hans

 

On Tue, 2009-03-10 at 00:38 -0600, David E Jones wrote:

> What about all the other places where this pattern is used, ie where  
> there are partyId and/or roleTypeId fields along with a *Role entity?  
> There are probably dozens of them...
>
> The main idea of these is to have the most common, and often  
> necessary, roles represented on the main entity.
>
> Also, if we remove these fields how would we know which is the from  
> and to, along with allowing various different roles for the from and  
> to parties?
>
> -David
>
>
> On Mar 10, 2009, at 12:11 AM, Hans Bakker wrote:
>
> > I would like to propose to depreciate the fields "partyIdFrom and
> > PartyIdTo and related roles and contact mech in the communication  
> > event.
> >
> > All these fields fields are duplicated in the communicationEventRoles.
> >
> > if no objections i will slowly phase them out...first in the entity
> > reference and then in forms and screens.
> >
> > --
> > http://www.antwebsystems.com :
> > Quality OFBiz support for competitive rates....
> >
>
--
Antwebsystems.com: Quality OFBiz services for competitive rates

Reply | Threaded
Open this post in threaded view
|

Re: depreciate fields

David E Jones-3

Aside from it being easier to find the data when they are in these  
entity fields (which are always there, don't require a join/view or  
additional find, etc), not all of the data is available in the *Role  
entity.

The fields on the CommunicationEvent entity have 3 bits of information  
for each party:

1. the fact that it is the from or to party
2. the ID of the from or to party
3. the role (like customer, employee, whatever) of the from or to party

-David


On Mar 10, 2009, at 12:56 AM, Hans Bakker wrote:

> As I said all that data is duplicated in the roles entity...
> the role tells where it comes from, it can more than one destination  
> and
> can have many more participants in various other roles.....
> In the case of the communication event it even contains the  
> contactMech
> used and status per participant.....vary important in an email
> communication event.
>
> The partyIdTo is even confusing if it was an email send to several
> persons....
>
> i also do not say it is applicable to other entities, only for
> communication event...
>
> Everywhere the entity Communicationevent is used it needs to it  
> replaced
> by the CommunicationEventAndRole view to have the same info.....
>
> anybody else any opinions?
>
> Regards,
> Hans
>
>
>
> On Tue, 2009-03-10 at 00:38 -0600, David E Jones wrote:
>> What about all the other places where this pattern is used, ie where
>> there are partyId and/or roleTypeId fields along with a *Role entity?
>> There are probably dozens of them...
>>
>> The main idea of these is to have the most common, and often
>> necessary, roles represented on the main entity.
>>
>> Also, if we remove these fields how would we know which is the from
>> and to, along with allowing various different roles for the from and
>> to parties?
>>
>> -David
>>
>>
>> On Mar 10, 2009, at 12:11 AM, Hans Bakker wrote:
>>
>>> I would like to propose to depreciate the fields "partyIdFrom and
>>> PartyIdTo and related roles and contact mech in the communication
>>> event.
>>>
>>> All these fields fields are duplicated in the  
>>> communicationEventRoles.
>>>
>>> if no objections i will slowly phase them out...first in the entity
>>> reference and then in forms and screens.
>>>
>>> --
>>> http://www.antwebsystems.com :
>>> Quality OFBiz support for competitive rates....
>>>
>>
> --
> Antwebsystems.com: Quality OFBiz services for competitive rates
>

Reply | Threaded
Open this post in threaded view
|

Re: depreciate fields

hans_bakker
see below...

On Tue, 2009-03-10 at 01:15 -0600, David E Jones wrote:

> Aside from it being easier to find the data when they are in these  
> entity fields (which are always there, don't require a join/view or  
> additional find, etc), not all of the data is available in the *Role  
> entity.
>
> The fields on the CommunicationEvent entity have 3 bits of information  
> for each party:
>
> 1. the fact that it is the from or to party
> 2. the ID of the from or to party
> 3. the role (like customer, employee, whatever) of the from or to party

that is the exact info in the communicationEventRole....

>
> -David
>
>
> On Mar 10, 2009, at 12:56 AM, Hans Bakker wrote:
>
> > As I said all that data is duplicated in the roles entity...
> > the role tells where it comes from, it can more than one destination  
> > and
> > can have many more participants in various other roles.....
> > In the case of the communication event it even contains the  
> > contactMech
> > used and status per participant.....vary important in an email
> > communication event.
> >
> > The partyIdTo is even confusing if it was an email send to several
> > persons....
> >
> > i also do not say it is applicable to other entities, only for
> > communication event...
> >
> > Everywhere the entity Communicationevent is used it needs to it  
> > replaced
> > by the CommunicationEventAndRole view to have the same info.....
> >
> > anybody else any opinions?
> >
> > Regards,
> > Hans
> >
> >
> >
> > On Tue, 2009-03-10 at 00:38 -0600, David E Jones wrote:
> >> What about all the other places where this pattern is used, ie where
> >> there are partyId and/or roleTypeId fields along with a *Role entity?
> >> There are probably dozens of them...
> >>
> >> The main idea of these is to have the most common, and often
> >> necessary, roles represented on the main entity.
> >>
> >> Also, if we remove these fields how would we know which is the from
> >> and to, along with allowing various different roles for the from and
> >> to parties?
> >>
> >> -David
> >>
> >>
> >> On Mar 10, 2009, at 12:11 AM, Hans Bakker wrote:
> >>
> >>> I would like to propose to depreciate the fields "partyIdFrom and
> >>> PartyIdTo and related roles and contact mech in the communication
> >>> event.
> >>>
> >>> All these fields fields are duplicated in the  
> >>> communicationEventRoles.
> >>>
> >>> if no objections i will slowly phase them out...first in the entity
> >>> reference and then in forms and screens.
> >>>
> >>> --
> >>> http://www.antwebsystems.com :
> >>> Quality OFBiz support for competitive rates....
> >>>
> >>
> > --
> > Antwebsystems.com: Quality OFBiz services for competitive rates
> >
>
--
Antwebsystems.com: Quality OFBiz services for competitive rates

Reply | Threaded
Open this post in threaded view
|

Re: depreciate fields

David E Jones-3

On Mar 10, 2009, at 1:42 AM, Hans Bakker wrote:

> see below...
>
> On Tue, 2009-03-10 at 01:15 -0600, David E Jones wrote:
>> Aside from it being easier to find the data when they are in these
>> entity fields (which are always there, don't require a join/view or
>> additional find, etc), not all of the data is available in the *Role
>> entity.
>>
>> The fields on the CommunicationEvent entity have 3 bits of  
>> information
>> for each party:
>>
>> 1. the fact that it is the from or to party
>> 2. the ID of the from or to party
>> 3. the role (like customer, employee, whatever) of the from or to  
>> party
>
> that is the exact info in the communicationEventRole....

How would you model #1 and #3 in CommunicationEventRole? You could use  
a role that specifies from/to (which is a bit of a hack, ie that isn't  
technically a "role"), or you could specify a role that describes  
their actual role. Doing both would require 2 records with no way to  
match them up other than through the partyId... and what if other  
there are other roleTypeIds for that party, etc?

In other words, the structures are NOT equivalent. The biggest issue  
that I have is that for these fields which are common things to query  
by, display, etc it is nice not to have to do a view/join or  
additional query to get the data...

And yes, it would be nice if other's voiced their opinions. BTW, the  
data in these structures should not be duplicated and introduce  
redundancy. If the partyIdFrom/roleTypeIdFrom fields are populated the  
same data should not be in CommunicationEventRole records.

-David


>> On Mar 10, 2009, at 12:56 AM, Hans Bakker wrote:
>>
>>> As I said all that data is duplicated in the roles entity...
>>> the role tells where it comes from, it can more than one destination
>>> and
>>> can have many more participants in various other roles.....
>>> In the case of the communication event it even contains the
>>> contactMech
>>> used and status per participant.....vary important in an email
>>> communication event.
>>>
>>> The partyIdTo is even confusing if it was an email send to several
>>> persons....
>>>
>>> i also do not say it is applicable to other entities, only for
>>> communication event...
>>>
>>> Everywhere the entity Communicationevent is used it needs to it
>>> replaced
>>> by the CommunicationEventAndRole view to have the same info.....
>>>
>>> anybody else any opinions?
>>>
>>> Regards,
>>> Hans
>>>
>>>
>>>
>>> On Tue, 2009-03-10 at 00:38 -0600, David E Jones wrote:
>>>> What about all the other places where this pattern is used, ie  
>>>> where
>>>> there are partyId and/or roleTypeId fields along with a *Role  
>>>> entity?
>>>> There are probably dozens of them...
>>>>
>>>> The main idea of these is to have the most common, and often
>>>> necessary, roles represented on the main entity.
>>>>
>>>> Also, if we remove these fields how would we know which is the from
>>>> and to, along with allowing various different roles for the from  
>>>> and
>>>> to parties?
>>>>
>>>> -David
>>>>
>>>>
>>>> On Mar 10, 2009, at 12:11 AM, Hans Bakker wrote:
>>>>
>>>>> I would like to propose to depreciate the fields "partyIdFrom and
>>>>> PartyIdTo and related roles and contact mech in the communication
>>>>> event.
>>>>>
>>>>> All these fields fields are duplicated in the
>>>>> communicationEventRoles.
>>>>>
>>>>> if no objections i will slowly phase them out...first in the  
>>>>> entity
>>>>> reference and then in forms and screens.
>>>>>
>>>>> --
>>>>> http://www.antwebsystems.com :
>>>>> Quality OFBiz support for competitive rates....
>>>>>
>>>>
>>> --
>>> Antwebsystems.com: Quality OFBiz services for competitive rates
>>>
>>
> --
> Antwebsystems.com: Quality OFBiz services for competitive rates
>

Reply | Threaded
Open this post in threaded view
|

Re: depreciate fields

hans_bakker
Hi David,

thanks for the time to provide an extensive answer.
The problem i have with these fields is actually mostly showing when the
communication event is used as an email but also in the other commEvent
types.

What you describe below is theoretically completely true, however the
reality is different.

On an email, the roles of the participants as you describe them, are
normally not entered and that is why we have roles like "originator"
"recipient" and "carbon copy". Do you state that you are a 'customer'
when you write an email to your webshop if you are perhaps also employed
by them?

I even doubt when the communication event is a phonecall or actually any
other event type, even then the 'real' roles are not used....

That is why i said that the info is in the communicationEventRoles.

So what do we do, keeping the system OK in theory or do we make it
practically working?

Regards,
Hans



On Tue, 2009-03-10 at 01:57 -0600, David E Jones wrote:

> On Mar 10, 2009, at 1:42 AM, Hans Bakker wrote:
>
> > see below...
> >
> > On Tue, 2009-03-10 at 01:15 -0600, David E Jones wrote:
> >> Aside from it being easier to find the data when they are in these
> >> entity fields (which are always there, don't require a join/view or
> >> additional find, etc), not all of the data is available in the *Role
> >> entity.
> >>
> >> The fields on the CommunicationEvent entity have 3 bits of  
> >> information
> >> for each party:
> >>
> >> 1. the fact that it is the from or to party
> >> 2. the ID of the from or to party
> >> 3. the role (like customer, employee, whatever) of the from or to  
> >> party
> >
> > that is the exact info in the communicationEventRole....
>
> How would you model #1 and #3 in CommunicationEventRole? You could use  
> a role that specifies from/to (which is a bit of a hack, ie that isn't  
> technically a "role"), or you could specify a role that describes  
> their actual role. Doing both would require 2 records with no way to  
> match them up other than through the partyId... and what if other  
> there are other roleTypeIds for that party, etc?
>
> In other words, the structures are NOT equivalent. The biggest issue  
> that I have is that for these fields which are common things to query  
> by, display, etc it is nice not to have to do a view/join or  
> additional query to get the data...
>
> And yes, it would be nice if other's voiced their opinions. BTW, the  
> data in these structures should not be duplicated and introduce  
> redundancy. If the partyIdFrom/roleTypeIdFrom fields are populated the  
> same data should not be in CommunicationEventRole records.
>
> -David
>
>
> >> On Mar 10, 2009, at 12:56 AM, Hans Bakker wrote:
> >>
> >>> As I said all that data is duplicated in the roles entity...
> >>> the role tells where it comes from, it can more than one destination
> >>> and
> >>> can have many more participants in various other roles.....
> >>> In the case of the communication event it even contains the
> >>> contactMech
> >>> used and status per participant.....vary important in an email
> >>> communication event.
> >>>
> >>> The partyIdTo is even confusing if it was an email send to several
> >>> persons....
> >>>
> >>> i also do not say it is applicable to other entities, only for
> >>> communication event...
> >>>
> >>> Everywhere the entity Communicationevent is used it needs to it
> >>> replaced
> >>> by the CommunicationEventAndRole view to have the same info.....
> >>>
> >>> anybody else any opinions?
> >>>
> >>> Regards,
> >>> Hans
> >>>
> >>>
> >>>
> >>> On Tue, 2009-03-10 at 00:38 -0600, David E Jones wrote:
> >>>> What about all the other places where this pattern is used, ie  
> >>>> where
> >>>> there are partyId and/or roleTypeId fields along with a *Role  
> >>>> entity?
> >>>> There are probably dozens of them...
> >>>>
> >>>> The main idea of these is to have the most common, and often
> >>>> necessary, roles represented on the main entity.
> >>>>
> >>>> Also, if we remove these fields how would we know which is the from
> >>>> and to, along with allowing various different roles for the from  
> >>>> and
> >>>> to parties?
> >>>>
> >>>> -David
> >>>>
> >>>>
> >>>> On Mar 10, 2009, at 12:11 AM, Hans Bakker wrote:
> >>>>
> >>>>> I would like to propose to depreciate the fields "partyIdFrom and
> >>>>> PartyIdTo and related roles and contact mech in the communication
> >>>>> event.
> >>>>>
> >>>>> All these fields fields are duplicated in the
> >>>>> communicationEventRoles.
> >>>>>
> >>>>> if no objections i will slowly phase them out...first in the  
> >>>>> entity
> >>>>> reference and then in forms and screens.
> >>>>>
> >>>>> --
> >>>>> http://www.antwebsystems.com :
> >>>>> Quality OFBiz support for competitive rates....
> >>>>>
> >>>>
> >>> --
> >>> Antwebsystems.com: Quality OFBiz services for competitive rates
> >>>
> >>
> > --
> > Antwebsystems.com: Quality OFBiz services for competitive rates
> >
>
--
Antwebsystems.com: Quality OFBiz services for competitive rates

Reply | Threaded
Open this post in threaded view
|

Re: depreciate fields

David E Jones-3

On Mar 10, 2009, at 2:53 AM, Hans Bakker wrote:

> Hi David,
>
> thanks for the time to provide an extensive answer.
> The problem i have with these fields is actually mostly showing when  
> the
> communication event is used as an email but also in the other  
> commEvent
> types.
>
> What you describe below is theoretically completely true, however the
> reality is different.

That there's what I like to call a "logic trap".

> On an email, the roles of the participants as you describe them, are
> normally not entered and that is why we have roles like "originator"
> "recipient" and "carbon copy".

If we were to model this information literally I wouldn't recommend  
using the CommunicationEventRole entity, as it means something  
different. What you are describing here is the addresses on the email,  
and perhaps the Party for each (if there is a Party for the given  
address in the system).

In that case an email address (a contactMechId) would be required and  
part of the PK but the partyId would be optional, and not part of the  
PK.

That doesn't sound like a CommunicationEventRole to me...

> Do you state that you are a 'customer'
> when you write an email to your webshop if you are perhaps also  
> employed
> by them?

Even more the need for identifying the role for that particular  
communication. It can be helpful to know that a party that is both a  
customer and an employee is acting as a customer or employee for a  
particular communication.

> I even doubt when the communication event is a phonecall or actually  
> any
> other event type, even then the 'real' roles are not used....
>
> That is why i said that the info is in the communicationEventRoles.
>
> So what do we do, keeping the system OK in theory or do we make it
> practically working?

Yeah, back to the "logic trap". The implied assumption is that using  
the CommunicationEventRole entity is the only practical solution. If  
you start from there chances are you'll end up there, hence the term  
"logic trap".

It's helpful to talk about specific data you want to model, as you  
started to above and that I tried to communicate back to you and  
expand a bit there. If that isn't what you're trying to model, we  
should maybe start with establishing what it is that you're trying to  
model and then come up with the best structure for it, perhaps an  
existing one and perhaps not.

-David


> On Tue, 2009-03-10 at 01:57 -0600, David E Jones wrote:
>> On Mar 10, 2009, at 1:42 AM, Hans Bakker wrote:
>>
>>> see below...
>>>
>>> On Tue, 2009-03-10 at 01:15 -0600, David E Jones wrote:
>>>> Aside from it being easier to find the data when they are in these
>>>> entity fields (which are always there, don't require a join/view or
>>>> additional find, etc), not all of the data is available in the  
>>>> *Role
>>>> entity.
>>>>
>>>> The fields on the CommunicationEvent entity have 3 bits of
>>>> information
>>>> for each party:
>>>>
>>>> 1. the fact that it is the from or to party
>>>> 2. the ID of the from or to party
>>>> 3. the role (like customer, employee, whatever) of the from or to
>>>> party
>>>
>>> that is the exact info in the communicationEventRole....
>>
>> How would you model #1 and #3 in CommunicationEventRole? You could  
>> use
>> a role that specifies from/to (which is a bit of a hack, ie that  
>> isn't
>> technically a "role"), or you could specify a role that describes
>> their actual role. Doing both would require 2 records with no way to
>> match them up other than through the partyId... and what if other
>> there are other roleTypeIds for that party, etc?
>>
>> In other words, the structures are NOT equivalent. The biggest issue
>> that I have is that for these fields which are common things to query
>> by, display, etc it is nice not to have to do a view/join or
>> additional query to get the data...
>>
>> And yes, it would be nice if other's voiced their opinions. BTW, the
>> data in these structures should not be duplicated and introduce
>> redundancy. If the partyIdFrom/roleTypeIdFrom fields are populated  
>> the
>> same data should not be in CommunicationEventRole records.
>>
>> -David
>>
>>
>>>> On Mar 10, 2009, at 12:56 AM, Hans Bakker wrote:
>>>>
>>>>> As I said all that data is duplicated in the roles entity...
>>>>> the role tells where it comes from, it can more than one  
>>>>> destination
>>>>> and
>>>>> can have many more participants in various other roles.....
>>>>> In the case of the communication event it even contains the
>>>>> contactMech
>>>>> used and status per participant.....vary important in an email
>>>>> communication event.
>>>>>
>>>>> The partyIdTo is even confusing if it was an email send to several
>>>>> persons....
>>>>>
>>>>> i also do not say it is applicable to other entities, only for
>>>>> communication event...
>>>>>
>>>>> Everywhere the entity Communicationevent is used it needs to it
>>>>> replaced
>>>>> by the CommunicationEventAndRole view to have the same info.....
>>>>>
>>>>> anybody else any opinions?
>>>>>
>>>>> Regards,
>>>>> Hans
>>>>>
>>>>>
>>>>>
>>>>> On Tue, 2009-03-10 at 00:38 -0600, David E Jones wrote:
>>>>>> What about all the other places where this pattern is used, ie
>>>>>> where
>>>>>> there are partyId and/or roleTypeId fields along with a *Role
>>>>>> entity?
>>>>>> There are probably dozens of them...
>>>>>>
>>>>>> The main idea of these is to have the most common, and often
>>>>>> necessary, roles represented on the main entity.
>>>>>>
>>>>>> Also, if we remove these fields how would we know which is the  
>>>>>> from
>>>>>> and to, along with allowing various different roles for the from
>>>>>> and
>>>>>> to parties?
>>>>>>
>>>>>> -David
>>>>>>
>>>>>>
>>>>>> On Mar 10, 2009, at 12:11 AM, Hans Bakker wrote:
>>>>>>
>>>>>>> I would like to propose to depreciate the fields "partyIdFrom  
>>>>>>> and
>>>>>>> PartyIdTo and related roles and contact mech in the  
>>>>>>> communication
>>>>>>> event.
>>>>>>>
>>>>>>> All these fields fields are duplicated in the
>>>>>>> communicationEventRoles.
>>>>>>>
>>>>>>> if no objections i will slowly phase them out...first in the
>>>>>>> entity
>>>>>>> reference and then in forms and screens.
>>>>>>>
>>>>>>> --
>>>>>>> http://www.antwebsystems.com :
>>>>>>> Quality OFBiz support for competitive rates....
>>>>>>>
>>>>>>
>>>>> --
>>>>> Antwebsystems.com: Quality OFBiz services for competitive rates
>>>>>
>>>>
>>> --
>>> Antwebsystems.com: Quality OFBiz services for competitive rates
>>>
>>
> --
> Antwebsystems.com: Quality OFBiz services for competitive rates
>

Reply | Threaded
Open this post in threaded view
|

Re: depreciate fields

Daniel Martínez
In reply to this post by David E Jones-3
see below

David E Jones escribió:

>
> On Mar 10, 2009, at 1:42 AM, Hans Bakker wrote:
>
>> see below...
>>
>> On Tue, 2009-03-10 at 01:15 -0600, David E Jones wrote:
>>> Aside from it being easier to find the data when they are in these
>>> entity fields (which are always there, don't require a join/view or
>>> additional find, etc), not all of the data is available in the *Role
>>> entity.
>>>
>>> The fields on the CommunicationEvent entity have 3 bits of information
>>> for each party:
>>>
>>> 1. the fact that it is the from or to party
>>> 2. the ID of the from or to party
>>> 3. the role (like customer, employee, whatever) of the from or to party
>>
>> that is the exact info in the communicationEventRole....
>
> How would you model #1 and #3 in CommunicationEventRole? You could use
> a role that specifies from/to (which is a bit of a hack, ie that isn't
> technically a "role"), or you could specify a role that describes
> their actual role. Doing both would require 2 records with no way to
> match them up other than through the partyId... and what if other
> there are other roleTypeIds for that party, etc?
It seems is not a hack. In the data model book (page 61):  ... what
types of COMMUNICATION EVENT ROLES TYPEs are valid for what types of
CONTACT MECHANISM TYPEs. For instance, a "caller" and "receiver" may be
valid for a "phone" contact mechanism type, while "facilitator",
"participant", and "note taker" are valid roles for a "face-to-face
communication." (...)"

So, CALLER and RECEIVER will be valid roles for a phone call. And a mail
can have multiple RECEIVERS. And in a P2P comm you would have multiple
SENDERS and multiple RECEIVERS ;)

It may be that the problem here is that there is confusion between party
roles and communication event roles. In the book they are in different
entities but it is not like that in OfBiz. I.e. that CALLER and RECEIVER
need not to be valid roles for the parties involved in the communication
event.

In short, I agree with Hans :)
--
Daniel Martínez

>
> In other words, the structures are NOT equivalent. The biggest issue
> that I have is that for these fields which are common things to query
> by, display, etc it is nice not to have to do a view/join or
> additional query to get the data...
>
> And yes, it would be nice if other's voiced their opinions. BTW, the
> data in these structures should not be duplicated and introduce
> redundancy. If the partyIdFrom/roleTypeIdFrom fields are populated the
> same data should not be in CommunicationEventRole records.
>
> -David
>
>
>>> On Mar 10, 2009, at 12:56 AM, Hans Bakker wrote:
>>>
>>>> As I said all that data is duplicated in the roles entity...
>>>> the role tells where it comes from, it can more than one destination
>>>> and
>>>> can have many more participants in various other roles.....
>>>> In the case of the communication event it even contains the
>>>> contactMech
>>>> used and status per participant.....vary important in an email
>>>> communication event.
>>>>
>>>> The partyIdTo is even confusing if it was an email send to several
>>>> persons....
>>>>
>>>> i also do not say it is applicable to other entities, only for
>>>> communication event...
>>>>
>>>> Everywhere the entity Communicationevent is used it needs to it
>>>> replaced
>>>> by the CommunicationEventAndRole view to have the same info.....
>>>>
>>>> anybody else any opinions?
>>>>
>>>> Regards,
>>>> Hans
>>>>
>>>>
>>>>
>>>> On Tue, 2009-03-10 at 00:38 -0600, David E Jones wrote:
>>>>> What about all the other places where this pattern is used, ie where
>>>>> there are partyId and/or roleTypeId fields along with a *Role entity?
>>>>> There are probably dozens of them...
>>>>>
>>>>> The main idea of these is to have the most common, and often
>>>>> necessary, roles represented on the main entity.
>>>>>
>>>>> Also, if we remove these fields how would we know which is the from
>>>>> and to, along with allowing various different roles for the from and
>>>>> to parties?
>>>>>
>>>>> -David
>>>>>
>>>>>
>>>>> On Mar 10, 2009, at 12:11 AM, Hans Bakker wrote:
>>>>>
>>>>>> I would like to propose to depreciate the fields "partyIdFrom and
>>>>>> PartyIdTo and related roles and contact mech in the communication
>>>>>> event.
>>>>>>
>>>>>> All these fields fields are duplicated in the
>>>>>> communicationEventRoles.
>>>>>>
>>>>>> if no objections i will slowly phase them out...first in the entity
>>>>>> reference and then in forms and screens.
>>>>>>
>>>>>> --
>>>>>> http://www.antwebsystems.com :
>>>>>> Quality OFBiz support for competitive rates....
>>>>>>
>>>>>
>>>> --
>>>> Antwebsystems.com: Quality OFBiz services for competitive rates
>>>>
>>>
>> --
>> Antwebsystems.com: Quality OFBiz services for competitive rates
>>
>


--
------------------------------------------------------------------------

Soluciones de Gestión para su empresa

eBusiness, ERP, CRM

------------------------------------------------------------------------

*Daniel Martínez Martínez*

*Gerente
*C/ Julia García Boután, 29
28022 Madrid
España

       

       

E-mail: [hidden email]
<mailto:[hidden email]>
Web: *www.paradisosistemas.es <http://www.paradisosistemas.es/>
*Comercial: [hidden email] <mailto:[hidden email]>
Tel: 678416758



Reply | Threaded
Open this post in threaded view
|

Re: depreciate fields

Jacques Le Roux
Administrator
In reply to this post by David E Jones-3

From: "David E Jones" <[hidden email]>

>
> On Mar 10, 2009, at 1:42 AM, Hans Bakker wrote:
>
>> see below...
>>
>> On Tue, 2009-03-10 at 01:15 -0600, David E Jones wrote:
>>> Aside from it being easier to find the data when they are in these
>>> entity fields (which are always there, don't require a join/view or
>>> additional find, etc), not all of the data is available in the *Role
>>> entity.
>>>
>>> The fields on the CommunicationEvent entity have 3 bits of  information
>>> for each party:
>>>
>>> 1. the fact that it is the from or to party
>>> 2. the ID of the from or to party
>>> 3. the role (like customer, employee, whatever) of the from or to  party
>>
>> that is the exact info in the communicationEventRole....
>
> How would you model #1 and #3 in CommunicationEventRole? You could use  a role that specifies from/to (which is a bit of a hack,
> ie that isn't  technically a "role"), or you could specify a role that describes  their actual role. Doing both would require 2
> records with no way to  match them up other than through the partyId... and what if other  there are other roleTypeIds for that
> party, etc?
>
> In other words, the structures are NOT equivalent. The biggest issue  that I have is that for these fields which are common things
> to query  by, display, etc it is nice not to have to do a view/join or  additional query to get the data...
>
> And yes, it would be nice if other's voiced their opinions. BTW, the  data in these structures should not be duplicated and
> introduce  redundancy. If the partyIdFrom/roleTypeIdFrom fields are populated the  same data should not be in
> CommunicationEventRole records.

This the only annoying thing I see in this is. It's the responsability of the data modeler, but we should make this more clear
because it's not so obvious. Maybe comments in entities definitions ?

Jacques

> -David
>
>
>>> On Mar 10, 2009, at 12:56 AM, Hans Bakker wrote:
>>>
>>>> As I said all that data is duplicated in the roles entity...
>>>> the role tells where it comes from, it can more than one destination
>>>> and
>>>> can have many more participants in various other roles.....
>>>> In the case of the communication event it even contains the
>>>> contactMech
>>>> used and status per participant.....vary important in an email
>>>> communication event.
>>>>
>>>> The partyIdTo is even confusing if it was an email send to several
>>>> persons....
>>>>
>>>> i also do not say it is applicable to other entities, only for
>>>> communication event...
>>>>
>>>> Everywhere the entity Communicationevent is used it needs to it
>>>> replaced
>>>> by the CommunicationEventAndRole view to have the same info.....
>>>>
>>>> anybody else any opinions?
>>>>
>>>> Regards,
>>>> Hans
>>>>
>>>>
>>>>
>>>> On Tue, 2009-03-10 at 00:38 -0600, David E Jones wrote:
>>>>> What about all the other places where this pattern is used, ie  where
>>>>> there are partyId and/or roleTypeId fields along with a *Role  entity?
>>>>> There are probably dozens of them...
>>>>>
>>>>> The main idea of these is to have the most common, and often
>>>>> necessary, roles represented on the main entity.
>>>>>
>>>>> Also, if we remove these fields how would we know which is the from
>>>>> and to, along with allowing various different roles for the from  and
>>>>> to parties?
>>>>>
>>>>> -David
>>>>>
>>>>>
>>>>> On Mar 10, 2009, at 12:11 AM, Hans Bakker wrote:
>>>>>
>>>>>> I would like to propose to depreciate the fields "partyIdFrom and
>>>>>> PartyIdTo and related roles and contact mech in the communication
>>>>>> event.
>>>>>>
>>>>>> All these fields fields are duplicated in the
>>>>>> communicationEventRoles.
>>>>>>
>>>>>> if no objections i will slowly phase them out...first in the  entity
>>>>>> reference and then in forms and screens.
>>>>>>
>>>>>> --
>>>>>> http://www.antwebsystems.com :
>>>>>> Quality OFBiz support for competitive rates....
>>>>>>
>>>>>
>>>> --
>>>> Antwebsystems.com: Quality OFBiz services for competitive rates
>>>>
>>>
>> --
>> Antwebsystems.com: Quality OFBiz services for competitive rates
>>
>


Reply | Threaded
Open this post in threaded view
|

Re: depreciate fields

Stephen Rufle-2
I would like to state that I am currently using the current
CommunicationEvent system with no CommunicationEventRole rows being
created.

<CommunicationEvent communicationEventId="10000"
communicationEventTypeId="PHONE_COMMUNICATION"
statusId="COM_IN_PROGRESS" contactMechTypeId="TELECOM_NUMBER"
contactMechIdTo="CM-01" roleTypeIdFrom="SALES_REP"
roleTypeIdTo="CUSTOMER" partyIdFrom="admin" partyIdTo="PARTY-01"
entryDate="2009-02-03 08:27:28.951" subject="Color Choice"
content="Asked what color they wanted" note="Asked what color they
wanted" />

Does the real issue come up when you have an arbitrary group of parties
like in the email example with multiple recipients?


Jacques Le Roux wrote:

>
> From: "David E Jones" <[hidden email]>
>>
>> On Mar 10, 2009, at 1:42 AM, Hans Bakker wrote:
>>
>>> see below...
>>>
>>> On Tue, 2009-03-10 at 01:15 -0600, David E Jones wrote:
>>>> Aside from it being easier to find the data when they are in these
>>>> entity fields (which are always there, don't require a join/view or
>>>> additional find, etc), not all of the data is available in the *Role
>>>> entity.
>>>>
>>>> The fields on the CommunicationEvent entity have 3 bits of
>>>> information
>>>> for each party:
>>>>
>>>> 1. the fact that it is the from or to party
>>>> 2. the ID of the from or to party
>>>> 3. the role (like customer, employee, whatever) of the from or to
>>>> party
>>>
>>> that is the exact info in the communicationEventRole....
>>
>> How would you model #1 and #3 in CommunicationEventRole? You could
>> use  a role that specifies from/to (which is a bit of a hack, ie that
>> isn't  technically a "role"), or you could specify a role that
>> describes  their actual role. Doing both would require 2 records with
>> no way to  match them up other than through the partyId... and what
>> if other  there are other roleTypeIds for that party, etc?
>>
>> In other words, the structures are NOT equivalent. The biggest issue
>> that I have is that for these fields which are common things to
>> query  by, display, etc it is nice not to have to do a view/join or
>> additional query to get the data...
>>
>> And yes, it would be nice if other's voiced their opinions. BTW, the
>> data in these structures should not be duplicated and introduce
>> redundancy. If the partyIdFrom/roleTypeIdFrom fields are populated
>> the  same data should not be in CommunicationEventRole records.
>
> This the only annoying thing I see in this is. It's the responsability
> of the data modeler, but we should make this more clear because it's
> not so obvious. Maybe comments in entities definitions ?
>
> Jacques
>
>> -David
>>
>>
>>>> On Mar 10, 2009, at 12:56 AM, Hans Bakker wrote:
>>>>
>>>>> As I said all that data is duplicated in the roles entity...
>>>>> the role tells where it comes from, it can more than one destination
>>>>> and
>>>>> can have many more participants in various other roles.....
>>>>> In the case of the communication event it even contains the
>>>>> contactMech
>>>>> used and status per participant.....vary important in an email
>>>>> communication event.
>>>>>
>>>>> The partyIdTo is even confusing if it was an email send to several
>>>>> persons....
>>>>>
>>>>> i also do not say it is applicable to other entities, only for
>>>>> communication event...
>>>>>
>>>>> Everywhere the entity Communicationevent is used it needs to it
>>>>> replaced
>>>>> by the CommunicationEventAndRole view to have the same info.....
>>>>>
>>>>> anybody else any opinions?
>>>>>
>>>>> Regards,
>>>>> Hans
>>>>>
>>>>>
>>>>>
>>>>> On Tue, 2009-03-10 at 00:38 -0600, David E Jones wrote:
>>>>>> What about all the other places where this pattern is used, ie
>>>>>> where
>>>>>> there are partyId and/or roleTypeId fields along with a *Role
>>>>>> entity?
>>>>>> There are probably dozens of them...
>>>>>>
>>>>>> The main idea of these is to have the most common, and often
>>>>>> necessary, roles represented on the main entity.
>>>>>>
>>>>>> Also, if we remove these fields how would we know which is the from
>>>>>> and to, along with allowing various different roles for the from
>>>>>> and
>>>>>> to parties?
>>>>>>
>>>>>> -David
>>>>>>
>>>>>>
>>>>>> On Mar 10, 2009, at 12:11 AM, Hans Bakker wrote:
>>>>>>
>>>>>>> I would like to propose to depreciate the fields "partyIdFrom and
>>>>>>> PartyIdTo and related roles and contact mech in the communication
>>>>>>> event.
>>>>>>>
>>>>>>> All these fields fields are duplicated in the
>>>>>>> communicationEventRoles.
>>>>>>>
>>>>>>> if no objections i will slowly phase them out...first in the
>>>>>>> entity
>>>>>>> reference and then in forms and screens.
>>>>>>>
>>>>>>> --
>>>>>>> http://www.antwebsystems.com :
>>>>>>> Quality OFBiz support for competitive rates....
>>>>>>>
>>>>>>
>>>>> --
>>>>> Antwebsystems.com: Quality OFBiz services for competitive rates
>>>>>
>>>>
>>> --
>>> Antwebsystems.com: Quality OFBiz services for competitive rates
>>>
>>
>
>
>
>

--
Stephen P Rufle
[hidden email]
H1:480-626-8022
H2:480-802-7173
Yahoo IM: stephen_rufle
AOL IM: stephen1rufle