You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by aswath narayana <as...@gmail.com> on 2009/09/15 11:15:48 UTC
Re: How to return distinct values using findByAnd
On Tue, Sep 15, 2009 at 2:25 PM, aswath narayana <aswath.satrasala@gmail.com
> 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="<@o...@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
>
>
>
Re: How to return distinct values using findByAnd
Posted by aswath narayana <as...@gmail.com>.
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 <
pradeep.kumar@palindromesoftware.com> wrote:
> Hi,
>
> You can use : EntityUtil.getFieldListFromEntityList()
>
>
>
> On Tue, Sep 15, 2009 at 2:45 PM, aswath narayana <
> aswath.satrasala@gmail.com> wrote:
>
>> On Tue, Sep 15, 2009 at 2:25 PM, aswath narayana <
>> aswath.satrasala@gmail.com
>> > 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="<@o...@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
>
>
Re: How to return distinct values using findByAnd
Posted by S K Pradeep Kumar <pr...@palindromesoftware.com>.
Hi,
You can use : EntityUtil.getFieldListFromEntityList()
On Tue, Sep 15, 2009 at 2:45 PM, aswath narayana <aswath.satrasala@gmail.com
> wrote:
> On Tue, Sep 15, 2009 at 2:25 PM, aswath narayana <
> aswath.satrasala@gmail.com
> > 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="<@o...@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