How to modify web content by editing database field
Written By
Alvaro Cabello Díaz
How To articles are not official guidelines or officially supported documentation. They are community-contributed content and may not always reflect the latest updates to Liferay DXP. We welcome your feedback to improve How To articles!
While we make every effort to ensure this Knowledge Base is accurate, it may not always reflect the most recent updates or official guidelines.We appreciate your understanding and encourage you to reach out with any feedback or concerns.
Legacy Article
You are viewing an article from our legacy "FastTrack"
publication program, made available for informational purposes. Articles
in this program were published without a requirement for independent
editing or verification and are provided"as is" without
guarantee.
Before using any information from this article, independently verify its
suitability for your situation and project.
Issue
- On 7.4 there is no content field on JournalArticle table, so you can't search here this content or modify it quickly.
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"
Did this article resolve your issue ?