First look for the primary office city.
- Goto the Developer SQL Page.
- Paste in the SQL query below.
- Change @DomainName and @NewText variables
DECLARE @DomainName varchar(255) = 'name.agencyrevolution.com'
DECLARE @NewText varchar(255) = 'new city name here'
DECLARE @PortalID int
DECLARE @UserId int
SELECT @PortalID = PortalId
FROM PortalAlias
WHERE HTTPAlias = @DomainName
update ModuleSettings
set SettingValue = REPLACE(SettingValue,'[City]',@NewText)
from modulesettings ms2 inner join modules on modules.ModuleID = ms2.ModuleID
where settingname = 'AR_WQ_Headline_Text'
and modules.portalid = @PortalId
Check Run as Script and click the Execute button
Now you will need to clear site cache and increment version.
- Hover over the Mark Menu
- Click on Clear portal cache
- Hover over the Admin Menu
- Click on Site Settings
- Click on the Advanced Settings tab
- Expand the Client Resource Management section
- Check the Override Host Settings box
- Click the Update button
- Click the Increment Site Version link