InfoQube IM - Community

Submitted by markfoley on 2009/06/15 01:59

How to do the equivalent of a replace query. Example situation:

a) I have a grid I created called 'projectsomiro' . Now all the items in it (at top level) have the field 'projectsomiro' set to true.

b) I now see I'll have 50 projects, and to make reporting/etc easier, I want just one 'text field' which would contain "somiro", "project x" or another project's name. I don't want 50 true/false fields of course.

How to now basically say: "for each item, if projectsomiro = true then project = "somiro"

Then I would delete my true/false flags.

Based on my early usage I think this will be a common thing to do.

Comments

There are a few ways, but this will do it:

Double-click on the field Projectsomiro
Ensure the display has context parents off, hierarchy off, save Item states off
Refresh
You should now see all items that have Projectsomiro checked (and nothing else)
Select all items
In the properties pane, Enter "somiro" in the field Project. You'll be prompted to confirm the bulk operation
Check that all was done
Before deleting your Projectsomiro field, open your grids and modify them if needed to reflect the field change

Pierre, I suggest your explanation be added to the documentation.

Jan Rifkinson

Ridgefield CT USA

HP Blackbird Vista Ultimate SP-1

Done: Changing field values in bulk

Thanks that's a good method!

a) When you say 'double click on the field projectsomiro' where would this be done? I tried it in the field manager, tried clicking the field header (which just triggers re-sorting) as well as the field content itself on and off the check mark.

b) Should 'save item state' be made a button next to the context parent/hierarchy buttons?

c) Doing that change to all fields via properties works, thanks. I realised now though that my beloved Ctrl-Return used in Excel doesn't fill all cells with the value which would be much more elegant. I'll log that.

> a) When you say 'double click on the field projectsomiro' where would this be done? I tried it in the field manager, tried clicking the field header (which just triggers re-sorting) as well as the field content itself on and off the check mark.

Normally this is achieved by double clicking a field in the properties pane. But it now IQ proposes to the user to change the grid source...

Pierre : did you change that on purpose or is it a bug?

> b) Should 'save item state' be made a button next to the context parent/hierarchy buttons?

"Save item state" can be made a button if you want. That's what I do.

I proposed a different "grid toolbar" a while ago, in the old forum, and in Mantis too. Maybe does Keith have a copy of that. I too think (...have alsways thought) that either the Standard or the "grid Context" toolbar should be more complete and show all possible filters (giving important visual cues)

[quote=Armando]

Normally this is achieved by double clicking a field in the properties pane. But it now IQ proposes to the user to change the grid source...

Pierre : did you change that on purpose or is it a bug?

[/quote]

It asks this if the scratchpad grid is not defined. Manage grids>>Options

Thanks.

This is weird because I never changed or "un-defined" my scratchpad grid.

I now remember that IQ also complained of not having any search grid defined when I updated to one of the latest versions.