niota

Any table or view that should be managed by niota must be configured as a so called catalog object. Every catalog object has a unique ID by which this object is referenced later on. See below how to create a catalog object.

navigate to the menu item

• add/edit a record → enter valid values for fields listed below

Unique ID for this catalog object. The catalog object ID for customer objects must be positive integer numbers. Negative integer numbers are reserved for system catalog object.

Database connection where object is stored. Via this connection access to the database object is established.

Physical name of the object on its original source database.

Short description of the object.

Date when object is logically activated in niota. Activation date is optional and not parsed or used anywhere.

Optional custom defined category to group catalog object by your needs. On grid edit page catalog object can be filtered by object category by default.

Name of a formatter file without file extions. The formatter file is used to execute format option. The formatter file must be on the server in a subfolder which name matches the name of the database connection for this catalogobject.

ID of an user account who is the data owner of this catalog object. There are some APIs which return this data owner so it can be used in own scripts.

ID of an usergroup which is the deputy group for data ownership. There are some APIs which return this deputy group so it can be used in own scripts.

protected - Checkbox to switch off logging for this object in case table is populated via Excel(R) upload

Checkboxes for custom use only.

An instance is a default or a configured representation of a catalogobject. By default for every catalog object the *default instance is created. You must not delete the *default instance of an catalogobject. If you want to have different represenations of a single physical object (table of or view) you can create different instances of this object with totally different settings.

Logical name for this instance. Do not use * anywhere in the name of your instance. * is a reserved character for system instances.

Description of instance to be used within niota.

List of columns in SQL notation in case not all columns should be selected or in case additional function on columns should be applied. When Join is used the columns must be qualified. See [niota_system_config_defaults|system defaults file]] for qualifier options.