Data can be viewed in the main window. IJC currently supports two View types, the Grid View in Instant JChem, which emphasizes data display from a single database table, and the Form View, which gives more focus to a single record within an Entity. Views belong to a Data Tree, and multiple Views of a Data Tree can be open at the same, with content selection automatically being synchronised between Views. Similarly, if you run a query or change the sort directives then all Views belonging to that Data Tree will update.
The Grid View allows your to view data in a tabular fashion. It is similar to a spreadsheet. The data is organised strictly in a row and column paradigm. Unlike many tools, very large set of structures can be viewed and rapidly scrolled in the Grid View.
The Form View lets you design a form that displays your data. You add display Widgets to the Form, and bind them to particular Field(s). Each Widget can be re-sized and re-positioned, allowing you fine grain control of the design. Relational data can be displayed, with the contents of the Widgets updating to reflect the current content and selection.
One of the Widgets that that can be added to a form is the same Table Widget that is used in the Grid View. Thus the Form View can be thought of as a super-set of the functionality from the Grid View. However it is more complex to use.
To open a view, expand the Data Tree node () in the Projects window, then double-click either a grid view node ( ), or a form view node ( ). Alternatively, choose Open from the view node's right-click menu. The selected view appears in the main window.
To create a new view for a selected table, right-click a selected Data Tree node () in the Projects window and choose New View. The New View dialog opens:
When working in a view, supported functionality includes:
Unlike most of the other artifacts that you deal with in Instant JChem ( Schemas, Entities, Fields, Data Trees etc.) which are shared between all users, a View belongs to an individual user. This means that you can make whatever changes you want to a View, and you will not affect other users Views. This is important when using a remote database in multi-user mode, where each user might only have read-only access to the core data model components, but will wish to create and modify their Views, even if they can't modify the underlying model or the data within it.
IJC allows views to be shared between multiple users in two distinct ways:
By performing query or opening a view in Instant JChem, a result set is created. Instant JChem supports distinguishing each result set by a coloured stripe at the bottom of the tab. There is currently a maximum of 12 colours supported.
Any view for a given Data Tree that is open in the same result set will display the same records. For example if you run a query in Grid View and then open a Form View of the same Data Tree, it will show the same records.
This feature could be for example useful for comparing results of 2 or multiple different queries on the same data. Other possible application could be querying in a Grid View, then opening a Form View that shows only some fields that are needed; and printing a report from that view without a need to re-apply the query.
If you clickicon in the right side of the open form, the same form will open in a new tab with an independent result set (containing the same data) that you can manipulate.
The behaviour can be described in the following way: