Adding, viewing, updating, deleting, and exporting data tables and their data within your JunoViewer database.
3. Edit a Table
|
Philip van der Wel Administrator Posts: 145
8/7/2020
|
Philip van der WelAdministrator Posts: 145
This post is part of a series of posts titled Your Data in Your Database, guiding you through adding, viewing, updating, deleting, and exporting data tables and their data within your JunoViewer database. Click here to view an overview of the series.
From time to time you will need to edit the columns and/or the table link for an existing table in your JunoViewer database. This help post guides you through the requirements of this process, which will differ slightly depending on whether you are editing a column required for the JunoViewer query engine (e.g. Network ID, Section ID, Measurement Date, Start Location) or other columns (e.g. maintenance action, rut depth, aggregate source).
3.1 Add a column
In order to add a column to an existing table in your database, you must first contact Lonrix support and request for the new column to be added to the database. You will need to provide the new column name, data type, and whether or not the value can be null. We will add the new column directly into the database.
3.2 Link a column not required for the query engine
To link a column not required for the JunoViewer query engine, you will need to create or update the Table Definition template for the table and upload it to JunoViewer (refer to this post for more information). You must ensure the new column name and data type match exactly the name and data type provided to Lonrix Support above.
Once the new column is added to the table and your updated template is uploaded, you can use the Update Table Columns feature on the Manage Table Links page (under the Data menu) to update your table links.
3.3 Link a column required for the query engine
To link a column required for the JunoViewer query engine, you will need to delete and recreate the table links for the selected table. To do this, go to the Manage Table Links page, select the required table, and click the delete button.
NOTE: Deleting the table links will also delete Data Parameters and Join Parameters associated with the selected table. After the table links are recreated you will need to recreate any Data Parameters and Join Parameters associated with the table.
After the table link is deleted, click the Add New Table Link button which will open a page where you can create new table links for your table.
The page in the image above is very similar to the Add Table page; click here for further details.
With the table links recreated you will now be able to add data to your table, including data contained in any new columns.
edited by Kiki on 8/10/2023
|
|
|
0
link
|
