filter/distinct

http://shrani.si/f/1q/11k/45gROvlw/tmp.jpg

I think having distinct check box there would be usable.

That is, right to filter button.

A checkbox? For what purpose, man? Be sure I won't add some checkbox which does nothing :)

Also, you must describe the reason for why this would be usable. And you need to think of other users as well, if this is also helpful for all or most of them.

description:

example filter: field like '%something%'
I would get:

something
something
somethinga

and would like to see only

something
somethinga


instead going to write query, simple check box (distinct) next to filter button would do.

Most of users would appreciate this, I think, the ones that bumped at that (-:

So, you want to remove duplicates from the filter drop down or what? This is done automatically currently. No need for a checkbox.

hmm, don't know what you mean.

From upper example HSQL makes query like:
select * from table where field like '%something%' LIMIT 1000;

I would like to have:

select distinct(*) from table where field like '%something%' LIMIT 1000;

You just need to do that in the query tab. The data tab should never do such things.