Where are article content stored in database?

RT Users
1

Hi,

Can anyone please tell me where the data in the “Content” field or other custom fields of Articles is stored? I have looked into the database’s schema, and although the ‘articles’ table does show some of the fields like name ,summary etc… but the content of custom fields are missing.

P.S The customfield table does show all of my custom field’s details & the customfieldvalue table is empty. I do have a couple of full blown articles in RT which show up fine in the Web Interface.

2

Hello,

You can find the data of custom field in the table labeled “objectcustomfieldvalues”. Large content is usually split into multiple rows within the table.