8 years ago
1
Topic

Hello,

I am googling it but can't find anything. I would like to know where in the database, the values of any custom additional fields we create on an article are stored.

In which table and field?

Thanks

Get a Book for SEBLOD
1283 Posts
Bucklash
8 years ago
0
Level 1

Hi

Are you referring to when you create a new field and store the data in a new db column?
If you create a content type based on the Article Object and call it 'Bananas', then in your db you will see a ew table: "#__cck_store_form_bananas".
If you create new fields for this content type you can either have the fields associated with this content type only, or have them available elsewhere, too.
If you create new fields for this content type only, then the padlock on the form must be closed before you click the big '+' (the padlock is in the top right of the construction area - the layout and positions area.
So if I create a new text field i.e. {Title : My Banana', 'Name: my_banana', Label : My Banana', 'Storage: [Standard | Article | my_banana]'
In the db table '#__cck_store_form_bananas' you will see a db_column 'my_banana'. If you don't, add some content and then you will.
If you create new fields to be shared amongst content types, then the padlock on the form must be open before you click the big '+'.
So if I create a new text field i.e. {Title : My Other Banana', 'Name: my_other_banana', Label : My Other Banana', 'Storage: [Standard | Article | my_other_banana]'
In the db table '#__cck_store_item_content' you will see a db_column 'my_other_banana'. If you don't, add some content and then you will.

Bucklash

Get a VIP membership