Submitted by jimspoon on 2017/02/23 17:25
Just curious, is it possible to set grid filter and sorting criteria by script?  Or to change Infoqube / Grid settings that way? 
 
Looking at the Visual Basic Editor, I don't see any way to execute a command "immediately", but I suppose that I could define a function and the use the "Execute a Function" button in lieu of that.

Comments

Wow Jim, you're inspired these days... 
 
The closest there is in IQ to an Execute button is in Forms. You can trigger any action when applying a form to items, using auto-assigns and / user scripts. You can also use any field (such as a Y/N field), it will do the same. The advantage of the field, is that you can have different actions when checking and when un-checking it.
 
As to changing grid settings using code, technically yes, though IQ does not provide any special mechanism right now. You must write directly to the Views table (using the ViewID as the key) and update some fields using ADO or DAO (both of which can be used in scripts IIRC)
 
Of course, a simpler way could be added, but don't count on it in v92, it is already a BIG update LOL
 
HTH !
 
Pierre_Admin
IQ Designer
 

jimspoon

2017/02/23 23:27

Permalink

 IQ inspires one to think of the possibilities!