How to add a column to the Overview console

Version 9
    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 IT Service Management Suite


    APPLIES TO:

    Remedy IT Service Management Suite 8.X 9.X



    PROBLEM:

    HOW TO  Add a new column on Overview console. 

     


    CAUSE:

    Customize Overview Console


    SOLUTION:

     

    Adding a column to the Overview console:

    Once it is determine which field or value to include on Overview Console, follow below steps.  
       
    1. Creating configuration data for union fields
    2.  
    3. Creating mappings
    4.  
    5. Building the database union structure
    6.  
    7. Adding new fields to the overlay
    8.  
    9. Adding new columns to the table in the overlay
      

    1.      Creating configuration data for union fields

             User-added image  
       
    • Open the SHR:Union_DataSource_Fields form in New mode.
    •  
    • From the Implementation Area menu, select Overview console.
    •  
    • In the Union Field Name field, type the name of the custom character field.
    •  
    • Provide a value for the Union Default Value field (Optional).
    •  
    • Use the Status field to set the status and save the record.
      
       

    2.      Creating mappings:

            User-added image
       
       
    • Open the SHR:Union_DataSource_FieldMappings form in New mode.
    •  
    • From the Implementation Area menu, select Overview Console.
    •  
    • In the Source Form field, select the source form — for example, HPD:Help Desk.
    •  
    • From the Select Source Field menu, select Custom Field.
    •  
    • Using the Union Field Name menu, specify the field for the union field name
    •  
    • Use the Status field to set the status and save the record.
       

    3.      Building the database union structure

             User-added image  
       
    • Open the SHR:Union_ConfigurationConsole form either in Search mode or New mode.
    •  
    • From the Implementation Area menu, select Overview Console.
    •  
    • Click Build/Rebuild Database Union Structure.
      This action removes the previous database union structure and replaces it with the new union fields and mappings.
       

    4.      Adding new fields to the overlay

           Open BMC Remedy Developer Studio in Best Practice Customization mode.  
       
    • In the Form list, locate the SHR:Union_OverviewConsole form.
    •  
    • If an overlay has not yet been created for the form, right-click the form name in the list and select Create Overlay.
    •  
    • The form opens automatically.
    •  
    • If you did not create the overlay in the preceding step, double-click the form name in the Form list to open it.
    •  
    • In the view that you are customizing, select Create View Overlay from the Form menu.
    •  
    • If you need to include a new custom field on the form, copy the field from the source field into the overlay.
    •  
    • Position the field in the view.
    •  
    • On the Properties tab, change the View Information attributes of each field to match the union field.
    •  
    • If the field ID number is within the reserved range of field ID numbers, change the field ID number.
    •  
    • If the fields that you are copying come from the base layer (that is, they are out-of-the-box fields), modify the database name to include a prefix or suffix to ensure that the name does not conflict with any out-of-the-box fields that might be added by subsequent system upgrades.
    •  
    • In a localized environment, if you are implementing selection fields, ensure that the localized alias values are set as required.
    •  
    • Modify the additional field attributes, permissions, and so on, as required.
    •  
    • Save the form.
       

    5.      Adding new columns to the table in the overlay

       
       
    • Open BMC Remedy Developer Studio in Best Practice Customization mode.
    •  
    • In the Form list, locate the SHR:OverviewConsole form.
    •  
    • If an overlay has not yet been created for the form, right-click the form name in the Form list and select Create Overlay.
    •  
    • The form opens automatically
    •  
    • If you did not create the overlay in the preceding step, double-click the form name in the Form list to open it.
    •  
    • In the view that you are customizing, select Create View Overlay from the Form menu.
    •  
    • Locate the z2TH_ConsolidateTable1 table field (Field ID: 301444200), right-click the table, and select Create Overlay.
    •  
    • In the table Properties tab, change the others > Overlay Type value to Overwrite, and then save the form.
    •  
    • In the table Properties, click the Tree/Table Property attribute box to open the Tree/Table Property dialog box.
    •  
    • In the Fields from Remote Form SHR:Union_OverviewConsole and Local Form SHR:OverviewConsole list, select the fields you need to add and then click the arrow (>) to add them to the Table Columns list.
    •  
    • Modify any additional field attributes, permissions, and so on, for the new column as required.
    •  
    • Save the form.
    Please make sure to rename the column that has been added on the overview console and also add public permissions. 
    Also ensure to perform a Midtier Cache flush for all the changes to take effect. 

    Note* Reference is taken from document  https://docs.bmc.com/docs/itsm91/adding-a-column-to-the-overview-console-608492000.html.  
      
      

     


    Article Number:

    000280110


    Article Type:

    Solutions to a Product Problem



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