Creating App Tables
App tables are the database tables in which data related to DataTables is stored. Unless you plan to create a virtual DataTable using the DataTable definition, you must create an App table to store information for Data Tables that is not related to your Longview multidimensional database. Currently, you must create these tables manually in the supported databases.
For more information, see the “Understanding meta tables related to App tables” section in the Longview Installation Guide.
The SQL or Oracle column data types that you choose when you create the table determine the Longview data type and, ultimately, the user controls in the user interfaces. For information on how the Longview data types correspond to SQL and Oracle data types, see the Longview Installation Guide.
| User Control | Longview Data Type | Example |
|---|---|---|
check box |
Boolean |
|
calendar control |
date |
|
text box (valid numbers only) |
number |
|
text box, drop-down list, or a combo box (depending on whether the Values and AllowOverride keywords are used) |
string |
|
drop-down list populated with users in the system |
user |
|
multiple-selection list populated with users in the system |
userlist |
|
drop-down list populated with the dimensions in the system |
dimension |
|
|
Longview Symbol Selector for the dimension or linked dimension column specified by DATAVALUES (for more information on DATAVALUES syntax, see the Longview Installation Guide) |
symbol |
|
button that opens the Longview File Attachments dialog |
file |
|
read-only text box that the system automatically increments by 1 starting at the number specified for the DATAVALUES (for more information on DATAVALUES syntax, see the Longview Installation Guide) |
autointeger |
|
read-only text box with the username of the currently connected user |
autouser |