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
