How can I know when a Web Content was created and when it was published from database

Ethan Wei

更新 2023年07月07日 21:00

Issue

How can I know when Web Content was created and when it was published from database

Environment

Liferay DXP 7.2

Resolution

The created time of a Web Content is stored in the column called 'createDate' in the table JournalArticle from the database.
The published time of a Web Content is stored in the column called 'publishDate' in the table AssetEntry from the database. (Please note the value of the column will be null if the Web Content was never published like in the Scheduled status)