DB: Where's the data/table for custom fields in a Content Type stored?

Topics: Core
Aug 8, 2013 at 4:33 PM
I know fields are attached to a part with the same name as the Content Type. I've found the settings defining these fields in Settings_ContentPartFieldDefinitionRecord. But I need the actual data. Where can I find it?

Content Types - Settings_ContentTypeDefinitionRecord
Parts related to a Content Type - Settings_ContentTypePartDefinitionRecord
Parts definition - Settings_ContentPartDefinitionRecord
Fields definition - Settings_ContentPartFieldDefinitionRecord

Where's the actual data of the fields?
Aug 8, 2013 at 5:48 PM
All field data for a content item is serialized as XML into the Data column in the ContentItemRecord table.

This isn't terribly useful if you want to query or join on these values. To do that you have to make use of the index tables generated by the Projections module.
Aug 8, 2013 at 6:02 PM
By ContentItemRecord you meant the Orchard_Framework_ContentItemRecord table right?

Via SSMS, the Data column is NULL for all entries. Does this mean there is no straightforward way to pull info if you go straight to the DB?
Aug 8, 2013 at 6:10 PM
Why do you need to go straight to the DB?
Aug 8, 2013 at 6:31 PM
Was looking for a qiuck way to get some data, but it seems like there isn't any. Basically I attached a part that has a (int) count. I just need to quickly pull out the CT with it's fields and the count, preferably in a spreadsheet.
Aug 8, 2013 at 6:36 PM
Should be easy enough to get that information from a ContentManager query.