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
>
>
>
