Hello, so I have an entity Offer with several attributes including one named Year. I have a lot of Offers(data persisted in my entity) but they all have the year 2017, 2018 and 2019. I'm displaying the information about these offers on an editable table, and I want to use the attribute Year to filter what records I'm displaying. So I want that filter to display... 2017, 2018 and 2020 however it's showing me the Years for all the attributes, so the combo box is displaying something like... 2017, 2017, 2017, 2018, 2019, 2019 instead of only showing me the 3 records I want to pick from. I thought about grouping by year which  gives me just the 3 years in the combo box but it won't let me filter the records if i do that. Please help


If you want to populate the combo with an aggregate do a group by on the year.

If you use advanced SQL you can use SELECT DISTINCT.

the combo box with the filter should not be the same aggregate that you use for editable table.

Instead in the aggregate for the editable table do a filter on the year based on the value of the combobox.