Help

Schema

The schema module allows the user to define new tables and change existing ones. Foreign keys may be defined too.

Forms

There are two main types of forms: List forms and detail forms.

List forms

A list form has two sections: A search panel, and a result section. In the search section, the user may enter search parameters. When the user presses the search button, the result will be presented below the search panel. The search result might be editable. At the bottom of the result section, there are a row for adding new data.

To create a new form, the user first define which table the form should be based upon. Next the user define which columns that might be used as parameters in the search panel. If a given column has a foreign key, the user might pick a column in the related table for presentation.

After the parameter section, the user define which columns that should be presented in the result section. Related columns (by foreign keys) might be presented here too. The user also define if the column should be editable, editable only at insert, read only or hidden (advanced use only). It is also possible to define links. A link is a way for the user to navigate from one row in the list form to another form. To be able to do this, it need to foreign keys defined, referencing to the form table. There also need to be an existing form in the related table with the foreign key columns in the parameter list.

Finally, it is possible for the user to define a detail form corresponding to this list form. If a detail form is defined, the user might click one row in the list form and get to another form showing this form in detail.

Using the settings made, a select, update, insert and delete statement will be generated. For advanced use, it is possible to edit these generated SQL statements.

Detail forms

A detail form is a form showing details about one single row. It is defined in a very similar way as a list form, but the select query is assumed to only return one single row. This means that the parameter list need to contain identifying columns.

Charts

Two types of charts are currently supported, pie charts and bar charts. Both types of charts needs two columns of data. For example one row for every single task status containing the status text and the number of tasks having that status.

The first step when defining a chart is to select a table. Next a number of parameters might be defined, in the same way as list forms. Next a single column will be selected. This column will be the grouping criteria for counting the rows in the table.

Similar to list forms, the generated select statement might be edited for advanced use.