additional-functionalities.md

Additional Functionalities

Print PDF

For every entity in openBIS it is possible to generate a pdf using the Print PDF option from the More.. dropdown menu.

An example for a Space is shown in the picture below.

Visualise Relationships

Parent-child relationships between Objects can be visualised as trees or tables in the ELN.

To see the genealogical tree, select the Hierarchy Graph option from the More… dropdown in an entity form.

 

 

Large trees can be pruned, by selecting how many levels of parents and/or children and which types to show.

 

To view the genealogy of an Object in a tabular format, select the Hierarchy Table option from the More… dropdown.

Tables

All tables in the ELN have a similar format and functionalities. The tables have been redesigned for the 20.10.3 release of openBIS.

Here we give an overview of the main functionalities of the tables.

 

Filters

Two filter options are available form the Filters button: Filter Per Column and Global Filter. The first allows to filter on individual columns, or multiple columns, whereas the second filters terms across the entire table using the AND or OR operator. 

Sorting

It is possible to sort individual columns or also multiple columns. For multi-column sorting, you should click on the column header and press the Cmd keyboard key. The order of sorting is shown by a number in each column, as shown below.

 

Exports

Tables can be exported in different ways, using the export button shown below.

 

1. 1. Import Compatible:
      1. Yes: in this case some columns which are incompatible with imports (i.e. registration date, registrator, modification date, modifier) are not exported even if selected; some columns that are required by openBIS for imports are added to the exported file even if not selected (i.e. code, identifier, $ column). Moreover text fields are exported in HTML, to keep the formatting upon import.
      2. No: in this case all columns or selected columns are exported.

 

 

 

2. Columns:

1. 1. 1. All (default order). All columns are exported, in accordance with the selection explained above for import compatibility.
      2. Selected (shown order). Selected columns are exported, in accordance with the selection explained above for import compatibility.

 

 3. Rows:

1. 1. 1. 1. All Pages. All pages of the table are exported.
         2. Current Page. Only the currently visible page of the table is exported.
         3. Selected Rows. Only selected rows in the table are exported.

4. Value:

1. 1. 1. Plain Text. Text fields are exported in plain text, without any formatting. This option is not available if the export is import-compatible.
      2. Rich Text. Text fields are exported in HTML format.

 

Tables are exported to XLS format. Exported tables can be used for updates via the XLS Batch Update Objects. 

Note: Excel has a character limit of 32767 characters in each cell. If you export entries where a field exceeds this limit, you get a warning and the exported Excel file will not contain the content of the cell which is above this limit and the cell is highlighted in red, as shown below.

Columns

Users can select which properties to display in the table clicking on the Columns button. It is also possible to show all properties or hide all properties. The position of the columns can also be changed by placing the cursor next to the = sign in the list and moving the fields. This information is stored in the database for each user.

 

 

Spreadsheets

If a table contains Objects which have a spreadsheet field which is filled in, a spreadsheet icon is displayed in the table. Upon clicking on the icon, the content of the spreadsheet can be expanded.