Skip Navigation LinksALVAO 11.0ALVAO 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.

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.

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.

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);

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);

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';

 

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