ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tom Henricksen" <T...@A-t-g.com>
Subject RE: Group By and a Union, possible collision.
Date Tue, 10 Apr 2007 21:23:00 GMT
Would it be best to make the groupBy use two values one of the id and
one of the type?  We can make the groupBy use two values correct?

Thanks,
Tom

 

-----Original Message-----
From: Nathan Maves [mailto:nathan.maves@gmail.com] 
Sent: Tuesday, April 10, 2007 3:26 PM
To: user-java@ibatis.apache.org
Subject: Re: Group By and a Union, possible collision.

 

I would assume that it will not handle it in the way you would like.

How could it expect to know the difference.  They in-fact have the same
id

I could be wrong, so don't take my word for it.

Nathan 

On 4/10/07, Tom Henricksen <TomH@a-t-g.com> wrote:

We are using a groupBy in our query for a report.  In this query there
is a union.  The union is for two different tables and there is a
possibility of a collision of the dispensingId that we are grouping on.
So we could have dispensingId from table one of 50001 and a dispensingId
of 50001 from table two.  These shouldn't be grouped together.  Will
iBatis account for this?  And if not is there a remedy for this?

 

<resultMap class="RxReportDataRow" groupBy="dispensingId"
extends="rxReportDataRow" id="rxReportDataRowSigDisp">

 

Thanks,

Tom

 


Mime
View raw message