Community Website Migration

Submitted by Pierre_Admin on 2021/02/24 22:59
Forums
Announcements
Hi IQ Users !
 
This community website was built some 12 years ago, using Drupal 5, a content management system.
It was sort of "cutting edge" back then. It isn't anymore, and the language it is built upon, php, has evolved quite a bit, from php4 to the current php7.
 
A few years ago, we were forced to move to php5 which mostly worked (user account page was notably broken) but it is impossible to run Drupal 5 on php7, which the hosting service is about to migrate to.
 
So...

Really annoying and embarrassing

Submitted by Maxbear35 on 2021/02/23 11:41
I made a job list. lengthy and detailed.
 
Lost it somewhere in InfoQube. 
 
Looked but couldn't find it. Tried advanced search and located individual items but I can'r see any way to show the parent of that item or where it is so search not useful.
 
Ended up putting in • (bullet) to advanced search and got my list back in the search. Lucky I bulleted  the list. 
 
There has to be a way to find my list?  Yes I'm a newbie so I am sure I'm missing some simple thing.
 
Please help - Thanks.
 
 
 
 
 
 

Infoqube database size limit details?

Submitted by KeithB on 2021/02/21 12:55
Does the jet 4.0 database have a 2GB limit like access does, and what exactly how would the limit pertain to infoqube?
 
I have my main file KAB1.SNDB now at 243MB (compacted), and the KAB1.SNDB.Files showing at 1GB.
 
I'm hoping any limits would only pertain to the SNDB file itself, but I wanted to make sure.
 
From any stress testing, do you know or have an idea what would happen to IQ when it reaches the database limit?
 
 
 

Auto Refresh Screen for ItemCreated Sorts?

Submitted by WayneK on 2021/02/18 14:12
I sort a lot using ItemCreated date.  But for this to work correctly, you have to first refresh the grid (values are not displayed when item is created).
 
I forget to do this repeatedly, so that what I expect to be a one-step operation becomes three: 1) Sort; 2) Refresh grid after realizing some items don't have created dates; 3) Sort again.
 
Is there any way to get around this and avoid the extra steps?
 
Maybe it wouldn't be desirable to refresh the grid every time you create a new item, but maybe include a grid refresh any time a sort is initiated on a column that has automatic values?
 
Wayne

more experiments with linked files

Submitted by jimspoon on 2021/02/17 17:53
ItemHTMLFile contains only a file name, not a pathname - IQ looks for the file in the .Files folder.  .Files folder is set in Option 2.4.10, and is stored in <database name>.ini in the same folder as the corresponding .sndb database file. 
 
ItemHTMLFile contains both a pathname and filename - IQ finds the file at the designated path and filename.
 
FileName has only a filename, no pathname, and FilePath is empty - IQ finds the file if it is located in the .Files folder.  Image Viewer displayed an image file I put into the .Files folder and referenced this way.
 
FilePath or ItemHTMLFile contains network pathnames in form \\computername\sharename\pathname\filename -  IQ can find the linked file from different computers on the network.  Handy when using synced database is loaded into IQ on different network computers, and the database contains links to files residing on compute

Wildcards in Omnibox

Submitted by Armando on 2021/02/17 17:40

Hi Pierre,

Wildcards in Omnibox in version 117pre4 don't work when placed at the end of a string

Ex.: *proj*

There are no results.

In previous versions (at least in 116f) the same query would allow to filter grids names -- ex. see all grids containing the string "proj".

Tell me if you can't reproduce it.

Thanks!

Navigating from Search Grid via Tags

Submitted by assari on 2021/02/15 16:53
 Hi Pierre,

Embracing the concept of items being independent of grids, I tend to "group" my items using tags by tagging all my top line items.

I would like to suggest that in the "Search Grid" you allow for navigation to an item by clicking on the Tags just as we currently can by clicking on the "Shown In"  column.

Thank you for your kind consideration.

-assari-

a Files form you can add to your IQ database

Submitted by jimspoon on 2021/02/12 23:18
I just added a "Files" form to my database and I thought I'd pass it along in case anyone else might find it useful.
 
As you know IQ uses several different fields to hold references to files in the file system.  Three of these (are there any more?) are FileName, FilePath, and ItemHTMLFile.  ItemHTMLFile holds the path of the file that is displayed in the document pane.  FilePath and FileName hold the path and name of a file that can be loaded by double-clcking on the item, or viewed by opening an Image Viewer.
 
If you put these fields in a Form, a down arrow appears next to the field name in the form.  You can click on this down arrow to bring up a "Select a File" dialog (FilePath, ItemHTMLFile) or a "Browse for Folder" dialog (FilePath), to fill in these fields.
 
I added the URL field too and here's how my Form looks:
 
Subscribe to