Introduction

Fields replaces the old additional fields functionality. The old functions have been updated and adapted to the new access methods. Other than this, the functions should work the same as they always have. 

Open-AudIT can store information in additional fields that are associated with each device.

...

To make another network go to menu -> Admin : Manage -> Fields -> Create Field. 

Image Added

Image Added

 Image Removed

View Field Details

Go to menu: Manage -> Admin -> Fields -> List Fields.

Image Removed

...

...

Image Added

Database Schema

Create Table: CREATE TABLE `fields` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL DEFAULT '',
  `org_id` int(10) unsigned NOT NULL DEFAULT '1',
  `group_id` int(10) unsigned NOT NULL DEFAULT '1',
  `type` enum('varchar','list') NOT NULL DEFAULT 'varchar',
  `values` text NOT NULL,
  `placement` enum('custom','system') NOT NULL DEFAULT 'system',
  `edited_by` varchar(200) NOT NULL DEFAULT '',
  `edited_date` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

Example Database Entry

Field

Image Removed

Fields are stored in the database in the "additional_fieldfields" table. A typical entry will look as below. 

       id: 3

 group_id: 1

     name: Additional Field

...

         id: 1
       name: Ink Type
     org_id: 2
   group_id: 8
       type: varchar

...

     values:

...

 
  placement: custom
  edited_by: Administrator
edited_date: 2017-05-22 00:26:38

API / Web Access?

You can access the /fields collection using the normal Open-AudIT JSON based API. Just like any other collection. Please see the API documentation for further details.

...