SaaS CMS has officially launched! Learn more now.

Where to find dynamic property info in database

Vote:
 

Hi,

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

Regards

#74300
Aug 23, 2013 13:37
Vote:
 

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

 

regards

#74311
Aug 23, 2013 14:23
Vote:
 

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

#74324
Aug 23, 2013 14:56
Vote:
 

Thanks Johan,

I figured out later that it is in tblProperty table.

Regards

#74326
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.