15. Glossary (node 90)

ignoring param 'Title' for forum as it is not valid. Possible values are 'title,border'.
if you cant find something here, could you either make a post here requesting addition or correction, or add it to the page as a 'stub' (or full item!) . Thanks!


  • The  ' # '  column  is the first column (on the left) in a grid. It is a system-generated dynamic field and is not associated with the items - if you re-sort the grid by a different field (see sorting etc. below), the # column will be renumbered according to the new sort.
    You can't completely remove the # column, but you can reduce its width to zero, in which case it will not print or export.


  • Alphanumeric Toolbar   is typically used for address book management.  To quickly find contacts: simply click on a letter to show contacts starting with that letter.
  • Auto-edit  In Auto-edit, you can't really surf on your items, cursor movements automatically trigger an edit.  Ecco was always in auto-edit, so it is there for ex-Ecco users.
  • AutoList is a Field (Column) property. It creates a drop down list for a field, it's entries are auto-generated based on the previous field values you have entered or, if a new Field: as you add words to the field, they will then be added to the drop-down list.
    Under Menu>View>Manage Fields [select your Field] >Editor or right click Field/Column header and select Manage Fields/etc.


  • Backup  InfoQube does 3 types of backups (Ecco did only one).
    1. Autobackups are done every x minutes. Have .SNBKA extensions. If Timestamp backups is checked (Tools > Options > This File), each backup creates a new file, with the date/time in the file name.
    2. Manual backups are done on command. Have .SNBKM
    3. On close backups use rotating numbers .SNBK1 and .SNBK2 (where .SNDB1 is 1 day old and .SNDB2 is 2 days old)
      See 10.09 Backup your database, Encryption


  • Column Context Menu  the menu that shows when you right click on a column header. See Modifying the Column Context Menu:

  • Column Context Toolbar  the toolbar related to the Column Context Menu. See Modifying the Column Context Menu:

  • Column Filter (Field Filter)  filters (searches) contents of a field/column within a grid. Access via Menu: Grid > Column Filter Buttons > Show Column Filter, or, right click column header and select Filter Column, or Ctrl+G shortcut activates the Column/Field filter.
    Related settings:- Menu: Grid > Column Filter Buttons > Filter as you type
    For more info see "Column Filter Buttons" on page
    Nonexistent node nid: 855.


  • Compact  - you can manually compact your database file - Menu: Tools > Database Management > Compact or you can choose to automatically compact file on programme close (this option has to be enabled for each file): Menu: Tools > Options > This File > Data Storage > Compact on Program Close.
  • Context Parent is a Parent that should not be displayed in the grid, as it does not belong there (based on the grid source), but nevertheless it is displayed (in blue) to help get the item context. Click: Menu: Grid > Context Parents to turn on/off display (to learn about other ways to display a Context Parent see....) The term Context Parent makes sense only in reference to a particular grid, the same parent may be a Context Parent in one grid and not a Context Parent in another (because it meets the criteria of the grid source for one grid but not for another - see definition of grid source). Apart from a particular grid a Context parent is just a parent.


  • DateFilter Toolbar
  • Default Font [Temporary] to change default font in the HTML pane: Find the file NewHTML.htm, in AppFiles folder in the installation folder. This file serves as a template for all new content. Open it in a text editor (Notepad etc. - Right-Click > Open With > ). Change the two instances of "MS Sans Serif" to the font name of your choice. This is a temporary solution until it is possible for users to choose/edit their own templates and/or CSS.
  • Default sort is done via the source-bar  (Alt+S to activate). On the right hand side is the sortbox with the A-Z button - ensure it's not greyed out by clicking A-Z button. Type in the name of column/field you want to sort by - click the refresh button to the right. This is now default sort for this grid - i.e. everytime you refresh it will default to this sort.
    Check/decide if you want sorting to affect sub-items under  Menu > Grids > Sort Criteria applies to sub-items
    For some more info see under heading "The Grids" in 2. An overview of IQ's main components: Items, Fields, Grids, Forms, Panes and see SortBox and Sortbar below


  • Encryption Security is based on 2 points (required since IQ used JET as storage and any ODBC app can open JET files)
    • 1. Encryption: This prevents access to information by bypassing the JET ODBC driver (notepad, hex viewer, etc) by encrypting the content. JET will encrypt/decrypt on the fly, so normal users don't see a difference (except for 15% reduction of speed). When you entcrypt your file it creates a new file FileName.Entcrypt.SNDB. After encrypting (and closing down IQ/InfoQube) you should:
      - Backup your original file somewhere safe, then:
      - Rename your encrypted file to the old name (recommended)
    • 2. Password: This limits file access to users that know the password. All apps requesting access to the information (e.g. IQ but also Word, Excel, etc) will prompt for the password.
    • You can use 1 or 2, but only the combination of the two provides full protection. If using 1+2, then remember to encrypt before setting the password
    • Both settings are available under Menu>Tools>Database Management>
    • MHT content is stored in a folder in the same location as the IQ file - it can be encrypted using Windows folder encryption (which is totally distinct from IQ encryption) - though this hasn't been tested.


  • Field a Field is a column as shown in a grid. Fields can be text, numerical, date, yes/no tick-box, and drop-down. To create a new Field: Menu>View>Manage Fields or right-click a column header in grid and select Manage Fields - then click New. All Fields are shown in this window and can be modified/edited here - don't forget to click Save after each edit (unless auto-save, right beside the Save button, is checked). There is a list of available Fields in the Properties Pane (some of them might not be there though, if their Hide in Info. Pane or Hide in Available fields options are checked in the Manage Fields window. See 4. InfoQube Data (Fields and Items) (node 68) and 2. An overview of IQ's main components: Items, Fields, Grids, Forms, Panes
  • Form - A form is is a grouping of Fields that shows in the Properties Pane. You can give these fields "default" values and then create a new item with these values or apply these values to selected item(s). See 3. Using Forms
  • Full Hierachy  shows everything that is a child of an item, even if one of those child items is not part of the grid source. Reference
    Nonexistent node nid: 169.


  • Grid is the primary working window. It is also here that you select what information is displayed. Grids are not folders: they are only views of the data, views that depend on filters. So an "item" (each line in the outline) can be found in different grids, depending on the characteristics of that item, and the grid's filters.
  • Grid Context Menu  the menu that shows when you right click on a grid tab. See Modifying the Grid Context Menu

  • Grid Context Toolbar  the toolbar related to the Grid Context Menu. See Modifying the Grid Context Menu
  • GridForm The first form in the list of forms in the Properties pane. It contains the fields displayed in the current Grid

  • Grid Source see Source \ Source Box


  • Hoist - a feature where one can focus on a branch of a tree, and toggle back to the full tree. All other parts of the outline will be hidden while Hoist is on.
  • Hyperlink see Linking below


  • Item is used to refer to a piece of information. It is the equivalent of a note or a note title/heading or an entry. An item exists even if not shown in a grid.
    New Item shortcuts: Ctrl+N; Universal Hotkey (when IQ is running): WinKey+N.   4.10 Items


  • Journal Grid is a simple grid with no source, i.e. source = (All items). The DateFilter Toolbar is activated and has ItemCreated (and/or ItemModified) field selected. This grid will show all items created over a given period of time (day, week, month, user-defined number of days). Any date field can be used, so you can use it to show due dates, items modified, etc.



  • Linking \ Hyperlinks in IQ you can link an Item to another item, a URL web address, a file or a folder, a Field, a Grid, a WikiTag, or an Outlook item . Right-click item and select the Link (chain) symbol. See 8. Linking (node 115)
  • Locked Item Locked items cannot be deleted until unlocked. Locked items are set in the properties pane. To find all the items which have locked checked, select the itemlocked field in the grid source. Double-clicking "Locked" under Item info in the Properties panel will display it in the scratchpad grid.
  • LockItem (In the HTML pane menu) This locks the HTML pane of the current item, so that this HTML pane remains visible, even if you navigate to other items.


  • MHT  is a web page archive format used to combine resources that are typically represented by external links (such as images, Flash animations, Java applets, audio files) together with HTML code into a single file.

  • Multi-row display of headers In a grid, as you change the column width, just about when the caption no longer fits it, it is moved to another level.If you make it really narrow, it returns to the normal level, to allow you to cram lots of checkboxes.



  • Password see Encryption above
  • Parent an Item can have multiple parents - one of these is the main parent - this is the parent that shows in grids as the parent or context parent. There is also a field/column called "ItemParent" which shows the main Parent of each item in the grid. Other parents can be checked in Properties Pane.
  • Pivot Table
  • Popup Editor Shift-F2 from a grid item opens up a editing window for easier editing of the text, especially in narrow grid columns. Also may be called from the menu--Edit, Popup Editor. See 3.1.7 Popup Editor (node 142)
  • Properties Pane shows the properties of the currently focused item - these can be modified within the properties pane. It includes expandable panels showing:
    • Values (Field values)
    • Parents / Siblings / Children get a panel each
    • Shown in X grids
    • Tagged items (shows all currently 'tagged' items - see Tagged Items for explanation)
    • Forms  (see Forms
    • All fields



  • Recalc the "converse" of touch... It recalculates a given cell, based on its dependants
  • Repair consists of the following:-
    Recreates all fields, based on field definitions
    Recreates all grids
    Check the main parent of all items, repair if necessary
    Repair links if needed
    Erase HTML pages pointing to about:blank
    Instruct JET to do a database repair / compact


  • Save item state saves/recalls how your items' outline looks like, and always restores it to its last state (after a grid refresh or close/open...).
  • Scratchpad Grid the scratchpad grid is used when:
    • you double-click on a field in the properties pane, to show the items having field values (i.e. items in that folder)
    • you click on parents, children and siblings in the properties pane
    • you click on the lineage links on the status bar
    • Click on a hyperlink in a grid cell, pointing to another item and this item is not visible in the current grid. It will be displayed in the scratchpad grid
    • If the Scratch Grid is not defined (it is present by default in new files) it can be defined via Menu>View>Grids>Manage Grids and then in the Options select "Use as Scratchpad Grid"
  • Search Grid is the grid where search results are displayed;. In advanced search, you can override this)
  • Set Tree Column  sets the hierarchical representation of items (the hierarchical tree) on a particular column. Usually, it's on the item column. But you could set it to be on another column. By setting the tree on another column, this has the consequence of flattening the content (no more indenting), which makes it look more like a normal document, while still enabling the collapse/expand. Any column can be the tree-column, even the left-most # column. See forum thread What is "Set Tree Column"
  • Sort Bar  the Sort Bar (Grid>SortBar) is used for quick sorting and is particularly useful for multi-column sorts. You can drag a column header into to the box - the grid will now sort by this column. If you drag a second column into the box it will sort first by one, then by the second, e.g. you could sort by "ItemParent" and then by "DateStarted" columns. See also forum thread How do I turn off sorting?
  • Sort Box  this is a box in the Sourcebar (see below) that dictates the default sorting of the grid. You type the name of the field/column in the box by which you want the items in the current grid to be sorted. This becomes the default sort manner for this grid - if you press F5 (refresh) or close and reopen grid, it will be sorted by whatever field you have in the Sort Box. Temporary sorting can be done by clicking on column headers or by using the Sort Bar (see above).
    For some more info see under heading "The Grids" in 2. An overview of IQ's main components: Items, Fields, Grids, Forms, Panes and see Default Sort above
  • Source \ Grid Source \ Source box  this defines what items are displayed in a grid. The Source is always a field (it can be more but it is recommended to keep the Source simple and add additional criteria to the Filter). When you create a new grid, let's call it "Inventory", a yes/no tick-box field is automatically created by that name. New top-level items in this grid will always have this field (automatically) ticked. The Grid Source can be changed at any stage via the Sourcebar.
    Alt-S toggles the sourcebar which has Source Box, Filter Box, and buttons for the AlphaFilter and DateFilter and the Sort Box. See 2. An overview of IQ's main components: Items, Fields, Grids, Forms, Panes and 1. Grids and Gantt Charts


  • Tagged items - currently 'Tagging' is a means of selection of a group of individual items in IQ. This can be done via the item context menu, or via Menu: Item > Tag Items. For 'real' tagging see Wikitags and see forum discussions here www.sqlnotes.net/drupal5/index.php for a discussion of possible future developments.
  • TLI    Acronym for "Top Level Item"
  • Touch When you have equations (either row or column), and you change a value, dependant cells are updated. When you "touch" a cell, it does the same thing, except that you don't need to make any changes, it updates dependant cells  Also see Recalc.
  • Tree Column see Set Tree Column


  • Universal Clipper- invokes the "add new item" dialog from any windows application to capture selected text and images, or to simply add a new note manually. InfoQube must be running.  See
    Nonexistent node nid: 2183.



  • Wikitags Wikitags are tag words enclosed in {fancy brackets} and entered in the WikiTag field/column. You can then create a Wikitag link in an Item (see Link above) that will open all relevant Wikitagged Items in the** Scratch Grid
    Planned for Wikitags:
    • A UI to view tags, add / remove tags, rename tags
    • Hierarchy of tags. Items with a child tag, also inherits parent tag

    Also see 5.4 Wikitags





Pierre, re Compacting:
Keith asks
> Is "compact on program close" recommended, or do you do it manually when things seem to slow down.
Tom asks
> Is there a reason this not enabled by default ?

Re: Compacting:

I don't compact very often, basically when I happen to view the file in Explorer and notice that it is getting big. How about if the system automatically compact the file when it detects that it is needed?

Re: Compacting:

sounds good, if possible
means people wont have to think about it ..

Column Filter

all info about column filter is now here
but maybe that's too much info here? - the info is also in Filter page so maybe I should reduce this and link to that?
Like this:
Column (Field) Filter  filters (searches) contents of a field/column within a grid. Access via Menu > Grid > Column Filter Buttons > Show Column Filter, or, right click column header and select Filter Column, or Ctrl+G shortcut activates the Column/Field filter.
Related settings:- Menu > Grid > Column Filter Buttons > Filter as you type
For more info see "Column Filter Buttons" on page 5. Searching, Filtering & Sorting
decided to do this but have lost the ability (permission :p) to edit
will try later
EDIT: this is done now

Re: 15. Glossary

I would like to make this glossary more comprehensive - so if people see something missing could you either add to the page as a 'stub' (or full item!) or
make a post here requesting addition or correction or whatever.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.