Filtering Items

As the number of items in your database increases, it becomes essential to filter out some to focus on others.
 
When you create a new grid, you're actually creating a filter whereby, by default, only items you create in that grid will be shown there.
 
Nevertheless, the numbers of items in a grid may become large and filtering in such cases can be useful. Grids support a number of different kinds of filters:
  1. Column filters
  2. Grid filter
  3. Hoist filter
  4. Alpha-numeric filter toolbar
  5. Date filter toolbar
  6. Advanced filters using the Source bar

A thread to help getting a feel of which features / bugs should be given highest priority, from the users point of view.

Submitted by Armando on 2009/07/03 14:01
David_H's  "voting" at the end of  How Do I Keep Tabs (Grids) Open? made me think that a "poll"/thread to find out which "older" features/bugs users want most to be added or "cleared out" would help to get these out the way in a "prioritized" fashion...?
 
 
1- Users could review the mantis list and old feature/bug posts and think about what annoys them / slows them down the most in their everyday IQ usage,
 
2- Then list 10 (is that the right number ?) features OR bugs already discussed*, ordered by priority, "1" being the highest priority. If required, a brief justification could follow each item.
 
 
*New stuff, I believe, should be discussed separately, as it has always been.

Lost the Sidebar that has buttons for Addressbook, ToDo, InBox etc

Submitted by Anonymous on 2009/07/02 13:26
Not sure what I clicked but have been thru all the items in View menu but cannot bring the vertical button bar back that has Address, InBox, ToDo, Finances etc back.
 
OK found it but it appears there is a bug.  By going to View - Grids and dragging the bar to the side I got the button bar back.  On Right clicking on the bar I get a menu and can customize the toolbars, Commands, Keyboard, Options.  What is the direct way to access this menu?  Also if I uncheck the "Views" from teh Toolbars list, it just vanishes from the list and to get the buttonb bar back, I have to go to View - Grids and drag it over.
 
 
Have played withit for a few hours and similar to EccoPro, Learning curve is very steep.  Have following questions -
 
- In the phonebook, it appears that the

New pages about the default grids. (need a lot of help here)

Submitted by KeithB on 2009/07/01 21:43
I made a framework for a description of the various grids of the default file.  Introduction to the default grids and it's subpages.
 
I need a lot of help filling these out, as I've never gone through and studied all the default grids thoroughly.
 
Also this gives us a reference pages to refer to.
 
Any help as to new text, links to existing stuff, etc would be appreciated. 
 
What I envision is a quick description as to what the grid does, then a more thorough explanation,  interaction with other grids (if any),
suggestions to enhance each, suggestions to modify each one to other things...

Scratch Grid

describe the scratch grid
 
from the dc forum:
 
What is the Scratch Pad for and does it function any differently from any other grid?

This is how I use the scratch pad :

1- I use it for preliminary data gathering.

2- But, mostly, when I want to have an quick idea of "which field is populated with what data", or "what data is populating this particular field", I open the property pane, double click on a field, and the scratchpad automatically updates itself and shows what item contains data pertaining to that field.

Journal Grid

The journal grid is handy to easily show ALL the items in the database, as well as showing items over a period of time via the DateFilter toolbar
 
 
The Journal Grid is a simple grid with no source. Without the DateFilter Toolbar turned on, all items in the IQ database would show.
 
The following screenshot show the Journal grid filtering on the date field IQDocDate for a period stating on Nov 9th 2020 and showing 7 days. Sorting is in descending order (newest first):
 
  • Any date field can be used, so you can use it to show due dates, items modified, etc.
  • It supports multiple date fields too (separate fields with a comma (, )
 

This section describes the default grids found in the sample data base.
 
These grids are very useful to learn how to use InfoQube and they can certainly be used "as is"  without changing them much.
 
However, it's important to note that:
 
1- these grids aren't sacred (they can be either deleted, renamed, transformed as one sees fit)
2- other grids can be created
3- ...