Example: Field mapping

The Category breakdown maps the Category field on the incident table to the Incident.Category breakdown source, which references the Choices[sys_choice_list] table.

Example

In the first image, you see the Category breakdown with the Incident.Category breakdown source. This breakdown has a breakdown mapping to the Category field on the incident table.

Category breakdown form showing breakdown source of Incident.Category and mapping to the category field on the incident table

The Incident.Category breakdown source uses records in the Choices[sys_choice_list] table.

The filled out breakdown source form for Incident.Category, showing facts table, field, and conditions

The next image shows the Choices[sys_choice_list] table records that meet the conditions that are specified in the Incident.Category breakdown source. Note the Label field values.

Filtered choice table records corresponding to breakdown source example.

Finally, you see the Category field of some records on the Incidents table. This field is mapped to the Category breakdown. The field values match the Label fields of the records of the Choices[sys_choice_list] table that the Incident.Category breakdown source filters for.

Category fields of Incident records. Field values match the Label field on the Choices table, to which the Category field is mapped.

Versions

Contents