Skip Navigation LinksALVAO 11.1ALVAO Service DeskSystem implementation in the organizationCustomizations and extensionsCustom links in menus Skip Navigation Links.


Custom links in menus

In ALVAO WebApp you can display custom links in the main menu and in the user menu. These links can be localized for each user's language. You can also hide some system commands in the menus, for example to replace them with custom links.
Tip:
You can use the functionality to conditionally show links to only certain users based on roles or group memberships custom commands in the main menu.

Setting custom links in the main menu

Create a string describing the custom link in the form "<Page name>","<Page link>","<Icon name>".

For example: "Custom Form","/Custom/ALVAO/CustomForm", "CustomList".

Use the icon name from the Microsoft Fabric library as the command icon name (the icon name will appear on the page when you hover over the selected icon). If you do not specify an icon, the LightningBolt icon is used.

If you want to set multiple custom links, create a sequence of the described strings, separated by a semicolon character.

For example: "Custom Form","/Custom/ALVAO/CustomForm";"ALVAO","https://www.alvao.com/","Like".

Finally, run the following SQL script in which the second line modifies the variable to the set string or sequence of strings.

DECLARE @MainMenuCustomHead nvarchar(max);
SET @MainMenuCustomHead = N'"CustomForm","/Custom/ALVAO/CustomForm","CustomList","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);

Custom links in the main menu appear under system commands. The order is the same as the order of the individual strings described.

If you want to display the links above the More menu, run the following SQL script in which you modify the second line to the set string or sequence of strings.

DECLARE @MainMenuCustomTail nvarchar(max);
SET @MainMenuCustomTail = N'"CustomForm 2","/Custom/ALVAO/CustomForm","CustomList","ALVAO 2","https://www.alvao.com/","Like"
DELETE dbo.tProperty WHERE sProperty=N'WebApp.MainMenu.CustomTail';
INSERT INTO dbo.tProperty(sProperty,sPropertyValue) VALUES(N'WebApp.MainMenu.CustomTail',@MainMenuCustomTail);

Under the system commands and above the More menu, you can also display different links, described by different strings.

Note:
To remove all custom links in the main menu, run the following SQL command on the ALVAO database using SQL Management Studio:
DELETE tProperty WHERE sProperty LIKE N'WebApp.MainMenu.CustomTail%' OR sProperty LIKE N'WebApp.MainMenu.CustomHead%';

Setting custom links in the user menu

Create a string describing the custom link in the same format as for the custom link in the main menu.

If you want to set up multiple custom links, create a sequence of strings just as you did for setting up links in the main menu.

Finally, run the following SQL script, in which on the second line, modify the transformation to the set string or sequence of strings.

DECLARE @UserMenuCustom nvarchar(max);
SET @UserMenuCustom = N'"CustomForm","/Custom/ALVAO/CustomForm";"ALVAO","https://www.alvao.com/","Like"';
DELETE dbo.tProperty WHERE sProperty=N'WebApp.UserMenu.Custom';
INSERT INTO dbo.tProperty(sProperty,sPropertyValue) VALUES(N'WebApp.UserMenu.Custom',@UserMenuCustom);

Custom links in the user menu appear above the Settings item. The order above is the same as the order of the individual strings described.

Note:
To remove all custom links in the user menu, run the following SQL statement on the ALVAO database using SQL Management Studio:
DELETE dbo.tProperty WHERE sProperty LIKE N'WebApp.UserMenu.Custom%';

Localizing custom links

If you want to display link names in different languages according to the user's preferred language, you need to run additional SQL scripts. The localized version of the string describing the custom links is entered into these scripts.

If you are creating a localization for, for example, Czech (for custom links in the main menu, under system commands), create the localized string first.

For example: "Custom Form","/Custom/ALVAO/CustomForm";"ALVAO","https://www.alvao.com/".

Next, run the following SQL script, in which on the third line edit the variable specifying the LocaleID of the localized language (e.g. 1029 for Czech). On the fourth line, edit the locale string.

DECLARE @MainMenuCustomHead nvarchar(max);
DECLARE @lcid nvarchar(max);
SET @lcid = N'1029';
SET @MainMenuCustomHead = N'"CustomForm","/Custom/ALVAO/CustomForm";"ALVAO","https://www.alvao.com/","Like"';
DELETE dbo.tProperty WHERE sProperty=N'WebApp.MainMenu.CustomHead.'+@lcid;
INSERT INTO dbo.tProperty(sProperty,sPropertyValue) VALUES(N'WebApp.MainMenu.CustomHead.'+@lcid,@MainMenuCustomHead);
Note:
Localized custom links are displayed to all users who have set the language for which the custom link was defined. If localized custom links are not defined for the user's language, non-localized (default) custom links are displayed to the user. If you localize custom links, it is recommended that you write the default custom links in English.
Note:
ALVAO WebApp supports the following languages for localization of system texts: Czech (LocaleID 1029), German (LocaleID 1031), English (LocaleID 1033), Polish (LocaleID 1045), Slovak (LocaleID 1051) and Romanian (LocaleID 1048). For more information, see Microsoft Locale ID Values.

If you want to locate custom links in the main menu, above the More menu, edit in the same way and then run the following script:

DECLARE @MainMenuCustomTail nvarchar(max);
DECLARE @lcid nvarchar(max);
SET @lcid = N'1029';
SET @MainMenuCustomTail = N'"CustomForm 2","/Custom/ALVAO/CustomForm";"ALVAO 2","https://www.alvao.com/"';
DELETE dbo.tProperty WHERE sProperty=N'WebApp.MainMenu.CustomTail.'+@lcid;
INSERT INTO dbo.tProperty(sProperty,sPropertyValue) VALUES(N'WebApp.MainMenu.CustomTail.'+@lcid,@MainMenuCustomTail);

If you want to localize custom links in the user menu, edit in the same way and then run the following script:

DECLARE @UserMenuCustom nvarchar(max);
DECLARE @lcid nvarchar(max);
SET @lcid = N'1029';
SET @UserMenuCustom = N'"CustomForm","/Custom/ALVAO/CustomForm";"ALVAO","https://www.alvao.com/"';
DELETE dbo.tProperty WHERE sProperty=N'WebApp.UserMenu.Custom.'+@lcid;
INSERT INTO dbo.tProperty(sProperty,sPropertyValue) VALUES(N'WebApp.UserMenu.Custom.'+@lcid,@UserMenuCustom);
Tip:
When localizing custom links, both the name of the localized link and its URL can be modified. It is recommended to use the same URL and link order in all localized links.

Hiding system commands

The following table shows the SQL commands for hiding (and possibly re-displaying) system commands.

Link Hide link command Link display command
Requests INSERT INTO tProperty(sProperty,bPropertyValue) VALUES ('WebApp.MainMenuHide.Tickets',1); DELETE FROM tProperty WHERE sProperty = 'WebApp.MainMenuHide.Tickets';
Service Catalog INSERT INTO tProperty(sProperty,bPropertyValue) VALUES ('WebApp.MainMenuHide.NewTicket',1); DELETE FROM tProperty WHERE sProperty = 'WebApp.MainMenuHide.NewTicket';
Knowledge base INSERT INTO tProperty(sProperty,bPropertyValue) VALUES ('WebApp.MainMenuHide.KnowledgeBase',1); DELETE FROM tProperty WHERE sProperty = 'WebApp.MainMenuHide.KnowledgeBase';
Current Messages INSERT INTO tProperty(sProperty,bPropertyValue) VALUES ('WebApp.MainMenuHide.News',1); DELETE FROM tProperty WHERE sProperty = 'WebApp.MainMenuHide.News';
My entrusted property INSERT INTO tProperty(sProperty,bPropertyValue) VALUES ('WebApp.UserMenuHide.MyAsset',1); DELETE FROM tProperty WHERE sProperty = 'WebApp.UserMenuHide.MyAsset';
My Team INSERT INTO tProperty(sProperty,bPropertyValue) VALUES ('WebApp.UserMenuHide.TeamManagement',1); DELETE FROM tProperty WHERE sProperty = 'WebApp.UserMenuHide.TeamManagement';
Settings INSERT INTO tProperty(sProperty,bPropertyValue) VALUES ('WebApp.UserMenuHide.Settings',1); DELETE FROM tProperty WHERE sProperty = 'WebApp.UserMenuHide.Settings';
Subscribe INSERT INTO tProperty(sProperty,bPropertyValue) VALUES ('WebApp.UserMenuHide.Logout',1); DELETE FROM tProperty WHERE sProperty = 'WebApp.UserMenuHide.Logout';
Caution:
Commands hidden in this way will not be displayed to any ALVAO WebApp users, regardless of their role in the system.

 

Did not find what you were looking for? Ask our technical support team.