Skip to content

Instantly share code, notes, and snippets.

@kieran23101

kieran23101/Change pane names of modules.sql

Last active September 6, 2018 10:57
Show Gist options
  • Save kieran23101/aa2b872b8485f657f070574eb234505f to your computer and use it in GitHub Desktop.
Save kieran23101/aa2b872b8485f657f070574eb234505f to your computer and use it in GitHub Desktop.
Download ZIP
This will search through all modules and move all the modules in one pane to the other useful for when a pane name is changed on a large website (USE FOR DNN) Tested on DNN 7
Raw
Change pane names of modules.sql
SELECT PaneName FROM dbo.TabModules
UPDATE dbo.TabModules
SET PaneName = 'NewPaneName'
WHERE PaneName = 'OldPaneName'
-- Update Using Module Title
SELECT PaneName FROM dbo.TabModules
UPDATE dbo.TabModules
SET PaneName = 'New pane name'
WHERE 'Module Title' = 'Your Title'
@birksy89
Copy link

Very useful!

@kieran23101
Copy link
Author

@birksy89 Thanks!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment