Making VBScript conditional on item type

Submitted by gregory on 2015/03/16 11:05
I have a VBScript function called constructPath which appears in the row equation for a field called Kind as:
 
=constructPath(item, itemparent, itemgparent)
 
The script of the function is:
 
Function constructPath(item, itemparent, itemgparent)
' This function creates a Windows-like hierarchical "path".
' Ideally, this function would be coded recursively, but I cannot find a way to make InfoQube return the parent of a given item in code.
' As coded, it only permits a three level hierarchy, grandparent, parent and item.

Dim fullPath
If  itemparent = "" Then ' Item is a TLI
  fullPath = "\\" + ftrim(item) + "\\" 'Note that it's necessary to use "\\" to assign a single backslash, because backslash escapes the next character in VBScript.
Else
  if  itemgparent = "" Then

Copy/Paste items (XML) creates empty children

Submitted by Armando on 2015/03/11 17:56
Strange bug; started with last version, it seems.
 
1- open sample DB
2- in welcome grid select an item with no children
3- copy it XML (ctrl+shift+c : "selected item in XML format")
4- paste it
5- it gets pasted with a bunch of empty children.
 
Haven't noticed anything else weird happening elsewhere or in the background. It might be good to double check though...

Omnibox string search algorithm

Submitted by Armando on 2015/03/11 02:01
(last contribution for tonight)
I don't thing that "fuzzy" search is needed here, but it would be great if pattern searching wasn't limited to the beginning of strings.
The add item dialog's field drop drop down does it and it's very convenient. 
 
E.g.: ideally typing "ect" in the Omnibox would show:
 
ECT
ECT2
ECT3
project
projects
electronics
 
Instead of only
 
ECT
ECT2
ECT3
 
(And -- of course -- typing further would reduce the options as it already does)
 
That kind of string search helps when you only remember a portion of the string, not the beginning,

indicators at item level to indicate and toggle parents / siblings / children display

Submitted by jimspoon on 2015/03/09 16:41
I used Find to search for items containing a specific word in my database. I clicked the button to display the found items in the Search grid. One of the items displayed in my Search grid was TLI containing the word. A subitem of this TLI, also containing the search word, was also displayed. 19 other children of the TLI were not displayed. To see the other 19 children of the TLI (those that did not contain the search term), I discovered that I needed to turn on Full Hierarchy.

Horiztonal Map View

Submitted by David_H on 2015/03/03 03:15
Pierre, have you ever considered making the map view horizontal instead of (or in addition to) vertical?  Other than for things such as an Org chart, I've always found horizontal views much more useful for visualization information, especially on (widescreen) computer screens, and especially when it involves showing a task outline.
 
Thanks

Version 0.9.26Pre-Rel44a is now available !

Submitted by Pierre_Admin on 2015/03/02 18:01
Hi IQ Users,
 
In this release (v0.9.26PreRel44):
  • New: HTML pane: When saving content, a confirmation is now required when most of the content was deleted (because one is never too careful)
  • New: Grid: Can now select multiple columns / rows using Shift + Cursor keys !
  • Fixed: Grid: Read-only fields were not being selected when using cursor keys
  • Fixed: Fields: Limit to list was not effective when using items from SQL Select lists
  • Fixed: Grid: Pop-up editors could appear to hang the UI if the user clicks elsewhere when they are shown. They are now modal. Press Esc to dismiss
  • Fixed: Grid: In Edit > Copy, the dialog was shown even when not necessary (i.e.

[FIXED] Upgraded from REL41 to REL43 - Lost Links to All Pics

Submitted by David_H on 2015/03/02 15:45
I frequently copy and paste pics into the HTML pane, at which point I believe IQ automatically inserts the pic into the SNDB folder and creates a link to it.  There was a discussion about this in another recent thread where Pierre said he was going to change it so IQ linked to those using relative paths, which I think was already the case with REL41?
 
Regardless, now when I open the database using REL43 all the HTML pages that had pics copied into them show the typical "x" you see on a web page that shows an empty image placeholder.  So I reverted back to REL41 and all images display fine.
 
Pierre, please advise.
 
Thanks

Tree Line Style Question

Submitted by David_H on 2015/03/02 15:24
I have played with both Tree Lines and Tree Lines Style under Tools>Options>Grids.  However I don't seem to be able to duplicate the style shown in the attached screenshot from IQ documentation.  I like the bullets.  Is this possible to duplicate or is this from an older version of IQ and no longer available?
 
Thanks
 
Subscribe to