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

filter/distinct

User, date Message
Written by BubikolRamios
2 years ago
Category: Feature discussion
327 posts since Thu, 14 Jan 10
http://shrani.si/f/1q/11k/45gROvlw/tmp.jpg

I think having distinct check box there would be usable.
Written by BubikolRamios
2 years ago
327 posts since Thu, 14 Jan 10
That is, right to filter button.
Written by ansgar
2 years ago
4936 posts since Fri, 07 Apr 06
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.
Written by BubikolRamios
2 years ago
327 posts since Thu, 14 Jan 10
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.
Written by BubikolRamios
2 years ago
327 posts since Thu, 14 Jan 10
Most of users would appreciate this, I think, the ones that bumped at that (-:
Written by ansgar
2 years ago
4936 posts since Fri, 07 Apr 06
So, you want to remove duplicates from the filter drop down or what? This is done automatically currently. No need for a checkbox.
Written by BubikolRamios
2 years ago
327 posts since Thu, 14 Jan 10
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;


Written by ansgar
2 years ago
4936 posts since Fri, 07 Apr 06
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.