Mailing-List: contact user-help@ofbiz.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@ofbiz.apache.org
Received-SPF: pass (athena.apache.org: domain of ipohfly@gmail.com designates
 209.85.160.172 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <yvh7r0rmtfs3bxr1uhu8gesr.1334516187637@email.android.com>
References: <yvh7r0rmtfs3bxr1uhu8gesr.1334516187637@email.android.com>
Date: Mon, 16 Apr 2012 12:36:28 +0800
Message-ID: 
 <CAM_vMs88xiStRmOCLxpvRxbWwsR0dWfyWj97CS-EW7s+-fOjgA@mail.gmail.com>
Subject: Re: Adding condition in DynamicViewEntity without declaring it to be
 an Alias
From: Foo Shyn Chung <ipohfly@gmail.com>
To: user@ofbiz.apache.org
Content-Type: multipart/alternative; boundary=20cf305b0ab0949b6304bdc45d02

--20cf305b0ab0949b6304bdc45d02
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

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=C3=B6vetkez=C5=91t =C3=ADrta:
>
> >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 bei=
ng
> >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 t=
o
> >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
>

--20cf305b0ab0949b6304bdc45d02--