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:
- A user can trigger restoring the menus to factory settings by right-clicking on the main window title bar and choosing Restore Factory Settings
:
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.
- 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:
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.
- 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:
- 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 - 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
- Execute the below Query to find the settings to be copied from the Supervisor account (SUP-MU in the below example):
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.
Comments
1 comment
hyperlink for Customize the Display of the Main Menu Bar is broken
Please sign in to leave a comment.