...
To enable the Call Number Display System for a specific NexSigns license (This process will be upgraded in the future, watch ticket here
)Jira Legacy server System JIRA serverId 5ea3a9a8-87a3-396c-87f3-6358fc4e7ae3 key PRODUCT-160
- Establish the connection to access CloudVariables database through SQL Management Studio
- Click on New Query in the SQL Management Studio
Copy and paste the following code into the New Query Window
Code Block language sql theme RDark title SQL: Enable/Disable Call Number Display System linenumbers true collapse true USE [CloudVariables] DECLARE @NewLicenseKey nvarchar(max); DECLARE @RemoveLicenseKey nvarchar(max); /****** Enter license key below to enable or disable the Call Number Display System */ SET @NewLicenseKey = ''; /* <----- Enable */ SET @RemoveLicenseKey = ''; /* <----- Disable */ UPDATE dbo.GlobalVariable SET Value = Replace(Value + ',' + @NewLicenseKey, ',,', '') WHERE Name = 'TMP_CALL_NUMBER_SYSTEM_ACTIVE_LKEY'; UPDATE dbo.GlobalVariable SET Value = Replace(Replace(Value, @RemoveLicenseKey, ''), ',,', '') WHERE Name = 'TMP_CALL_NUMBER_SYSTEM_ACTIVE_LKEY';
- To enable product license with Call Number Display System, simply assign the product license key into the NewLicenseKey variable then click on Execute to run the script. To disable Call Number Display System from a product license, simply assign the product license key into the RemoveLicenseKey variable then click on Execute to run the script
...