A few years ago, I created this blog post to show how to find Umbraco v7 Nodes using a certain Umbraco Document Type. I needed the same thing for Umbraco v8 projects, and below are some scripts that should help with this question. Find content pages that use a specific document type: SELECT * FROM umbracoContent C INNER JOIN cmsContentType CT ON C . contentTypeId = CT . nodeId INNER JOIN umbracoNode N ON C . nodeId = N . id WHERE CT . alias = ' YourDocumentTypeAlias ' Find the latest published version of a content page by content page node id: SELECT pt . alias , pd .* FROM umbracoPropertyData as pd INNER JOIN cmsPropertyType as pt ON pd . propertyTypeiD = pt . id INNER JOIN umbracoContentVersion as cv ON pd . versionId = cv . id WHERE cv . NodeId = 1055 and cv . [current] = 1
SOLID software design principles are guidelines that help developers create more maintainable, understandable, and flexible code. These principles apply to any object-oriented design, and they aim to reduce the complexity of software development, making it easier to manage and scale. The acronym SOLID stands for: Single Responsibility Principle (SRP): A class should have only one reason to change, meaning it should have only one job or responsibility. Example: Instead of one class handling multiple responsibilities (calculating, printing, saving), each class has a single responsibility. public class Invoice { public void CalculateTotal() { /* ... */ } } public class InvoicePrinter { public void Print(Invoice invoice) { /* ... */ } } public class InvoiceSaver { public void SaveToFile(Invoice invoice) { /* ... */ } } Open/Closed Principle (OCP): Software entities should be open for extension