I was thinking about something that can done with EntityCondition. This worked for me for now. Thanks Pradeep. I will submit the patch.
On Tue, Sep 15, 2009 at 9:34 PM, S K Pradeep Kumar < [email protected]> wrote: > Hi, > > You can use : EntityUtil.getFieldListFromEntityList() > > > > On Tue, Sep 15, 2009 at 2:45 PM, aswath narayana < > [email protected]> wrote: > >> On Tue, Sep 15, 2009 at 2:25 PM, aswath narayana < >> [email protected] >> > wrote: >> >> > Hello, >> > There is a bug in orderHistory.ftl. >> > In the line 60, that is as follows >> > <#assign invoices = >> delegator.findByAnd("OrderItemBilling", >> > Static["org.ofbiz.base.util.UtilMisc"].toMap("orderId", >> > "${orderHeader.orderId}"))> >> > <#if invoices?has_content> >> > <#list invoices as invoice> >> > <a >> > href="<@ofbizUrl>invoice.pdf?invoiceId=${invoice.invoiceId}</@ofbizUrl>" >> > class="buttontext">(${invoice.invoiceId} PDF) </a> >> > </#list> >> > <#else> >> > </#if> >> > >> > Here, in the orderhistory page, there are many invoice links displayed >> (all >> > point to the same invoice). >> > The sample data in my database is as follows, and hence displays 6 >> invoices >> > for the same orderid in the orderhistory page as per the above >> > delegator.findByAnd. >> > orderid seqid invoiceid issuanceid quantity >> > amount >> > WSCO10000 00001 CI1 00001 10012 6 >> > 38.4 >> > WSCO10000 00001 CI1 00006 10013 5 >> 38.4 >> > >> > WSCO10000 00002 CI1 00011 10014 1 >> > 59.99 >> > WSCO10000 00005 CI1 00013 10017 1 >> > 59.99 >> > WSCO10000 00003 CI1 00015 10015 1 >> 1.99 >> > >> > WSCO10000 00004 CI1 00017 10016 1 >> 1.99 >> > >> > >> > In the delegate.findByAnd, I need to get only the distinct rows based on >> > orderid and invoiceid. How can it be done? >> > >> > Thanks a lot >> > -Aswath >> > >> > >> > >> > > > > -- > With regards, > S K Pradeep kumar > >
