Set Column Visibility

In the DatabaseSchemaConfig.xml file you may use the Visible attribute to determine whether the user is permitted to view columns in Responder Explorer. The default value is True, columns may be viewed.

Setting the Visible field to "false" easily removes the column from the user interface in Responder. Note that this value is case sensitive. The true/false value must be all lower case. Setting the Visible attribute to "true" doesn't automatically make the column visible in Responder's user interface. You may still need to define within the controls whether and where the field is displayed.

In the example below the Hazard field is removed from the Incidents tab (Figure 1) and the Edit Incident window (Figure 2).

Figure 1, Hazard column on the Incidents tab

Figure 2, Hazard field on the Edit Incident window

If the Visible attribute is set to "false" on the Hazard column in the RX_INCIDENTS table of the DatabaseSchemaConfig.xml file, the Hazard field is removed from the Incidents tab (Figure 3) and the Edit Incidents window (Figure 4).

	Copy Code
<Table Name="RX_INCIDENTS" Caption="Incidents" RowCaption="Incident ID: [ID]" Adapter="Miner.Data.Responder.Adapter.DefaultAdapter" Represents="Incidents"> <Columns> <Column Name="ID" Caption="ID" Represents="ID" IsPrimaryKey="true" Sequence="RX_INCIDENTS_ID_SEQ"/> <Column Name="STATUS" Caption="Status" DefaultValue="0" Domain="INCIDENT_STATUS" Represents="Status"/> <Column Name="REGION" Caption="Region" Domain="REGION" Represents="Region"/> <Column Name="CRITICAL" Caption="Critical" DefaultValue="0" Domain="CRITICAL" Represents="CriticalCustomer"/> <Column Name="HAZARD" Caption="Hazard" DefaultValue="0" Domain="HAZARD" Represents="Hazard" Visible="false"/> </Columns> <CalculatedColumns> <CalculatedColumn Name="DURATION" Caption="Duration" Represents="Duration" DataType="String" Expression=""/> </CalculatedColumns> </Table>

Copy Code

<Table Name="RX_INCIDENTS" Caption="Incidents" RowCaption="Incident ID:  [ID]" Adapter="Miner.Data.Responder.Adapter.DefaultAdapter" Represents="Incidents">
  <Columns>
    <Column Name="ID" Caption="ID" Represents="ID" IsPrimaryKey="true" Sequence="RX_INCIDENTS_ID_SEQ"/>
    <Column Name="STATUS" Caption="Status" DefaultValue="0" Domain="INCIDENT_STATUS" Represents="Status"/>
    <Column Name="REGION" Caption="Region" Domain="REGION" Represents="Region"/>
    <Column Name="CRITICAL" Caption="Critical" DefaultValue="0" Domain="CRITICAL" Represents="CriticalCustomer"/>
    <Column Name="HAZARD" Caption="Hazard" DefaultValue="0" Domain="HAZARD" Represents="Hazard" Visible="false"/>
  </Columns>
  <CalculatedColumns>
    <CalculatedColumn Name="DURATION" Caption="Duration" Represents="Duration" DataType="String" Expression=""/>
  </CalculatedColumns>
</Table>

Figure 3, Incidents tab

Figure 4, Edit Incident window

Some columns are listed in multiple tables. For example, the Hazard column appears in RX_INCIDENTS as well as RX_CALLS. Modifying the column in the RX_CALLS table affects the Hazard field on the Calls tab in the Edit Incident window, not the fields mentioned above.