Hi, Anyone encountered this problem before? On Fri, Apr 13, 2012 at 7:09 PM, Foo Shyn Chung <[email protected]> wrote:
> 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 >
