What clever (and simple) UI device would improve the understanding of filters interactions in a grid ?

Submitted by Armando on 2009/09/01 22:52
Filters (filter text box, alpha numeric, date, column filters), sources (source box filter) and other related  feature (hierarchy, full hierarchy, context parents, filter applies to sub items) interactions are at the root of many questions and problems users face when using IQ.
 
This is in line with point #10 in my Armando's list. in the "High Priority Features and Bug Fixes" forum.
 
[quote]
10- Simplify Filters complexities and awkwardness in some areas (source + filter + column filter = complex)

How can I Concatenate 2 fieds in the item field ?

Submitted by Armando on 2009/08/31 17:21
My inefficient way to do that now is concatenate 2 fields (using a vb script) in another field "x" which has an "a:item = "x" ".
The problem with this is that the item can't get a further update if the field x is already populated.
 
I wanted to put an equation in the item field (=NameConcatenation(contact,item,FirstName,LastName) and have a corresponding VB function like  :
 
Function NameConcatenation(contact,item,FirstName,LastName)    ' Concaténation des prénoms et noms
 
 if item = "" and contact = -1 then
   NameConcatenation = FirstName & " " & LastName
 
 elseif item <> "" and  contact = -1 and (FirstName <> "" and LastName <> "")  then

Filter criteria applies to subitems appears stuck

Submitted by jan_rifkinson on 2009/08/31 11:08
Unless I've missed a setting somewhere, it appears to me that sub-item sorting goes on in a grid whether the function is engaged or not.  I cannot demonstrate that the grid menu item "sort criteria applies to sub-items"  is not engaged so you'll have to take my word for it.
 
The image below is from my contact list
filtered for "S"
sort item asc
 
 
 
 

Saving Search as Grid

Submitted by CodeTRUCKER on 2009/08/30 16:45
Hello Folks!
 
It just occurred to me that it would be very handy to save a Quick Search as a Grid (tab). 
 
I envision a button on the top of the Quick Search dialog that says "Save Search Results as Grid."
 
I think there is a workaround that would do this with filters (?), but I was thinking of something fast and intuitive.
 
Fair winds,
Calvin