Finding records between two entities that are not same

[Vikas Mayur-2]

I need to find out all the records from two entities which are not same on
the basis of two primary keys present in both tables.
I was looking at the API, but could not locate any utility method. Is there
any ? I will be doing more research, meanwhile I thought it would be good to
ask if some one knows :)

Thanks,
- Vikas

[BJ Freeman]

clarifications Please.
to my knowledge no two entities should have he same information.
are these in the ofbiz or something you are working on.

Vikas Mayur sent the following on 1/5/2008 4:23 AM:
> I need to find out all the records from two entities which are not same on
> the basis of two primary keys present in both tables.
> I was looking at the API, but could not locate any utility method. Is there
> any ? I will be doing more research, meanwhile I thought it would be good to
> ask if some one knows :)
>
> Thanks,
> - Vikas
>

[David E Jones]

Vikas,

Could you describe at a higher level what you're trying to do, perhaps  
from a business process or data structure perspective type of thing?

I may be misunderstanding what you've described but it sounds like  
there could a large number of results, ie all records from either  
table that do not correspond to a record on the other (unless I'm  
incorrectly re-phrasing what you wrote).

-David


On Jan 5, 2008, at 5:23 AM, Vikas Mayur wrote:

> I need to find out all the records from two entities which are not  
> same on
> the basis of two primary keys present in both tables.
> I was looking at the API, but could not locate any utility method.  
> Is there
> any ? I will be doing more research, meanwhile I thought it would be  
> good to
> ask if some one knows :)
>
> Thanks,
> - Vikas

[Vikas Mayur-2]

David, BJ, I am sorry not to be verbose.

David, Indeed you are right.
I was reviewing a work in accounting (its a new JIra issue 1552, the patch
is not uploaded yet) that need only those records of TaxAuthority that are
not in TaxAuthorityGlAccount.
This has been done using bsh script but I am not sure there might be any
entity utility method that does this.

Thanks for yor replies,
- Vikas


On Jan 6, 2008 12:36 AM, David E Jones <[hidden email]> wrote:

>
> Vikas,
>
> Could you describe at a higher level what you're trying to do, perhaps
> from a business process or data structure perspective type of thing?
>
> I may be misunderstanding what you've described but it sounds like
> there could a large number of results, ie all records from either
> table that do not correspond to a record on the other (unless I'm
> incorrectly re-phrasing what you wrote).
>
> -David
>
>
> On Jan 5, 2008, at 5:23 AM, Vikas Mayur wrote:
>
> > I need to find out all the records from two entities which are not
> > same on
> > the basis of two primary keys present in both tables.
> > I was looking at the API, but could not locate any utility method.
> > Is there
> > any ? I will be doing more research, meanwhile I thought it would be
> > good to
> > ask if some one knows :)
> >
> > Thanks,
> > - Vikas
>
>