ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nathan Maves" <nathan.ma...@gmail.com>
Subject Re: Group By and a Union, possible collision.
Date Tue, 10 Apr 2007 20:26:27 GMT
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.


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

View raw message