Submitted by KeithB on 2018/11/16 13:53
 Is there currently a non-manual way to generate a grid containing the names and sources of all my grids?
 
(Low priority) please add to the future wish list the ability to  export all the content from both the manage grids and the manage fields dialogs to a scratch grid..
 

Comments

Hi Keith,
 
You can certainly create a smart field to read the grid names, the table is called Views preceded by an overscore. Have fun !
 
Pierre_Admin
IQ Designer
 

KeithB

2018/11/17 11:02

Permalink

Thanks for that suggestion.  I looked at the manual and the handful of past posts on smart fields, and the topic seems a bit daunting.
HOWEVER, I didn't realize just pulling up the SNDB in microsoft access, gives you "access" to all kinds of things.
So in this case, it appears I can just go to the ¯Views table in access, export that to excel, then import that into IQ.
That will satisfy my immediate grid listing needs wonderfully.
 
 
 

KeithB

2019/11/03 14:33

Permalink

 Would you mind giving me the "answer"?  I never was able to figure this out from the examples in the manual.  Thanks

Pierre_Admin

2019/11/03 15:09

Permalink

Hi Keith,
 
Well, it is a roundabout way with one caveat but it should work:
  1. New text field ViewName, source=SELECT ID AS itemID, Name AS ViewName FROM ¯Views;
  2. New text field ViewSource, source=SELECT ID AS itemID, Source AS ViewSource FROM ¯Views
  3. Create a new grid with ViewName as its source
  4. Add the ViewSource column
The caveat is that it tricks the system in thinking that views are items. So do not make any changes to other values as it will change the corresponding item (ItemID = ViewID)
 
Pierre_Admin
IQ Designer
 

I'll add a command in the Manage Grids dialog
 
In the meantime, if you have MS Excel or another ODBC enabled spreadsheet/database program, you can connect to your IQBase and get this (and other) information
 
 
Pierre_Admin
IQ Designer