I already have a working SQL Query of what i pretend to do, i was just trying to reproduce the same result in an aggregate.The problem is that i would need this group filter to work properly in the aggregate :
Because if NumGenresForFilter = 0, i want it to show all movies, if not, only the movies with genreCount = NumGenresForFilter.
And then i discovered that in every aggregate that has groups, if you create one (group filter) with the condition "True", it doesnt show any records, i would like to know if this is suppose to happen and if i can do something about it or if there is something that i am missing.
Tell me if you need any files of my app.
Hello @Hélder Lopes
The filter condition should be as usual, Suppose your grouped attribute is genreCount and you want to filter with NumGenresForFilter,
So the condition should be -
NumGenresForFilter = 0 or genreCount = NumGenresForFilter
I hope it'll help you.
ThanksDeep
Hi,
You can add one condition for movie title or ReleaseDate
If(Client.MovieNameOrPlotFilter="",True,Movie.Title like "%"+ Client.MovieNameOrPlotFilter +"%" or Movie.PlotSummary like "%"+ Client.MovieNameOrPlotFilter +"%")
If(Client.FromDate=NullDate(), True, Movie.ReleaseDate >= Client.FromDate)