distal-attribute
distal-attribute
distal-attribute
distal-attribute

filter/distinct

BubikolRamios posted 2 years ago in Feature discussion
http://shrani.si/f/1q/11k/45gROvlw/tmp.jpg

I think having distinct check box there would be usable.
BubikolRamios posted 2 years ago
That is, right to filter button.
ansgar posted 2 years ago
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.
BubikolRamios posted 2 years ago
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.
BubikolRamios posted 2 years ago
Most of users would appreciate this, I think, the ones that bumped at that (-:

ansgar posted 2 years ago
So, you want to remove duplicates from the filter drop down or what? This is done automatically currently. No need for a checkbox.
BubikolRamios posted 2 years ago
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;


ansgar posted 2 years ago
You just need to do that in the query tab. The data tab should never do such things.

Please login to leave a reply, or register at first.