How to modify web content by editing database field

Issue

• On 7.4 there is no content field on JournalArticle table, so you can't search here this content or modify it quickly.

Environment

• DXP 7.4

Resolution

• Knowing that on DXP 7.4 content field was removed from JournalArticle table, now this is generated dynamically in the method getContent from JournalArticleImpl.java#L260 class
• Using ddmFieldAttribute table that is related with a fieldid from ddmfield table where you could find your field using instanceid, fieldname and fieldtype fields.
• With the following query you could get the value from a rich_text field
  

  SELECT ddmfieldattribute.smallattributevalue FROM ddmfieldattribute
  INNER JOIN ddmfield ON ddmfield.fieldid=ddmfieldattribute.fieldid
  WHERE ddmfield.instanceid = 'ggyAXbhE' AND ddmfield.fieldtype = 'rich_text' AND ddmfield.fieldname = 'content';

• You could get the values inspecting the field from the web content that you want to identify

  name="_com_liferay_journal_web_portlet_JournalPortlet_ddm$$content$ggyAXbhE$0$$en_US"