Submitted by PIMfan on 2009/08/24 12:35
I was playing around with the latest InfoQube version and so was doing some things that maybe I shouldn't have....
 
I noticed that if I created a grid, a custom field, and then changed the field and/or grid name, this would result in errors.  Listed below are the steps I took.  Can someone repeat and tell me if the red outlined areas are issues or not?
 
Steps to recreate bug:
  • View --> Manage Fields
  • Create a new field called "Projects". Save and Close the manage fields screen.
  • View --> Grids --> New grid
  • In the Create Grids screen, select "Projects" from the drop menu.
  • In the Projects grid, create four items:
    • Project1
    • Project2
    • Project3
    • Project4
  • Select Grid --> Show Source Bar.  Note the name of the source grid ("Projects").
  • Select View --> Grids --> Manage Grids
    • Bug?:  The "last opened" field is blank for the Projects grid.  Shouldn't it list the creation time and date for the Projects grid just created (since it is opened by default).
  • Select View --> Manage Fields
  • Select the Projects field and (on the right side of the screen) change the name from "Projects" to "Project" (removing the "s").  Click Save and Close.
  • Click the refresh button.  An error dialog will be shown stating "Error reading data.  Check the source, filter and sort criterion."
    • Bug?:  Shouldn't changing the field name in the field management screen update the value of the field in the grid source to reflect the new name instead of presenting an error?

Comments

[quote]Click the refresh button.  An error dialog will be shown stating "Error reading data.  Check the source, filter and sort criterion."
  • Bug?:  Shouldn't changing the field name in the field management screen update the value of the field in the grid source to reflect the new name instead of presenting an error?
[/quote]
 
The problem is that you changed a field name, but that name is used to filter items in the grid -- ie determines what is shown in a grid.
So if you change a field name and this name is used as the source or in the source bar filters (see manual -- press alt-s, or use the grid menu to display the source bar), this will result in an error... It's a user error, not an IQ error.
 
 
[quote]
Select View --> Grids --> Manage Grids
  • Bug?:  The "last opened" field is blank for the Projects grid.  Shouldn't it list the creation time and date for the Projects grid just created (since it is opened by default).
[/quote]
 
Don't why the "last opened"  is blank... Maybe because it was just created and hasn't been closed before you opened the "manage grid" dialog.
 
 
Are you a beginner using a completely blank database ? if yes, maybe you should create a new database file using the option "new IQ base (with sample data)" (File-> new->...)
It's much easier to understand IQ's functioning with the template, I find. You can always erase all items if needed and start from there. The template is well thought of, and could serve as a starting point. That's what I did 1.5 years ago and I'm still using the same DB.

PIMfan

2009/08/24 15:39

Permalink

Armando -
 
Thanks for the quick reply.  I am relatively new to InfoQube, but that gives me the advantage of trying stupid things that other new users might also do. 
 
To prevent a user from accidentally doing what I did, can I recommend:
  • Having InfoQube "gray out" the option to modify the name of a field if it is used as a grid souce....    -or-
  • Modifying InfoQube so that a name change in a field used as a grid source results in InfoQube also changing a linked grid name and the associated grid source.
I'm hoping for the second option.  This is because I find that as I learn more about InfoQube from playing with it, I realize I should have named and built some of my fields and grids differently than I originally did.  The second option would allow users to change things without them necessarily breaking.
 
What I'm hoping for is to more gracefully prevent newbs like me from accidentally messing up their field and grid relationships.  Advanced users will know not to do this, so my suggestion is geared toward a wider use audience when InfoQube goes "live".
 
Thoughts?
 
PIMfan
 

Armando

2009/08/26 13:56

Permalink

These are good suggestions.
 
1- instead if greying out the option to modify the name of a field : maybe a warning  would be better, as users might wan't to modify field names without having to change/erase the grid sources first.
2- The second option seems to be the best  (" a name change in a field used as a grid source results in InfoQube also changing a linked grid name and the associated grid source")... It might be possible for filters and sources, but not for field related fomulas etc... Otherwise, the process of changing field names could become a lenghty and CPU intensive process... But what do I know...). Grid names shouldn't be modified... grid names and grid sources are completely independent. I could have a "contact" grid name which would have, as a source
(addressBook AND contacts) OR phoneNumber