An intelligent folder for SENAITE
SENAITE.DATABOX behaves like an intelligent folder with a stored database query. When viewing the contents of a databox, the database query is executed and the results are shown in a table listing with the configured columns.
Each databox can be directly exported as CSV or Excel.
A databox can search at most one content type, e.g. Sample, Analysis, Client etc.
This content type must be defined on creation.
After the databox is created, all objects of the selected content type are listed and the database query can be directly refined with the controls on top of the table.
The query configuration in the controls allow to set the order, sort and the pagesize of the listed items.
The results can be further narrowed down to a specific date region by choosing a "from" and "to" date on one of the displayed date indexes.
The advanced query tab allows to filter the results by a certain catalog index.
☝️Note:
Catalog indexes can be added through the web in SENAITE, see https://zope.readthedocs.io/en/latest/zopebook/SearchingZCatalog.html#defining-indexes
The columns define the display fields of the results table (similar to a SELECT
in SQL). If a field references another content type, e.g. a Sample has a
reference to a Client, then it is possible to traverse these references to
integrate the fields of the target object.
☝️Note:
Some types provide a "virtual" Parent field to traverse to the parent object
that holds the current object. For example an Analysis is contained in a
Sample (Analysis Request). Therefore, the Parent field reveals the
Sample where the current Analysis is in.
The info tab shows the generated database query and is mosly for debugging purposes.
Each databox allows export of the results with the configured columns and order to Excel or CSV through the two icons in the upper right corner.
SENAITE.DATABOX Copyright (C) RIDING BYTES & NARALABS
This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License version 2 as published by the Free Software Foundation.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.