Documentation

Get List or Choice Column Settings

How to get data from other applications to define a List or Choice columns
displayed, stored values, or stored settings selection data.

What are advanced Get column settings?
Get settings are utilized to get a List or Choice columns user selection and stored criteria from an external
application, such as an SQL database, web http service, or custom command application.

SQL Settings

How to define SQL Get settings
SQL get settings allows you to define the list or choice settings from an SQL Query. The following example
demonstratessample settings for getting data from a MYSQL server.
The Server Driver is the Java Class driver name, com.mysql.jdbc.Driver for example.
The Connection URL is the Java URL connection string for the SQL Server,
jdbc:mysql://192.168.2.1:3306/databasename?user=username&password=passwd&useOldAliasMetadataBehavior=true for example.
The SQL SELECT Statement is the SQL Query, SELECT * FROM TableName for example. The SQL query should return at least 2 columns, 3 for defining List column stored settings attributes. The first column is assumed to be comma separated items for the List or Choice displayed items, the second column is assumed to be comma separated items defining the List or Choice Stored Values, and the third column is assumed to be comma separated Stored Settings for List columns.
* View the Java JDBC api documentation and standard SQL query language online for additional details on these industry standard settings.

URL Settings

How to define URL get settings
URL get settings allows you to define the list or choice settings from a web services, such as php or asp scripts.
Example URL setting, http://www.mywebsite.com/choices.php
The return from the url must be in the following format. You must convert/escape all attributes for the special xml characters.

<Choices displayed="A,B,C" values="1,2,3" settings="one,two,three" />
* This example assumes you have knowledge of http web services, URL and XML syntax.

Command Settings

How to define Command push settings
Command get settings allows you to define the list or choice settings from a command driven application, Java or C# for example.
Example Command setting

C:\Java\JRE\java.exe -classpath . mygetcommand
* This example defines executing a java program
The return string from the command STDOUT must be in the following format. You must convert/escape all attributes for the special xml characters.

<Choices displayed="A,B,C" values="1,2,3" settings="one,two,three" />
* This example assumes you have knowledge of command line scripts and XML syntax.