Filtering integer with custom condition.

I have a category view with a filter. This filter is a dropdown with 1,2,3,4,...

If I select 2, all items with the value 2 are gonna show. But I would need to show every item with the selected value and any value lower.

If I select 1, all items with the value 1 are shown.
If I select 2, all items with the values 2 or 1 are shown,
If I select 3, all items with the values 3 or 2 or 1 are shown.
etc.

What would be the best way to achieve this?

hello did you check filtering tab for this field .. maube you can use sql custom request ?

I tried using the custom SQL, but it only affects the dropdown.

I have an idea but I'm not sure how to execute it.

If we take this as an example

I can return a custom value, can this value be an array with all the values I want.

It would kinda be like faking multiple checkboxes.

If I select 1, I return the same thing as when someone checks 1 in a checkbox. (filter_16[]=1)
If I select 2, I return the same thing as when someone checks 1 and 2 in a checkbox. (filter_16[]=1&filter_16[]=2)

If this is possible, I'm not sure which format to use when returning the value from my query.

Hello

1 reason for no such possibility of custom condition on filtering the result query with custom condition,
is because we wanted to avoid abuse that will then claim that flexicontent is "slow"

> If I select 1, I return the same thing as when someone checks 1 in a checkbox. (filter_16[]=1)
> If I select 2, I return the same thing as when someone checks 1 and 2 in a checkbox. (filter_16[]=1&filter_16[]=2)

and then it would be ??
If I select 3, I return the same thing as when someone checks 1 and 2 and 3 in a checkbox. (filter_16[]=1&filter_16[]=2&filter_16[])