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
