How to add new column on Overview Console.

Version 8
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Remedy IT Service Management Suite


    COMPONENT:

    Remedy ITSM Foundation


    APPLIES TO:

    ITSM 9.x



    QUESTION:

    How to get a custom field added on HPD:Help Desk form as a column on Overview Console?

    Keywords:
    Custom Column
    Custom Field
    New Column
    New Field


    ANSWER:

     

    SHR:OverviewConsole is a display only form which displays data from the view form SHR:Union_OverviewConsole. Therefore, in order to add a column to "SHR:OverviewConsole" we need to create the field on "SHR:Union_OverviewConsole". The view form "SHR:Union_OverviewConsole" fetches data from the database table U_Overview_Console and hence we will have to create a column in the  table "U_Overview_Console" to be able to add a field on "SHR:Union_OverviewConsole" form. For this we need make configuration on below forms:

    1) SHR:Union_DataSource_Fields : "Here we specify the column that is to be created in the source table "U_Overview_Console".
    Link : https://docs.bmc.com/docs/display/public/itsm81/Creating+configuration+data+for+union+fields
    Note* OOTB or Custom Field, If a field label name has space, Ensure to replace space with underscore ex 
    CUSTOM_CHAR_FIELD

    2) SHR:Union_DataSource_FieldMappings : In this  form we map the column we created in step #1 with the  field which is to be added on "SHR:Union_OverviewConsole".
    Link : https://docs.bmc.com/docs/display/public/itsm81/Creating+mappings

    3) SHR:Union_ConfigurationConsole : Once Step #1 and Step #2 is completed we Build/Rebuild Database Union Structure which will actually create the column we configured in the database.
    Link: https://docs.bmc.com/docs/display/public/itsm81/Creating+mappings

    here you may see the Timeout error, Please ignore the error. System completes the action and then given this error. Please wait for 5-10 minutes to reflect the changes and then follow step 4.

    4) Create the field on SHR:Union_OverviewConsole :  Once the column is created in the database table  "U_Overview_Console", we are allowed to create the field on "SHR:Union_OverviewConsole" form.

    Link: https://docs.bmc.com/docs/display/public/itsm81/Adding+new+fields+to+the+overlay
    Here After opening the SHR:Union_OverviewConsole form, please navigate to Menu : Form >>Add Fields from U_Overview_Console. It will open the add field window where you will find the desired field. Add the field and save the form.

    5) Add the field as a column on SHR:OverviewConsole : As soon as the field is added on the form SHR:Union_OverviewConsole we can simply add this field in the table field on "SHR:OverviewConsole" by modifying the mapping in Tree/Table Property of the table z2TH_ConsolidateTable1.

    Link : https://docs.bmc.com/docs/display/public/itsm81/Adding+new+columns+to+the+table+in+the+overlay

    More Details:
    8.x >> https://docs.bmc.com/docs/display/public/itsm81/Adding+a+column+to+the+Overview+console
    9.x >> https://docs.bmc.com/docs/display/public/itsm91/Adding+a+column+to+the+Overview+console

    NOTE: Field name
     cannot have a space in the name when using Oracle.

     


    Article Number:

    000112814


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles