Depending on the Mosaic version you’re using, you’ll have the ability to modify the website’s system properties. You can make these changes yourself in some versions, but you’ll need our assistance in others.
Mosaic version 22.1 and newer
Starting from Mosaic 22.1.0.0, if you're a Mosaic user with the AMENDSYSPROP system function, you can edit existing system properties from the Mosaic frontend configuration screen by following these simple steps:
Click Narrow workview from the top left menu.
Click Tools then Configuration Tools from the top right header menu.
Click System Properties.
Find the settings you’re looking to amend using the search box.
Click the Edit Pencil, update the valve field, then click Save.
📌 Note: The database audits all updates.
Hosted Mosaic version older than 22.1
If you're a hosted or managed customer using a version earlier than 22.1.0.0 and need to update a property value, please raise a new case with the settings name and the new value you need to amend.
Self-Hosted Mosaic version older than 22.1
You’ll be able to use the scripts below to change the settings from the database.
📌 Note: Please be aware that you’ll need to restart the application server is necessary to apply any changes.
Run the script below to find a list of all available configuration options.
SELECT*
FROM system_properties
Use the option name you want to change, and run the script below, replacing the X's with the required information.
SELECT *
FROM system_properties
WHERE NAME = 'xxx'--Enter the name of the option you want to amend
BEGIN TRAN
UPDATE system_properties
SET value = 'xxx'--Enter the new valve
WHERE NAME = 'xxx'--Enter the name of the option you want to amend
SELECT *
FROM system_properties
WHERE NAME = 'xxx'--Enter the name of the option you want to amend
ROLLBACK
--Commit