Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Designing Longview Tables

You 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 the other hand, you could create a Hierarchy that displays symbol information.

Creating a Table, Hierarchy or Calendar consists of the following steps:

No.

Step…

Document/command to use

1

Create an App table in your database. For more information, see Creating App tables.

Note: This step is not necessary if you plan to create a virtual DataTable in step 2.

 

2

Define the DataTable object (for Tables, Hierarchies or Calendars) based on the App table or by defining a virtual DataTable (for Tables and Hierarchies only). For more information, see Defining DataTable objects.

Data Table definition (.lvdtd)

3

Create an in-memory DataTable object based on the DataTable definition using the Create DataTable command.

Procedure (.lvpro)

4

If you want to present a pre-populated Table, Hierarchy or Calendar to users, use the Download (for DataTables) command to populate the DataTable object with data from the database. Alternatively, you can use an ImportSpec or the Insert DataTableRow command.

Procedure (.lvpro)

ImportSpec (.lvimp)

5

Define how the information in the DataTable object will render in the Table, Hierarchy or Calendar user interface.

For more information, see Creating Table View definition files, see Creating Hierarchy View definition files, or Creating Calendar View definition files.

Table View definition (.lvtvw)
Hierarchy View definition (.lvhvw)
Calendar View definition (.lvcvw)

6

Use the Show DataTable command in the relevant procedure to display the DataTable object as a Table, Hierarchy or Calendar. Alternatively, you can use the Show UI command to include it in a tabbed App.

Procedure (.lvpro)
App UI file (.lvui)

7

Test your Longview Table and make changes as needed. For more information, see Testing your Longview Table.

All supporting files (.lvapp, .lvpro, .lvdtd, .lvtvw, .lvhvw, .lvcvw, .lvui)

8

Deploy your Longview App. For more information, see Deploying Longview Apps.

All supporting files (.lvapp, .lvpro, .lvdtd, .lvtvw, .lvhvw, .lvcvw, .lvui)
Published:

Designing Longview Tables

You 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 the other hand, you could create a Hierarchy that displays symbol information.

Creating a Table, Hierarchy or Calendar consists of the following steps:

No.

Step…

Document/command to use

1

Create an App table in your database. For more information, see Creating App tables.

Note: This step is not necessary if you plan to create a virtual DataTable in step 2.

 

2

Define the DataTable object (for Tables, Hierarchies or Calendars) based on the App table or by defining a virtual DataTable (for Tables and Hierarchies only). For more information, see Defining DataTable objects.

Data Table definition (.lvdtd)

3

Create an in-memory DataTable object based on the DataTable definition using the Create DataTable command.

Procedure (.lvpro)

4

If you want to present a pre-populated Table, Hierarchy or Calendar to users, use the Download (for DataTables) command to populate the DataTable object with data from the database. Alternatively, you can use an ImportSpec or the Insert DataTableRow command.

Procedure (.lvpro)

ImportSpec (.lvimp)

5

Define how the information in the DataTable object will render in the Table, Hierarchy or Calendar user interface.

For more information, see Creating Table View definition files, see Creating Hierarchy View definition files, or Creating Calendar View definition files.

Table View definition (.lvtvw)
Hierarchy View definition (.lvhvw)
Calendar View definition (.lvcvw)

6

Use the Show DataTable command in the relevant procedure to display the DataTable object as a Table, Hierarchy or Calendar. Alternatively, you can use the Show UI command to include it in a tabbed App.

Procedure (.lvpro)
App UI file (.lvui)

7

Test your Longview Table and make changes as needed. For more information, see Testing your Longview Table.

All supporting files (.lvapp, .lvpro, .lvdtd, .lvtvw, .lvhvw, .lvcvw, .lvui)

8

Deploy your Longview App. For more information, see Deploying Longview Apps.

All supporting files (.lvapp, .lvpro, .lvdtd, .lvtvw, .lvhvw, .lvcvw, .lvui)
For an optimal Community experience, Please view on Desktop