InfoQube IM - Community

Submitted by WayneK on 2017/06/16 01:37

I have an orphaned item and no idea where it belongs in my outline. If I knew what other items were created on the same day, I could figure it out. But I can't figure out how to search the ItemCreated field.

I opened advanced find. I put the date in the search box. I looked at the list of fields to search in: "ItemCreated" was not listed.

How do I search by the created date? Alternatively, how would you go about finding the proper location of an orphaned item?

I figured out a workaround: I went to the grid that contains all the items similar to the orphaned item. I opened the "created" column and filtered for the relevant date.

Update: I'm guessing you can only search text fields. Don't know why that would be. Still haven't found the home for the orphan. Could find it directly if I could search for the previous ID number.

Comments

Another workaround. For this and various other reasons I maintain a grid called item based on item. This has among its fields ItemCreated and ItemModified. It takes a very long time to open this grid, but when it is necessary, that is a price worth paying.

Mark GREGORY, Hull, England- GMT +0/+1; EST +5

Hi Wayne,

There are quite a few ways to search for ItemCreated:

Open the Journal grid and use the Date Filter toolbar
Show the ItemCreated field to a grid and use sort / filter
Enter a simple SQL query in Source bar filter (such as int(ItemCreated) = #YYYY-MM-DD#)

HTH !

Pierre_Admin

IQ Designer

Gregory and Pierre,

I cannot use Journal or a grid of all items because the grid won't load (I have 34,000 items). I talked about this in another thread. I did solve this particular problem but if Pierre has time, I'd appreciate some guidance on how to handle databases with large numbers of items.

1) Most of my items are subitems and are not assigned to my working grids (only their parents are assigned). When a typical grid loads, it only counts assigned items, not subitems unless they've been explicitly assigned to that grid. This allows me to have many thousands of items assigned to a grid without having trouble loading.

2) However, I run into problems when I have to load grids that contain all items explicitly assigned to them (eg journal, creation date etc). What am I supposed to do about these cases? When a grid loads, there is no option to apply a filter to limit the number of items loading. I only have the option of loading 1,000 or 2,000, and I don't see any way to control which limited number are selected nor do I see any way to add more items after that. If you load the grid again, it starts over with the same 1,000 items.

I think the answer is to use another grid, set the source and filter I need, then refresh the grid. But as it stands, I don't know of any way to directly load Journal or any other grid that tries to load all items in the database.

Wayne

The trick is to load the grid with say 1000 items, then apply a filter, such as the Date Filter. Check out the date filter in the sample IQBase as an example

Pierre_Admin

IQ Designer

OK. Load 1,000 items. Apply a filter to limit the total to below 1,000 or 2,000. Then refresh the grid to load items meeting the filter. Then change the filter as needed to view other items.

Thanks,

Wayne

[quote=WayneK]

OK. Load 1,000 items. Apply a filter to limit the total to below 1,000 or 2,000. Then refresh the grid to load items meeting the filter. Then change the filter as needed to view other items.[/quote]

FWIW the Journal grid should automatically display the date filter -- and remember the last filtered dates.

So when you open it again, display of all items should not be a problem.

[quote=WayneK]

When a grid loads, there is no option to apply a filter to limit the number of items loading. I only have the option of loading 1,000 or 2,000, and I don't see any way to control which limited number are selected nor do I see any way to add more items after that. If you load the grid again, it starts over with the same 1,000 items.

[/quote]

Hi Wayne, it's also possible to change the source bar filter before loading the grid in the Manage Grids dialog.

- In that dialog, select your grid

- Data section --> Filter

There you could insert/type a filter** like:

ItemCreated > #2017-01-06#

itemcreated > now-30

etc.

that will limit the number of items using a time range.

then save the grid and open it.

There are other possibilities like the one you and Pierre mentioned.

**Obviously if you already have a carefully crafted filter there, you might want to copy it first, and paste it somewhere -- just to make sure (IQ should have it in the drop down filter list in the source bar, but better sage than sorry)

As a work-around you can create a Text Field -> ItemCreatedText and populate the row equation for the field with something like "=FormatDateTime([ItemCreated])" or a custom made VB function (not that difficult). Somehow in 97a the row equation does not trigger always. So you need to recalculate things manually if need be.