Nurhak Kaya's Software Development Blog

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