We recently moved from Evoq Content to DNN Community. In Evoq, there was a publish button at the bottom of the page that was visible when some content was not published. There is no such button in DNN Community. While I can see the advantage of being able to publish individual modules on a page, there is not a quick and easy way to see what is and isn't published.
While this is mainly a training issue, it is easy to forget to hit the publish button in the action menu.
Does anyone have a trick to see what modules are not published on a page? Is there an SQL statement that will show me what modules are not published?
I have done that a long time ago, here's what I noted about the process:
/-- To see the workflows that are available: SELECT * FROM ContentWorkflows /-- Make note of the ContentTypeID for Tabs SELECT * FROM ContentTypes /-- Knowing the WorkflowID, we can find the specific states the page is in by taking note of StateID /-- find out the state of the current pages SELECT * FROM ContentWorkflowStates /--Shows all pages (Tab = content type 1) in a certain state of a workflow SELECT * FROM ContentItems WHERE StateID = 1 AND ContentTypeID = 1 /-- now you know which pages need to have the workflow updated. You can go to each one individually and update or run the scripts below /-- Make note of the Portald. Select * from PortalAlias /-- Note I was told to run these next two commands here but I also had to run it after updating the states so I suspect they could just be run at the end /-- First you will have to run a script to publish every page. Update Tabs Set HasBeenPublished = 'True' Where PortalId = 0 /--Then you can to run a script to publish the latest version of each page. Update TabVersions Set IsPublished = 'true' Where TabId in (Select TabId From Tabs Where PortalId = 0) /-- Then you will need to go through EVERY workflow with a draft state or in a non-published state and manually set the StateId to a published state according to that correct workflow /-- Shows all pages in a certain state of a workflow) 7 is a draft state in our current workflow SELECT * FROM ContentItems WHERE StateID = 7 AND ContentTypeID = 1 AND TABID in (SELECT TabID From Tabs Where PortalId = 0) /-- StateId of 11 is a published state in the current Content Approval workflow UPDATE ContentItems SET StateId = 11 WHERE StateID = 9 AND TABID in (SELECT TabID From Tabs Where PortalId = 0) /--- ad to run these two steps again after updating the SteateID Update Tabs Set HasBeenPublished = 'True' Where PortalId = 0 Update TabVersions Set IsPublished = 'true' Where TabId in (Select TabId From Tabs Where PortalId = 0)
FYI, this is from 5 years ago I think, so: backup and try ;-)
I did this but it's a long time ago. Here's what I noted about the process:
Thanks for the reply. We're running a live site with 6,000 pages over 30 portals so we can't make across the board changes without looking at each page and ensuring the content is ready to go live. But, this should help me track down what is and isn't published. This is starting to look like a feature request. It would be nice to have a simple visual cue when you are in edit mode that would show if content is published or not.
-s
Hello Everyone:
FYI, this feature has been added to the Upendo DNN Page Manager. 😎
Upendo DNN Page Manager 1.2
These Forums are for the discussion of the open source CMS DNN platform and ecosystem.
For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:
Awesome! Simply post in the forums using the link below and we'll get you started.