Submitted by Armando on 2010/06/01 23:49
 
(This is an oldie, from late 2008 -- still "spring cleaning" my list  :) )
 
Hard to summarize the problem in the title.
 
Steps:
 
1- filter : category not like "*tgsPtral tgsPsupe*"
2- Grid won't show items which have nothing in the category field.
 
Not a bug per se but a bit disconcerting. No ?
Opinions ?
 
I know that the filters UI might evolve, but mentioning it just in case.
 
 
(This is similar to another issue Tom noted with Boolean fields and filtering -- not sure if it was ever put in Mantis)
 

Comments

Armando

2010/06/02 12:57

Permalink

[quote=Pierre_Admin]
Yup, this is how SQL works:
 
 
You can include nulls using the following syntax:
 
category & "" not like "*tgsPtral tgsPsupe*"
 
FYI, the & "" converts nulls to empty strings)
 
[/quote]
 
Yes, thanks, that's what I do, but I was thinking of the typical user who's not too "SQL inclined"...

Pierre_Admin

2010/06/02 13:11

Permalink

What IQ really needs, is a UI for the filter...
 

Armando

2010/06/02 13:39

Permalink

[quote=Pierre_Admin]
What IQ really needs, is a UI for the filter...
 
[/quote]
 
I think you already had ideas for that, didn't you ?
 
 
Note (2 ¢) : should we gather suggestions for such an UI? There are so many applications out there doing all kinds of filtering operations, I'm sure some are more intuitive then others... So you shouldn't have to reinvent the wheel. Unless you're already coming with some "special wheel" none of us thought about... :)
 
 

Pierre_Admin

2010/06/02 14:38

Permalink

Good idea. Users could provide screenshot of their favorite UI to do this kind of filtering
 
We could start a new thread for this.
 

jan_rifkinson

2010/06/02 15:44

Permalink

 YES. YES. YES.