Submitted by LeftEccoForIQ on 2022/01/05 05:42

Live-Search from an Omnibox search would be much more useful to me if:

1. I could tell immediately which items are marked Done.

Please note: I usually have a Done grid open but it is filtered to only show the items marked Done during the last week so I can check on those quickly and maybe remove the Done value to get items to show back in their original grid (filtered to not show Done items). So in Live-Search results I currently only get values for Done if the item was marked done during that period.

The reason for that setup is that I currently have over ten thousand Done items so I don't keep an unfiltered Done grid open. I guess I could replace the week-filtered done grid with an unfiltered one if on selecting to load only the first 1000 items when focusing the unfiltered Done grid to view the most recent Done items, IQ would actually load the newest 1000 items but it seems to start by loading the oldest 1000 items. Not sure that is the most use-case oriented approach as to view the most recent ones I have to load all items, which takes around 15 seconds.

I guess the solution would be to keep both the Done_1week and the unfiltered Done grid open, accepting some clutter on the tab bar, and just never to activate the unfiltered Done grid so I will still have all Done associations shown in the ShownIn column of Live-Search.

Or is there a more elegant solution I do not see?

2. I could navigate to child items that don't have a ShownIn value themselves with a single click nevertheless

For such child items (only some of their parents, usually only their top-level parent is actually assigned to a grid-related field), there is no easy way to navigate to the item in the context of their grid. This is a real bummer for me. The only way I've found to get to where they appear in a grid (they usually all do) is to click on the Parent tab in the Properties Pane, unfold all higher level parents (and try to remember that path), then go to the grid of the top level parent and manually navigate down that tree to get to the item. Is there an ease way to do this that I am missing? Opening a parent in the scratch grid doesn't really cut it as that removes the context of any sibling trees.

If there isn't yet an easy way to do this, would it be possible - if ShownIn would otherwise be empty - to display the ShownIn values of the child's top level parent in the ShowIn column e. g. in brackets or a different color? And then when user clicks on the bracketed values to jump to the item directly just like it was actually assigned to that grid itself? That would really make my life easier...

Cheers!

Comments

Hi Left,

  1. Adding a Done column is indeed a good suggestion. The way I have it setup, is that marking an item done changes the item background color (to light gray) and this is reflected in Live-Search. But not all users enable this, so a Done checkbox option will be added
  2. Indeed. You can click on the Home in the Properties pane to do that. I'll add back the Item Home in Shown in

As always, thanks for the quick reply!

Hm, as for 1, I just tried conditional formatting rules for the Item field to format item text as italic or alternatively with a different backcolor when the item has a Done value. Both work in grids showing the Done column, but I can't get this to be reflected in the Live-Search grid. How would I show the Done column in that grid?

As for 2, under the Basic tab on the proprties pane, the child items that don't have a 'grid value' show '(none)' as their Home value and when I click on this value, the item is shown hoisted in the Scratch grid, not in the home grid of its top level parent. Also when I unhoist the view, I'm taken back to the top level parent with the entire tree collapsed - so, again, there is no easy way to navigate to that item, even in the Scratch grid. Ideally, I'd want to get to it with the tree unfolded and all surrounding items in the home grid.

Cheers

  1. Conditional formatting is grid specific, so that is not the way to go. You want to act on data. I have an auto-assign on the Done field that sets the ItemColor field:
    AM:[ItemColor]=&HDDDDDD | E:[ItemColor] =
    To run the Auto-assign on existing items, you can select them and do Edit > Touch
  2. The ShownIn column was improved in the next version. If the item has (none) for the Home, it isn't because it doesn't have the grid source field, but rather because it was created before Item Home was implemented. All created items should now have a Home

Thanks, I'd always wondered what "Touch" was actually used for!

Could I use a macro / scripting to make the Home 'value' for my poor 'homeless' items default to the Home value of their top-level parent?

 

Suggestions