uhateoas
8/19/2013 - 9:55 AM

SQL to Find Nodes using a Certain Document Type.cs

SQL to Find Nodes using a Certain Document Type.cs

find-nodes-of-alias.sql
content_copyfile_download
SELECT * FROM cmsContent C
INNER JOIN cmsContentType CT ON C.contentType = CT.nodeId
INNER JOIN umbracoNode N ON C.nodeId = N.id
WHERE CT.alias = ‘yourDocumentTypeAliasHere’