The reporting system is a useful instrument to gather, process and send data to a third party. Therefore i-doit possesses a report manager which can process all data from the IT documentation completely.
You can access the report manager via
Extras → Report Manager in the in the main navigation section. On the left side of the navigation tree the items
Online repository and
Views are displayed. In the following text, these items are described in greater detail. If the report manager or the items in the navigation tree only appear incompletely or do not appear at all, this is due to missing permissions.
Evaluate a Report
Created reports can be found in the
Reports item. When the setup of i-doit hast just been finished, there will not be any reports in this section yet.
Upon clicking on a report in the list, this report will be executed with the current data. In i-doit the results list of a report is set out in tabular from. Reports are always focused on objects and their attributes. For each line of results, the focus is on a main object and details of any attributes and relations to other objects may be indicated. By clicking a line the corresponding object will be loaded.
The table provides various functionalities (sorting and filtering of columns, pagination). Furthermore, reports can be exported into various formats (plain text, CSV, XML and PDF). Export to CSV format is recommended for further processing in spreadsheet software.
An object of the type
Object group can be created from a report. The objects from the report are assigned to the category of the same name in a static way. It is also possible to create an object of the type
Object group with dynamic object assignment. To do so, select the corresponding option in the
Type category and choose a report. From now on this object group always contains the up-to-date list of objects which are given as results by the assigned report. This happens in runtime.
Reports can be categorized. They will be associated with the
Global category by default which is always available and cannot be deleted. The advantage of categorizing is in the permissions concept: You can set permissions for access separately for each category. New categories can be created and existing ones can be edited via the
Categories item on the reports page. For this purpose, the optional description field can be helpful.
Create or Edit Reports
Reports can be copied. To do so, mark a report and click the
Duplicate button. You can delete a report via the
Purge button. This step is irreversible.
There are two ways to create a report, which will be further explained in the following.
The query builder provides a graphical interface to create a new report or to edit an existing one. The editor is opened with the
New button. Alternatively, it can be found next to the button in the drop-down field as the
query builder button. To edit an existing report, select the checkbox next to the report and click one of the buttons mentioned above.
The title and category are essential. In addition to this, it is often helpful to enter a short description.
You can test the report with the
Check button. A maximum of 25 results is displayed in a pop-up window.
The following advanced options are available.
|If the option is set to Yes, HTML is also displayed in reports.|
|This option groups multivalue entries to an object one below the other.|
This option refers to sub-queries of objects that are associated which each other. Should the attribute representing this assignment be empty, i.e. that no object is related, the result will be empty when the option is set to
There is a relation object for each relation between two objects. When you select
Some selected attributes can be sorted automatically as soon as the report is executed. With this option you can additionally choose whether you want to sort in ascending or descending order.
Output area provides a possibility to define the columns of the results list. Select the desired attributes from the three category types
custom. Each attribute defines a column. You can set the order of the rows per drag and drop.
Some selected attributes can be sorted automatically as soon as the report is executed. For this you can use the radio button next to the selected attribute. If no attribute is selected, the object ID will be the sort key.
More attributes of the associated object can be chosen via the shown magnifier when an object reference is selected as attribute. For this, another query is opened when you click on the magnifier, following the principle described above. Of course these sub-queries can also be made into sub-queries themselves (recursive).
Additionally, you have the following options:
Any desired conditions can be stated using the
Conditions item. In order to check for a particular attribute, this attribute is selected together with the matching category. After this, the logical query will be built: Which value does the attribute need to match (or not)? Typical statements such as =, !=, <, > etc. are possible here and conform to the field types of the attribute. The selection also conforms to the selected attribute.
Simple nestings using and or or are possible by setting additional conditions using the + button and condition blocks. Conditions are removed using the
- button. Empty condition blocks are removed automatically.
Conditions can be set for attributes of objects being in relation by choosing the attribute with the object relation and setting the condition to
Linked attribute. After that, more conditions can be set in additional condition blocks.
Every report can be created or edited in the SQL editor – including the ones that are created in the query builder. Starting from the
Reports overview page either click the drop-down field next to
New or select an existing report and click the drop-down field next to
Edit and choose the
Switch between query and SQL editor
The query is written in SQL in the form field
SQL query. Knowledge of the database structure of i-doit is required for this. It is important to always query objects and to select the ID of the object as the first (invisible) column:
The column names can be entered in a multilingual way and will be translated automatically by i-doit in realtime:
Design complex reports
The following approaches are useful for designing complex reports that utilize many features of SQL:
Create the report using the query builder (as far as possible)
Copy the report
Edit the copy using the SQL editor
This has the advantage that there is no need to know the database structure of i-doit and that the prepared report can still be edited using the query builder.
Some previously created reports are already available for download on the internet. These can be executed directly or saved locally via the
Online repository item. An internet connection is required for this.
iews provide additional features and views for the reports mentioned above. New ones cannot be created, existing ones cannot be edited or deleted.
Selection of useful
QR codes: Processing and printing of multiple labels simultaneously which can also contain a QR code as well as additional information and a logo.
Devices in a location (list format)
Open cable connections
Automatic Export of Reports
You can export existing reports automatically as a file without needing to intervene manually. Use the command line tool of i-doit, the controller, for this purpose. The matching controller handler is
report. When the controller is executed without further statements, the help will appear:
The handler of the controller
report expects the following parameters:
-r: The ID of the report. You can find the ID at
Extras → Report
anager → Reports.
-d: Absolute or relative path where the file is to be saved.
-f: File name of the report.
-t: Export format:
For example, the automation can be carried out by a cron job.
You can assign permissions for the report manager to users and user groups (represented in i-doit by the object types
Person groups). With
Administration → Authorization system → Rights → Report manager you can assign the following permissions:
Create new reports
Reports in categories