Designing Longview Tables
Designing Longview TablesYou can create interactive Tables that allow users to work with a flat list of data from the database. You can also generate Hierarchies to help users manage items that are related hierarchically. Additionally, you can display a Calendar that allows users to visualize items in calendar format. For example, you could create a Table that displays salary information. On th...
Creating App tables
Creating App tablesApp 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 in...
Defining DataTable objects
Defining DataTable objectsBefore you can create a DataTable object using the Create DataTable command (or the VIRTUAL option), you must define the DataTable object in a DataTable definition. The DataTable definition defines the structure of the in-memory DataTable object. DataTable definitions are stored as ASCII files and can be created and edited in any text editor. The recommended file exten...
Creating Table View definition files
Creating Table View definition filesTable View definition files define the layout, format, and behavior of data in a Table. The Table View definition file is also referenced by the Show DataTable command used in a procedure file. Table View definitions are stored as ASCII files and can be created and edited in any text editor. The recommended file extension for Table View definitions is .lvtvw....
Creating Hierarchy View definition files
Creating Hierarchy View definition filesHierarchy View definition files define the layout, format, and behavior of data in a Hierarchy. The Hierarchy View definition file is also referenced by the Show DataTable command used in a procedure file. Hierarchy View definitions are stored as ASCII files and can be created and edited in any text editor. The recommended file extension for Hierarchy Vie...
Creating Calendar View definition files
Creating Calendar View definition filesCalendar View definition files define the layout, format, and behavior of data in a Calendar. The Calendar View definition file is also referenced by the Show DataTable command used in a procedure file. Calendar View definitions are stored as ASCII files and can be created and edited in any text editor. The recommended file extension for Calendar View defi...
Testing your Longview Table
Testing your Longview TableLongview strongly recommends testing your Longview Table before you publish your Longview App to users. Testing is considered complete after you have tested the following, if applicable to your Table:The Table loads without any initial warnings displayed to the user. The Table is read-only or editable, as desired. For more information, see Understanding why a Table is...
Sample documents for Tables
Sample documents for TablesThis section includes code samples for both persistent and virtual DataTable objects:Samples for a persistent DataTable objectSamples for a virtual DataTable objectSamples for a persistent DataTable objectThis section includes sample files that use a persistent DataTable as an example. You could create a Table that displays salary information by using similar code.The...