DB Editor - Open Table

All the InfoWater project data including data related to the different InfoWater data elements such as pipes, junctions, tanks, reservoirs, pumps and valves are stored in the DB Tables. The Database Editor allows the user to open any InfoWater database and edit/modify or delete user input fields (except ID). To access the DB Tables, from the InfoWater Control Center →  InfoWater button →  Edit menu, select DB Editor to see the Open Table dialog box below.

From the Open Table dialog box,  you can see that InfoWater stores database tables in nine separate folders. After selecting the desired table from under the relevant folder, you have the option of choosing a display scope found at the bottom of the dialog box to open the desired records of the database. Once this is done, click on the OK button to open the database table.

Data Table - Display and select the DB table to open from this list:

• Collapse All - Use this to collapse the sub-folders on the DB Tree.
• Expand All - Use this to expand all of the sub-folders on the DB Tree.

Data Scope - Use this section to specify the view selection of the DB Table. Choose from the following options:

• Entire Table - Use this to open the entire table. Data pertaining to all the elements will be displayed.
• Domain - If a domain has already been created, use this option to display data relating to elements in the domain. Click here for more information on how to create a domain.
• User Selection - Use this to select the elements that you want to see data for. Choose this radial button and then click on the Select icon. Select all the elements that you want to see data for and then right click to open the DB Table.
• DB Query - Use this option to create a query to view only those elements that satisfy your query. Click on the Query Builder button to create your query. Refer to the section on DB Query Methodology for details on creating DB queries.
• Selection Set - Select a predefined selection set. Click here for Selection Set Methodology.
• Element ID - Enter an element ID or a list of element IDs separated by commas or use the Select button to select elements from the map display.
• Sort Alphabetically - Sorts the list of elements alphabetically.
• Edit Active Elements Only - If selected, this option displays only active elements. Inactive elements will not be displayed.
• Desired Data Set – This field is context sensitive (e.g., Demand Set) and works only with element hydraulic data, extended modeling data, control data, water quality data, pattern & curve data, and SCADA settings. The name will change depending on the data selected. It allows the display and selection of DB tables from the list of data sets available for editing. The default is the current active data set but any data set may be selected for editing. Click on the Browse button to edit/create/delete a particular data set in a dataset dialog box. Refer to the section on Dataset Manager for details about editing/creating/deleting a dataset.
• OK - The OK button completes the selection process and opens the DB Editor.
• Cancel - The Cancels button ends all operations and closes the Open Table dialog box.