DataManager: New launch parameters (2.8+)

steve · June 12, 2012 7:34AM

Omniscope now supports DataManager parameters for:

File source: location path (2.8+)
URL source: URL address (2.8+)
Database block: database/instance/table names and host/port (2.8+); server-side filtering; within custom SQL
Access database: file path (2.8+)
Field organiser: default value, replace value
Record/field filters: match value
Input switch: input selection (accepts text, boolean, number)
Search/replace: search & replace values
List of values: the list itself

This means you can use a variety of mechanisms to dynamically update these form fields:

Linking two Omniscope session with different related dataset, such as stock metadata and historical prices; see: http://forums.visokio.com/discussion/comment/2188/#Comment_2188
http://forums.visokio.com/discussion/980/use-of-parameters-in-dm-formula
http://www.visokio.com/kb/empowered-refresh
http://tc.visokio.com/videos/?name=ArielCohenUsingParameterPassingAtInvestec&width=720&height=480
From Omniscope Server, using the "Set DataManager Parameter Value" XML action before refreshing from source; see http://www.visokio.com/kb/xml-actions
When launching Omniscope from a 3rd-party desktop application; see http://forums.visokio.com/discussion/1376/new-command-line-arguments-for-datamanager-parameters/p1
When launching via WebStart; see http://forums.visokio.com/discussion/1402/ilf-link-files-with-parameter-overrides-2.8-b10/p1

steve · June 22, 2012 9:36AM

List above updated to include more parameters in database blocks.

naruemon · June 27, 2012 4:58AM

Thank you for the update ^^

WKeith · June 29, 2012 7:43AM

Excellent news on release of Alpha

Does this mean that we can parameterise the SQL, so that for example we can insert a date (eg current month-end adate) into the query that is going to run?

steve · June 29, 2012 8:40AM

You've been able to parameterise the SQL since 2.6. Add at least one parameter in the DataManager left panel, and your "Edit SQL" database block tabs will show a comment:


Note: Insert parameters in custom SQL like this:
SELECT * FROM p WHERE q={{MyParameter}} 
SELECT * FROM p WHERE q IN ({{MyParameter}})

Welcome!

Categories

Ideas Parade

Tagged