When you import data , a corresponding Grid View is automatically generated for you. The Grid View offers a representation of the table and the data it contains, enabling you to both view and edit the data. Because the View is synchronized with the database table, any edits you make will cause the database table to automatically update.
You can open the Grid View of a table in your project by double-clicking the Grid View node () of a selected table Entity in your project, as displayed in the Projects window. Alternatively, choose Open from the Grid View node's right-click menu.
The following table lists the Grid View icons and their descriptions. These icons are located in the tool bar found above the Grid View in the main window. Many of these actions can also be accessed from the right-click menu of the column headers row:
Add a new row to the end of the data
Delete the selected row(s)
Create a new standard field
Create a new chemical terms field
Create a new calculated field
Delete the selected field
Send to query panel as new query
Add to query panel as new term for the current query
Add/remove from working list
Create new list using current rows/selection
Customize table widget settings
|Filter search results|
|Load all convergent child data|
The grid view has three modes, Browse, Query and Code. In Browse mode you can explore the data whilst in Query mode your can specify criteria for a query and run the query. You switch between the modes using the Query/Browse/Code toggle buttons located in the left hand side of the Grid View toolbar. The Browse mode is shown while opening Grid view, unless initial data retrieval is switched off. In this case query mode is shown instead. The Code mode allows you to customize certain events(like double-click) in the table by using Groovy scripting language. This might be used for a custom input form for a given field for example.
In the grid view you would usually navigate through the data using the horizontal scroll bar and select records using the mouse. But you can also use the navigation tools in the main toolbar.
You can move forward or back, and move to the first or last record by using the navigation buttons. You can jump to a particular record by clicking in the text box that displays the current selection and typing the record number that you want to go to. e.g. to move to the 123rd record click in the box type 123 and hit the return key.
The navigation toolbar has global context. Its contents correspond to the currently selected view. Changing the selected view will result in the context of the navigation toolbar updating.
Data can be sorted by a particular column, or multiple columns. This can be done using the sort buttons in the main toolbar:
Sort column in ascending order
Sort column in descending order
Clear current sort directives
Open the Sort Table dialog
Table display settings can be adjusted according to your needs. Open the Table Widget Settings dialog by clicking the icon () in the toolbar or choosing Customize Widget Settings from the right-click menu of the column headers row. The Table Widget Settings dialog allows you to adjust the column and cell properties of elements within the table.
Typically, each field type has its own display settings options. Of particular note are:
To adjust table or column properties:
Additionally, the Grid View (Table) itself has multiple settings. The settings specific for the table itself can be displayed by selecting the 'Table settings' on the left side of the 'Table widget settings' dialog. Here you can adjust the properties of the grid view itself, such as header properties. In the 17.1.2 version of Instant JChem, the freeze column functionality was introduced. The frozen columns are always the most left ones and their number is set in the 'Table Settings' dialog. This is especially useful for wide tables, when the frozen columns do not move while the remaining columns can be scrolled horizontally.
Please keep in mind that the ‘freeze columns’ feature will not manifest in case the ‘Fit table to screen’ functionality is turned on.
You can adjust the Grid View to improve visibility by clicking the button () located in the top left corner of the Grid View. The following menu displays:
From here you can:
The Column Manager provides a simple way to organize the column in the table. You can use it to re-order the columns and to show/hide columns. Multiple columns can be changed in one go, including using drag and drop to re-order the columns.