Grid corruption ?

Submitted by Armando on 2009/02/12 17:15
In one grid, I always get the :
"Error reading data : Check the source, filter and sort criteria"
whatever I write in the source/filter/source/"any other" bar. It can even be completely empty -- still get the error.
Tried a restart, tried a repair --> still get the error.
What could be the problem?
Anybody else had this problem before?

pre-release 8

Submitted by jan_rifkinson on 2009/02/12 17:00
Pierre, hope you are feeling better & hard at work on the next release. Do you have an approximate release date so  I can stop bothering you about it? I could create a reminder in IQ calendar.:-)
 
--
Jan Rifkinsson
Ridgefield CT USA

SUM in Filtered Views

Submitted by Anonymous on 2009/02/11 16:12
I created a Grid with Projects and Times for each.
I use
1 - Clients [Parent to Projects]
2 - Projects [Parent to Tasks]
3 - Tasks
4 - Task Time
5 - Task Date
6 - etc.
I use SUM Parent > Children in Clients, Projects and Tasks so I can get the Totals for all Task related to each Project and Totals for all the Projects Related to a Client.
It works well, but when I use a Date Filter the SUM Totals are always the same.
 
Is it possible to SUM only Visible items?

Tabbing within text

Submitted by Anonymous on 2009/02/10 23:16
First time here...
 
Finally found something useful. I am a MyInfo and FileMaker user and a previous EPIM also. I found this SQLNotes by sheer luck by looking for ECCO.
So I am trying to understand well all the facets of SQLNotes and the first thing that come up is "How to design a specific section for a specific task" because it seems that here you have more than several way of doing something either right or less right.
I think this could be the one.

Updated equation/rules docs

Submitted by reesd on 2009/02/10 14:34
I did some revisions of the equation/rules documentation (http://www.sqlnotes.net/drupal5/index.php?q=node/128) including moving some of the information over from fields (http://www.sqlnotes.net/drupal5/index.php?q=node/68). To be honest I had even more done that I lost when I accidently hit Cmd-Left which lost that set of changes (argh!). Something I really need to get fixed in Firefox on the Mac.
 
One gap in my knowledge and therefore in the documentation is updating. Could someone summarize for me how updating works for row/hierarchy equations and how is is affected by the Update button and Auto-Update checkbox?
 
One other question is terminology, I tried to line up the names between the screenshot, fields doc, and equations doc by going with the following. Let me know if we should tweak these names more.

import/export/sync outline depth

Submitted by reesd on 2009/02/10 12:11

I would like to recap the need for importing or synchronizing outline depth. It was covered in the old forums, but I would like to summarize here in the new forums and also push for my lighter approach listed below be in 0.9.25 (rather than 0.9.26 as currently planned). For reference, also see http://www.sqlnotes.net/drupal5/index.php?q=node/257 for some discussion on importing/exporting depth.

 

Import (and sync which uses the same underlying mapping approach) is quite powerful in IQ, but its missing one key piece of information - the items depth in the outline. There are three ways of indicating depth that could be used. I will use the following simple outline in my examples:
A
  AA
    AAA
  AB
B
  BA

 

Subscribe to