The Global Lists module allows authorized users to manage data lists from the Administration Module to be used with web forms.
Global Lists management provides a solution to manage and centralize data to fill drop-down lists in your web forms.
There is no limit to the number of items in a Global List, which can have up to 20 columns. Good user interface performance depends on the number of cells (items × columns), and is optimized for at least 5000 cells (for example, 1000 items with 5 columns or 250 items with 20 columns).
The supported data types for columns are text, numeric, or date.
The data that populate a Static Global List come from within the user interface.
The data that populate a Dynamic Global List come from a database. The content of the list is updated each time the web form is executed.
Click the Define link to define or edit a global list.
You can import data into a global list from a file or a copy of your clipboard. The supported formats are WorkflowGen Global List XML or CSV.
The CSV format must be as follows:
By default, columns are considered as text data types; therefore, if all columns are text data types, it is not necessary to specify the data types.
AE,United Arab Emirates
AG,Antigua and Barbuda
In this case, the second line is used to set the columns’ data types.
2,AE,United Arab Emirates
4,AG,Antigua and Barbuda
To protect some data like double quotes, commas, etc., you can enclose the string with double quotes.
1,DOE,John,"1111 N. Sample, Mt. Prospect, IL 60000","01/01/1980"
You can export data from a global list to a file. The supported formats are WorkflowGen Global List XML or CSV.
All connection strings in
\wwwroot\wfgen\web.configare available for use in Global Lists and the Form Designer except for the master database connection string. While the application tries to verify that user-supplied SQL queries used in these contexts are secure and contain only SELECT statements, you should also make sure that exposed connection strings are secured at the database level. This means that if you don’t want a process manager or a Global List manager to be able to update or modify a certain database, the connection string should have read-only access to your database.
Keep in mind that process designers can also use any connection string that they have access to from the Form Designer’s code-behind editor. If you want to restrict a Global List manager’s access to a connection string, while still allowing the process designer to use it, you should add the connection string to the WebForm application’s
Connection strings in the WebForms
web.configare not exposed in the WorkflowGen UI, so for process designers to be able to use them, they must know the name of the connection string. This is also a convenient way to give different process managers access to specific connection strings.