Tip: Remove Collapse/Expand from module setting by SQL

Return to previous page

  • 4/7/2015
  • 456 Views

Comments

456 Views

Tip: Remove Collapse/Expand from module setting by SQL

Last updated 7 years ago

Comments

Common

(Enter the content of this article below)

Advanced

 
If you want to set "Collapse/Expand" for all module to "None", you can go to the settings of all modules and change that in the Page settings.

But there is a way to do that by SQL:
  • Log in as Host
  • Go to menu item Host -> SQL
  • Execute the following SQL statement (after ticking Run as script)

UPDATE {databaseOwner}{objectQualifier}TabModules

SET Visibility = 2
WHERE {databaseOwner}{objectQualifier}TabModules.IconFile IS NULL
AND {databaseOwner}{objectQualifier}TabModules.Visibility != 2

Please note that this statement will remove all collapse/expand options from all modules.

DNN Digest is our monthly email newsletter. It highlights news and content from around the DNN ecosystem, such as new modules and themes, messages from leadership, blog posts and notable tweets. Keep your finger on the pulse of the ecosystem by subscribing.  


Copyright 2017 by DNN Corp Terms of Use Privacy
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out