key – The data which is downloaded into your LIMS when this item is selected value – The data which is shown to the user on the New Order page rel – The relationship column, this value is ignored for deep lists. filter – If specified, only users with this filter can see the item on the New Order page
Product Name – This will be a field on the New Order Page labelled “Product Name”, when a user selects the key, the value in this column will be filled into the field Price – This will be a field on the New Order Page labelled “Price”, when a user selects the key, the value in this column will be filled into the field
After selecting the Deep List property type you will be asked to select a list that you would like to bind to the property. Selecting the above list will give you the following options:
The checkboxes under the list name are the fields which are visible. Enabling the “Product Name” and “Price” fields will give you a simple deep list which looks up those two values:
For details of the “Enable Add New” feature, please see List Learning.
List are a platform component of labPortal that are used in a number of areas of the system. An example is where lists are used as reference lookups for order properties in the Orders Module.
A list comprises of a name and list items. Each list item has a ‘key’ and ‘value’ property. The ‘key’ needs to be unique for a list. To support linking lists a list item can have a ‘rel’ property which would be the parent, linked list id. To support list filtering a ‘filter’ property exists. When a user is accessing a list and filters associated with user will be applied so that the list items are filtered.
Lists are a tab on the Settings > Configure Page
Only site administrators can configure labPortal and have access to the Configure page.
The easiest way to add lists to labPortal is via the Excel upload. A template is available that you can use to start populating your lists. The worksheet name maps to the list name that you would like to use. You can use multiple worksheets for multiple lists.
Once you have populated your Spread sheet you can use the upload functionality to populate labPortal. If you already have a list it will get overwritten.
New lists can be created by entering the list name in the New List text box and pressing add
Once a list is selected list items can be added using the simple add form
The list can also be downloaded as a template, which you can update and then upload again. This will often be easier for large edits.
There are some scenarios in labPortal that a simple key pair list is not enough. To support this scenario list items can have extra meta data associated with them. If you add extra columns to the spreedsheet template;
The upload process will take the extra columns and save the column data as a data node for each list item. Data nodes can be viewed on a list item by clicking the horizontal 3 dots button. When clicked a module window will open displaying all the values for the list item.
The modal window
The additional properties for the schema can be viewed and edited from the Data Schema Modal window which can be view by clicking on the Cog button that sits in the header row of the table next to the Data label.