Not all user relevant data can be captured using an LDAP or database
query. Table data are also generated by some specific script actions,
in which case the collected data are stored in a variable, instead of
being generated as part of a form table object. UMRA comes with several
built-in script actions producing table output, stored in a variable:
Generate
generic table - script action to generate a generic table (LDAP query,
database query or variable) and store the result in a variable for further
processing ;
LDAP script actions to access other (non-Active
Directory) directory service like Novell eDirectory and Linux OpenLDAP
;
Manage
table data script action - script action for creating, editing, and
merging tables. See section Programmatically
creating and evaluating tables for more information.
Projects making use of these script actions, usually consist of two
parts. The first project, or "auxiliary" project can be defined
as the project in which the project data are collected using one of the
above mentioned script actions. The result is stored in a variable. In
the second project, or "main" project, a table of the variable
type can be inserted to show the contents of this variable. Script actions
can then be executed for selected rows in the table (see the figure below).
The practical use of this powerful concept is illustrated in the following
two figures. Project A contains the script actionList services status.
The result of this script action is stored in table format in a variable
called %ServicesTable%.
Project A - Running a script action
collecting data in table format. The results are stored in a variable.
By defining project A as an initial project in project B, the script
in project A will be executed before the form of project B is displayed.
The variables in project A will be passed to project B. In project B (see
figure below), a generic table of the variable type can now be inserted
in the form window to display content of the variable %ServicesTable%.
Project B - The content of the variable
is now displayed using a generic table of the Variable type
Generate Generic table - Script
It is also possible to perform LDAP queries and database queries as
part of a script action and have the result stored as a variable. This
is done using the script action Generate
generic table. The principle of operation is identical to the one
described above.
Programmatically creating and evaluating
tables
Using the tables described in this document, you should be able to manage
table data for most user management tasks. There are situations however,
where these standard tables may not be sufficient:
You wish to evaluate an existing table programmatically
and / or create a new table from scratch ;
You need to combine data from the tables described
earlier, with data which are not contained in a table.
In such cases, you can use the For-Each
and Manage table data
script actions to create your own tables.
Next topics:
UMRA tables - Assigning selected
table entries to a variable
