Skip to content

Instantly share code, notes, and snippets.

@Attackmonkey

Attackmonkey/Get All Unpublished Content

Created July 16, 2019 07:27
Show Gist options
  • Save Attackmonkey/17538961d62aa47a2a548b8984c6fcad to your computer and use it in GitHub Desktop.
Save Attackmonkey/17538961d62aa47a2a548b8984c6fcad to your computer and use it in GitHub Desktop.
Download ZIP
Some queries for getting unpublished content from the Umbraco DB
Raw
Get All Unpublished Content
--ALL UNPUBLISHED CONTENT (COMPLETELY UNPUBLISHED)
SELECT un.id, un.text FROM umbracoNode un
INNER JOIN cmsDocument cd ON un.id = cd.nodeId
WHERE cd.newest = 1 AND cd.published = 0
AND (SELECT COUNT(a.nodeId) FROM cmsDocument a WHERE a.nodeId = un.id AND a.published = 1 AND a.newest = 0) = 0
--ALL UNPUBLISHED CONTENT (COMPLETELY UNPUBLISHED), EXCLUDING DELETED ITEMS
SELECT un.id, un.text FROM umbracoNode un
INNER JOIN cmsDocument cd ON un.id = cd.nodeId
WHERE cd.newest = 1 AND cd.published = 0 AND un.path NOT LIKE '%-21,%'
AND (SELECT COUNT(a.nodeId) FROM cmsDocument a WHERE a.nodeId = un.id AND a.published = 1 AND a.newest = 0) = 0
--ALL UNPUBLISHED CONTENT AND CONTENT WITH UNPUBLISHED CHANGES
SELECT un.id, un.text FROM umbracoNode un
INNER JOIN cmsDocument cd ON un.id = cd.nodeId
WHERE cd.newest = 1 AND cd.published = 0
--ALL UNPUBLISHED CONTENT AND CONTENT WITH UNPUBLISHED CHANGES, EXCLUDING DELETED ITEMS
SELECT un.id, un.text FROM umbracoNode un
INNER JOIN cmsDocument cd ON un.id = cd.nodeId
WHERE cd.newest = 1 AND cd.published = 0 AND un.path NOT LIKE '%-21,%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment