InfoQube IM - Community

Submitted by KeithB on 2009/10/13 23:00

I came up with an idea, working on more spring cleaning of my database, to find items that weren't shown in any grids (other than journal, etc).

I made up a "no_grid" grid, and dragged all the (sources) yes/no fields for the grids to it. I had 35 or so, removed a couple that I knew only had a few items in them, and spaced the columns to get everything to fit on one screen. I'm now going down item by item, and can quickly see which items don't have anything checked.

I'll go back, and use the same technique to work on grid re-assignments. (EDIT this is more cumbersome than using a custom form, if the number of fields showing is great)

For me, this is easier than using the properties pane, and using the shown in grids info, since that area hops around, depending on the number of entries in the filled fields above.

Does anyone have an alternate/better technique?

-----------------------------------------------------

EDIT per the comments, I now use all 3 techniques:

BinaryFields is null, or
BinaryFields is null and nbparents=0 to get the count.

2) My method above to visually see the culprits

3) A homemade assign_to_grids form to assign the items a home

Comments

How about a grid with the following source:

BinaryFields is null, or
BinaryFields is null and nbparents=0

Should give you all items that have not a single yes/no field. Second one will exclude sub-items

This was very helpful for me. However, now that IQ includes a calendar, "BinaryFields is null" will also show any calendar appointments that don't have additional metadata. So, in order to exclude appointments, I have changed it to: "BinaryFields is null and Appointments is null". Seems to do the trick.

Your approach's strenght is that you can see many items "affiliation" at once.

But I guess that you could just :

1- align all fields in some filtering expression :

"AdrsBook is null AND Inbox is null" etc. until you cover all those fields matching your grid sources... That could be long... dunno. The advantage is that you'd see in a flash all those items with no data in those Yes/No fields.

Pierre could probably come up with some smart field like the "Textfields" or "Numberfields", but for the Boolean Yes/No fields. This Way you could just type "YesNofields is null" in the filter text box and all those same fields without any data in Yes/No fields would come up.

(Pierre : would that be possible ?)

2- Create a form (in the properties pane) with all the fields involved in your grids' sources :

That would be more efficient as you could more easily assign a field to several items at once... and you could reuse that form from any grid.

grrrr... Pierre was here before me. ;)

Thanks Pierre ... I didn't know about the binaryfields ...

[quote=KeithB]

I came up with an idea, working on more spring cleaning of my database

[/quote]

With the first freezing temperatures in Montreal scheduled for tonight, I wish it was spring here... Cycling season would be just starting... Do you live in Australia?

[quote=Pierre_Admin]

[quote=KeithB]

[/quote]

With the first freezing temperatures in Montreal scheduled for tonight, I wish it was spring here... Cycling season would be just starting... Do you live in Australia?

[/quote] (St. Louis Missouri area) 46 degrees F here with drizzle probably doesn't count as spring!