Field Storage Location

Topics: Customizing Orchard
Jan 30, 2014 at 12:02 AM
I'm importing a lot of content from another CMS into Orchard. I have a custom type with the Media File Picker field that I'm need to link to documents. I cannot figureout where field information is stored in the database.
Jan 30, 2014 at 1:23 AM
Field data is stored in Orchard_Framework_ContentItemVersionRecord table Data column as XML.

Field metadata is stored in Settings_ContentPartFieldDefinitionRecord table Settings column as XML.

If you meant Media Library Picker Field, it keeps references (IDs) to Media (Image, Audio, Document etc.) items in the Orchard_Framework_ContentItemVersionRecord table. Real file reference is kept in Orchard_MediaLibrary_MediaPartRecord table.

Good luck!

Marked as answer by runshoe on 1/31/2014 at 1:45 PM
Jan 30, 2014 at 9:24 PM
That worked great except that the ítems don't show up in queries/projections. They will appear if I go and resave an ítem. I must be missing something on the import.
Jan 31, 2014 at 4:10 AM
Field values are also stored in some Orchard_Projections_<Field Type>IndexRecord tables, which are used in queries.

Marked as answer by runshoe on 1/31/2014 at 1:45 PM