I'd further tried by stating the field i wanted to select in a fieldToSelect list and pass in the list to the method findListIteratorByCondition that i'm using to select the data, while stating the filters in the whereByCondition list. However an error "FieldName approvedDate not found for entity: DynamicViewEntity is shown instead.
Any workaround on this? Thanx FooShyn On Mon, Apr 16, 2012 at 12:36 PM, Foo Shyn Chung <[email protected]> wrote: > 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, <[email protected]> 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 <[email protected]> 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 >> > >
