Optimizely CMS – Getting all content of a specific property with a simple SQL script

When you need to retrieve all content of a specific property from a Page/Block type, normally you will use the IContentLoader or IContentRepository, or even IContentModelUsage to get all instances of a content type then select them by property. This is the correct implementation by code.

But what if you only need to check the property's value for debugging/development purpose? Or generate a quick report for a property's usage? Then you have to wrap the above implementation inside an API or a custom tool, and then build, deploy, etc. Seems excessive for a single-use requirement, doesn't it? This article will guide you to go through this by just a SQL script.

Scenario

In this article, we will try to get all MetaDescription of Standard Pages inside the Alloy template:

Please visit this complete post here for more details.