ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Foo Shyn Chung <ipoh...@gmail.com>
Subject Re: Adding condition in DynamicViewEntity without declaring it to be an Alias
Date Mon, 16 Apr 2012 04:36:28 GMT
Hi,

I can't find such property, possible to point to me which attributes that
would likely to be able to configure this?

Thanx
FooShyn

On Mon, Apr 16, 2012 at 3:00 AM, <rasztasd@gmail.com> wrote:

> Hello. As far i know in an entityengine.xml there is an option for <alias>
> that is used to state "dont include in the query". I think the Dynamic
> query you can do the same.
>
> Foo Shyn Chung <ipohfly@gmail.com> a következőt írta:
>
> >Hi all,
> >
> >I have a situation whereby there's a filter i need to add into the
> >view-entity created via DynamicViewEntity, however this field is not being
> >declared with an Alias field.
> >
> >The reason for this is because my SQL is actually a group by statement
> with
> >sum in the fields to get a total sales figure. The filter i would need to
> >add in is a date field filter so that it will only selects a range of
> sales
> >date to aggregate the data. However this date will not be a part of the
> >group by clause and hence cannot be selected.
> >
> >Is there anyway that i can add in a condition without stating the field as
> >an Alias?
> >
> >Thanx
> >FooShyn
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message