Custom links in menus
In an on-prem setup, you can display custom links in the main menu and in the user menu in the WebApp. These links can be localized for each user's preferred language. You can also hide some system commands in the menus, for example to replace them with custom links.
For advanced scenarios, like showing links to only certain users based on their roles or group membership, use the custom commands feature.
Creating custom links
Create a string describing the custom link in the format: "page_name","page_link","icon_name".
For example: "Custom form","https://contoso.com/custom-form", "CustomList".
As the icon_name, use the Microsoft Fabric icons. If no icon is specified in the string, the LightningBolt icon will be used by default.
If you want to create multiple custom links, separate them by semicolon, e.g.: "Custom form","https://contoso.com/custom-form";"ALVAO","https://www.alvao.com/","Like".
Finally, replace the string on the 2nd row with your string in the following SQL script, and then execute the script in your Alvao database (in SQL Server Management Studio).
DECLARE @MainMenuCustomHead nvarchar(max);
SET @MainMenuCustomHead = N'"Custom form","https://contoso.com/custom-form";"ALVAO","https://www.alvao.com/","Like"'
DELETE dbo.tProperty WHERE sProperty=N'WebApp.MainMenu.CustomHead';
INSERT INTO dbo.tProperty(sProperty,sPropertyValue) VALUES(N'WebApp.MainMenu.CustomHead',@MainMenuCustomHead);
To display links in different positions in the WebApp, use the following property names instead of the WebApp.MainMenu.CustomHead in the script.
| Property name | Link position |
|---|---|
| WebApp.MainMenu.CustomHead | In the top of the main command menu, i.e., above the system commands |
| WebApp.MainMenu.CustomTail | In the bottom of the main command menu, i.e., between the last top-level system command and the "..." menu |
| WebApp.UserMenu.Custom | In the user menu (the top-right menu in the WebApp), above the Settings command |
The commands are displayed in the same order as they are described in the string.
To remove all custom links, run the following SQL script:
DELETE tProperty WHERE sProperty LIKE N'WebApp.MainMenu.CustomTail%' OR sProperty LIKE N'WebApp.MainMenu.CustomHead%' OR sProperty LIKE N'WebApp.UserMenu.Custom%';
Localization
If you wish to translate link names into user's preferred language, add the locale ID value after the property name in the scripts above. E.g., for German language use the WebApp.MainMenu.CustomHead1031 property name. This way, define the links for each language you want to support.
If no custom links are defined for the user's preferred language the default custom links (without LocaleId) will be displayed. Always define the default links (usually in English) to ensure consistent user-experience in a multi-language environment.
The following languages are supported for link localization: English (LocaleID 1033), German (LocaleID 1031), Polish (LocaleID 1045), , Czech (LocaleID 1029), Romanian (LocaleID 1048), and Slovak (LocaleID 1051).
Hiding system commands
To hide the Knowledge base system command in the main menu, run this SQL script in your Alvao database:
INSERT INTO tProperty(sProperty,bPropertyValue) VALUES ('WebApp.MainMenuHide.KnowledgeBase',1);
To re-display it, run this script:
DELETE FROM tProperty WHERE sProperty = 'WebApp.MainMenuHide.KnowledgeBase';
Replace the WebApp.MainMenuHide.KnowledgeBase property name with following names to hide or re-display other system commands:
| Command | Property name |
|---|---|
| Tickets | WebApp.MainMenuHide.Tickets |
| Knowledge base | WebApp.MainMenuHide.KnowledgeBase |
| News | WebApp.MainMenuHide.News |
| User menu - My asset | WebApp.UserMenuHide.MyAsset |
| User menu - My team | WebApp.UserMenuHide.TeamManagement |
| User menu - Settings | WebApp.UserMenuHide.Settings |
| User menu - Logout | WebApp.UserMenuHide.Logout |
Hidden commands will not be displayed to any users, regardless of their roles.