InfoQube IM - Community

Submitted by EveryWord on 2014/03/11 12:32

It appears that I just lost data in InfoQube, and that is related somehow to the default Scratch & Search grids. Can someone explain these to me?

I spent about a half-hour creating a new outline in a grid that I called 'Tasks'.

I looked to the left of the screen, and saw tabs for the Search and Scratch grids. Since I did not create these, and didn't understand a need for them, I deleted them, and then found that everything from my Tasks grid was gone as well.

What happened?

Comments

Hi EveryWord

In no way can deleting a grid delete any information. Grids are just display devices, like you TV set. Data is safely stored in the database.

If you want to share some information, screen capture, etc, we'll be able to help you see the data you've entered in IQ.

Regarding your question, to work efficiently, IQ needs one scratch grid and one search grid. Any grid can be set as scratch and search (defined in grid properties). The scratch grid is used to show items (from a hyperlink, to show items in a fields, etc). Search grid is used to show search results.

HTH

Pierre_Admin

OK, at least I understand the importance of these two grids now, and that they shouldn't be deleted. I'll try recreating what happened and share back, if I find something.

Hi EveryWord,

are you familiar with the date filter?

Do you have a Journal grid?

If so, open it, and the date filter shows automatically.

The Journal grid has no source-filter by default - i.e. it would show all items, but filters them by date. Use the date filter to filter for items created or modified on the day in question.

They should be there.

Then you need to look at what is the source in the Task grid (probably a field called 'Tasks', or maybe something more complex?)

If it's a tickbox yes/no filed, you need to tick this (in the porperties pane,) for the top-level-items in the outline you created. They will then show in the grid again.

If you need more info about any of the above just ask (check out the manual/help as well).

As to what happened there, I dont know. As said, I dont see your items as deleted, but they somehow lost the properties that qualify them to be shown in that grid...

Re Search & Scratch - Search is the grid used when you search the whole IQ file (Ctrl+F).

Scratch grid is a temporary grid for displaying items.

Both are default, I suspect they can be recreated, but will leave that to someone more expert than me

Excellent answer Tom, Thanks !

(and stop being so modest... you're a long-time IQ user and know much more than you care to show...

)

Found the Date-Filter toolbar, but can't figure out how to turn on the Journal grid, unless it's more obvious than I think? just create a new grid and name it 'Journal'?

Thanks both Tom and Pierre for your help. I assure you, I'm a more enthusiastic user than I probably appear to be!

Grid names are not important in IQ.

To create a "journal" type grid:

Create a new grid
Show the source bar (Alt-S)
In the left most text box, select the first item in the list (All items)
Activate the date filter toolbar and set it to filter on the ItemCreated field. Set the operator to = (left part of the date filter toolbar). Set the timescale to 1 day.
Press Refresh

HTH !

^ I'm having fun learning formulas for spreadsheets at the moment - I know what it's like...

The tabs you were talking about on the left - they are the grids - if Journal isnt there, try the shortcut Ctrl+Shift+O (that's "O" for open). That should open a display of all the grids in the current file. Or, try hovering over the icons in the menu toolbar - the yellow square with a red dropped shadow - tooltip says "Grids".

If there's no Journal grid, maybe the easiest thing would be to create a new grid - call it anything you want.

Show the sourcebar - Alt+S (there's a little bug [Pierre!] where you have to click Alt+S twice). Or menu:Grid>Show_Sourcebar

Next step is get the Date filter showing => menu:grid>Date-filter

Set the Date filter to the day or time-period you want-- see the manual page Date Filter toolbar

Now look at the sourcebar of your grid - on the left there's a field with the source in it (Grid Source EditBox) - this is really simply a filter - if you remove the field-name in this box, and press return - it will show *all* items in the file. I dont know how many entries you have, but that's a lot of work for my file here - that's why I sent you to the Date filter first, to limit the amount of items shown.

You have now created a 'Journal' style grid. If you get the date filter to show the relevant day, you items *should* be there.

EDIT// missed Pierre's post again!

edit// -- March 12 -- minor details/corrections