Restoring Missing Sidebar Shortcuts

Overview

This article outlines the steps to be followed to restore missing sidebar shortcuts for a user; a scenario that can sometimes be encountered by some users especially after an upgrade.

 

Solution

Follow these steps to restore a missing Everest sidebar:

  1. A user can trigger restoring the menus to factory settings by right-clicking on the main window title bar and choosing Restore Factory Settings
    :Restore_factory_settings.png

    Important:
    • This action removes all menu customizations done by the user and resets the sidebar to factory defaults
    • You will need to re-open Everest for the changes to take effect.
  2. If the drawback highlighted above is not acceptable for the affected user, an alternative workaround is to reconstruct the sidebar manually by Right-clicking on the empty sidebar and Selecting Customize to add the menus as needed through drag and drop:
    EV2300773_-_add_the_menu_needed.png
    Refer to Customize the Display of the Main Menu Bar for more information on this step.

    Note: There may be scenarios where the context menu is not showing, in which case proceed to step 3.

  3. The workaround when the context menu is not showing on right-clicking the sidebar menu is to copy over settings from the Supervisor account which should fix the problem with the missing sidebar shortcuts as well as the missing context menu.  This step should be done by the SQL database administrator as follows:
    1. Execute the below Query to find the settings to be copied from the Supervisor account (SUP-MU in the below example):
      select fs.idno, fstn.FORM_SETTINGS_TYPE_NAME_ID, fsd.FORM_SETTINGS_DETAIL_ID,  settings
      from FORM_SETTINGS_TYPE_NAME fstn inner join FORM_SETTINGS_DETAILS fsd on fstn.FORM_SETTINGS_TYPE_NAME_ID = fsd.FORM_SETTINGS_TYPE_NAME_ID
      inner join form_settings fs on fs.FORM_SETTINGS_ID = fstn.FORM_SETTINGS_ID
      where fs.idno in ('ETJ', 'SUP-MU') and fstn.FORM_NAME = 'TfrmMain' and fsd.COMPONENT_NAME = 'Others'
      idno FORM_SETTINGS_TYPE_NAME_ID FORM_SETTINGS_DETAIL_ID settings
      SUP-MU 1321 5681 0x04010000800201064A536F6674776172655C49636F64655C4576657265737420416476616E6365645C362E302E305C454E475C53657474696E6773202D205355502D4D555C4465736B746F705C4F74686572730200060C546970417453746172747570020402040000000002FF
      ETJ 791 3483 0x04010000800201064A536F6674776172655C49636F64655C4576657265737420416476616E6365645C362E302E305C454E475C53657474696E6773202D205355502D4D555C4465736B746F705C4F74686572730200060C546970417453746172747570020402040000000002FF
    2. Copy the above settings over to the affected user (ETJ) by executing the below update statement:
      begin transaction 
      update form_settings_details set settings = (select settings from form_settings_details where FORM_SETTINGS_DETAIL_ID = 5681)  where FORM_SETTINGS_DETAIL_ID  = 3483

      commit transaction

Testing

The Everest sidebar menu should be restored and the user should also be able to see the context menu when they right-click on the sidebar.

Back to top

Comments

1 comment

Please sign in to leave a comment.