SaaS CMS has officially launched! Learn more now.

Where to find dynamic property info in database



Where do I find dynamic property information in database, on which table. Is it the same on episerver 4 and 5.


Aug 23, 2013 13:37

The Property is of course on tblProperty table and if you know the pageId and propertyId you can get it by using sql statment 

select  * from [dbo].[tblProperty] WHERE fkPageID=xxxx and fkPageDefinitionID=yyyy



Aug 23, 2013 14:23

You can distinguish a dynamic property from an "ordinary" property by looking at column fkPageTypeID in tblPageDefinition (in CMS7 it is fkContentTypeID in tblPropertyDefinition). For dynamic properties is the column value NULL (meaning they are not bound to a specific page/content type).

so you can e.g. get all dynamic property values as:

select * from [dbo].[tblProperty] as prop inner join
[dbo].[tblPageDefinition] as def on prop.fkPageDefinitionID = def.pkID
where def.fkPageTypeID is NULL

Aug 23, 2013 14:56

Thanks Johan,

I figured out later that it is in tblProperty table.


Aug 23, 2013 15:04
This thread is locked and should be used for reference only. Please use the Episerver CMS 7 and earlier versions forum to open new discussions.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.