Source Type
Specifies the source type where a new Source Type is to be used. Source Types that can be used with Form Builder are Table, Query, View, and rowsources:
Table
This Source Type points to a specific table in the database. This Type can return all the fields in that table. Source Parameters include:
- Table name - For example, project.
- Primary key sequence - Specify a sequence when inserting records. For example, seq_butvr_id.
- Primary key field index - Displays a column number of where Primary Key resides. For example, 1.
Query
Allows user to specify custom SQL statements varying in complexity. Source Parameters include:
- SQL query - Standard SQL query.
- Primary key field index - The column number where Primary Key resides.
- Extra query parameters - Used for jdbc parameters, usually looking for variable names or constants used with jdbc.
View
Points to a specific view in the database. This type returns all the fields in that table. Source Parameters include:
- View name
- Table name
- Primary key sequence - Used for specifying a sequence when inserting records.
- Primary key field index - The column number where Primary Key resides.
Cross Tab
A specialized rowsource for creating cross-tab reports. Source Parameters include:
- Base Data SQL - The SQL query that returns data to be summarized.
- Row Headings - A comma separated list of rows to use as the grouping of data.
- Column Heading - Column to use as heading.
- Column Head SQL - The SQL query that returns a set of possible column headings.
- Operation - The options are SUM, AVG, MAX, MIN.
- Operation Argument - The column to use as argument in an operation.
- Add Else Case - Includes data not belonging to column headings listed.
- Add Row Summary - Includes a row summary column.
[rowsource]
In certain situations, the Form Builder Data Source control type “query” does not provide an efficient means to specify the data source. For example, if you want to use complex SQL queries. When the SQL queries become complex and inefficient to handle special cases, use rowsources.
In the following example, the user specifies a view called View_Recipient_Message for a data source (for example, dsView) to which the user links a Label control. The view displays the data when the report is run.
EMPLOYEE
Returns employee attributes as of the given date.
Parameters:
- EmpId : Required employee ID (that is, emp_id field)
- WorkDate : Required date
EMPLOYEE DEFAULT LABOR
Returns employee default labor table attributes as of the given date.
Parameters:
- EmpId : Required employee ID (for example, emp_id field)
- WorkDate : Required date
EMPLOYEE BALANCE
Returns employee balance attributes from the given date and balances.
Parameters:
- EmpId : Required employee ID (for example, emp_id field)
- WorkDate : Required date
- BalanceNames : Required balance in comma-delimited format (that is, VACATION,SICK). Use an asterisk (*) for all balances.
METRICS.PAGE
Provides access to page metrics gathered by the WFM system using the PageMetricsSource class. See the Troubleshooting chapter of the Time and Attendance Implementation and Administration Guide.
MAINTENANCE_SCHEDULE
Returns information for registry variables found under system/security/maintenance.
PROP.JAVA
Returns information for standard Java system properties, using the System.getProperties(); method.
CONDITION
Returns information for registry variables found under system/rules/conditonclasses.
SEC_EMPLOYEE_LOOKUP
Returns employees based on security registry parameters.
SEC_WORKBRAIN_TEAM
Returns security teams.
Examples of Table and Query source types are shown in the sample reports of this document.