TrackingCodeOrderReturn primary key composition inadequate

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

TrackingCodeOrderReturn primary key composition inadequate

Deepak Agarwal-2
This table has ReturnId + OrderId + TrackingCodeTypeId as it's primary key.
But a return id can have more than one order item being returned. It fails
with duplicate key exception.

Should we add OrderItemSeqId too in the key?

--
Thanks,
Deepak Agarwal,

Mobile: +91 9501190044
Reply | Threaded
Open this post in threaded view
|

Re: TrackingCodeOrderReturn primary key composition inadequate

Pierre Smits
Deepak,

If you think that this is an improvement to OFBiz, feel free to register a
JIRA for it.

With kind regards,

Pierre Smits
Reply | Threaded
Open this post in threaded view
|

Re: TrackingCodeOrderReturn primary key composition inadequate

Deepak Agarwal-2
Created: https://issues.apache.org/jira/browse/OFBIZ-5238

Thanks :)

On Sat, Jun 22, 2013 at 3:18 PM, Pierre Smits <[hidden email]>wrote:

> Deepak,
>
> If you think that this is an improvement to OFBiz, feel free to register a
> JIRA for it.
>
> With kind regards,
>
> Pierre Smits
>



--
Thanks,
Deepak Agarwal,

Mobile: +91 9501190044