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

[SOLVED !] "Quick search" dialog behaves erratically & sluggishly, search grid displays with an embedded window, etc.

Submitted by Armando on 2009/08/28 23:40
1st case -
 
If focus is on the HTML pane, When I press ctrl-shift-f (my own whrtcut key to bring up the quick search dialog from the HTML pane), the dialog appears but the focus is elsewhere.
 
 
2nd case -
 
a- Set it on auto close
b- Write something in the text box
c- Select a few items (more than one) press enter :
 
dialog disappears sluggishly, reappears, stays there for a while and re-disappears.  But then, if I press ctrl-f again, it doesn't appear -- a bit like if it was still active in the background. IQ memory footprint is also much higher than usual (like 270mb...) , and CPU use too (100%).

Background Colors in Grids Don't Requires Close/Open

Submitted by CodeTRUCKER on 2009/08/28 23:22
Tools >> Options >> Grids
 
Changing the Background Colors does not change when you press "OK."  The Grid has to be Closed/Reopened.
 
Note:  If a new grid is opened, the new colors are applied, but grids that were open at the time of the color change still do not change, unless Closed/Reopened.
 
Fair Winds,
Calvin

Many items MHT content (ItemIDxxxx.MHT files links) are not searchable/findable through the Find dialogs

Submitted by Armando on 2009/08/28 19:50
Another important matter...
 
I've got more than 300 items, and probably even more (I'm discovering new ones all the time) which MHT content I cannot search, find, etc.
 
I've noticed that most of these [DON'T] have content in the itemHTMLtext  (sometimes there's no text in there but IQ seems to believe there is some, as filters like "itemHTMLtext is not null" will even show emptyish itemHTMLtext fields... anyhow).
 
That makes one very important aspect of the DB pretty unreliable : searching and finding data...
 
You could try that experiment. Write in the filter text box of the search grid (no source):
itemHTMLFile and itemhtmlText is null
and see how many items appear.