Forums

Home » Liferay Portal » English » 2. Using Liferay » General

Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Yan Naing Oo
create page table
August 6, 2012 11:51 PM
Answer

Yan Naing Oo

Rank: Regular Member

Posts: 180

Join Date: February 17, 2011

Recent Posts

Hi all,

anybody know liferay's create a new page where to stored in which table ?
Samir Gami
RE: create page table
August 6, 2012 11:55 PM
Answer

Samir Gami

Rank: Regular Member

Posts: 161

Join Date: February 3, 2011

Recent Posts

Didn't get your question correctly, BTW liferay stores pages information in "layout' table.
Yan Naing Oo
RE: create page table
August 6, 2012 11:59 PM
Answer

Yan Naing Oo

Rank: Regular Member

Posts: 180

Join Date: February 17, 2011

Recent Posts

Samir Gami:
Didn't get your question correctly, BTW liferay stores pages information in "layout' table.



let say I have a page but accidently deleted the page and it is also contain web content portlets . can i retrieve back from necessary table ?
without restoring the whole database.

any suggestion would be appreciate. thank
Vishal Panchal
RE: create page table
August 6, 2012 11:59 PM
Answer

Vishal Panchal

Rank: Expert

Posts: 279

Join Date: May 20, 2012

Recent Posts

HI,Yan Naing Oo

The table is called Layout.
Also of relevance is LayoutSet and Group.
Web Content data on pages can be found on JournalArticle (and other tables that begin with Journal).
Abstracted from : http://stackoverflow.com/questions/6843551/liferay-where-in-the-database-are-the-community-pages-saved

Thanks & Regards,
Vishal R. Panchal
Samir Gami
RE: create page table
August 7, 2012 12:15 AM
Answer

Samir Gami

Rank: Regular Member

Posts: 161

Join Date: February 3, 2011

Recent Posts

I don't think, liferay persist the deleted pages information, once you delete the page all the relevant information get deleted from respective tables of liferay ,
Web-content, those are lies on the deleted page are safe.
Amit Doshi
RE: create page table
August 7, 2012 12:29 AM
Answer

Amit Doshi

Rank: Liferay Master

Posts: 549

Join Date: December 29, 2010

Recent Posts

Yan Naing Oo:
Samir Gami:
Didn't get your question correctly, BTW liferay stores pages information in "layout' table.



let say I have a page but accidently deleted the page and it is also contain web content portlets . can i retrieve back from necessary table ?
without restoring the whole database.

any suggestion would be appreciate. thank



Actually page information are getting stored in the layout table as samir said, so page information means it will contains which portlet was stored in that page, which layout and theme was applied etc,

And Webcontent is stored in entirely different table, i.e., journalarticle,journaltemplate and journalstructure table. So, it will not affect your webcontent portlet.

Thanks & Regards,
Amit Doshi
Yan Naing Oo
RE: create page table
August 8, 2012 12:02 AM
Answer

Yan Naing Oo

Rank: Regular Member

Posts: 180

Join Date: February 17, 2011

Recent Posts

I have seen that the relationship for Page .which is contain Page --- Portlets --- WebContent.
when the Page is deleted then Portlets are also deleted in the table only exists in Content in the db.

if so can we retrieve the information like auditing ? example , who deleted the page at datetime ?

thank
Amit Doshi
RE: create page table
August 9, 2012 12:09 AM
Answer

Amit Doshi

Rank: Liferay Master

Posts: 549

Join Date: December 29, 2010

Recent Posts

Yan Naing Oo:
I have seen that the relationship for Page .which is contain Page --- Portlets --- WebContent.
when the Page is deleted then Portlets are also deleted in the table only exists in Content in the db.

if so can we retrieve the information like auditing ? example , who deleted the page at datetime ?

thank


I don't think you can retrieve the content from Auditing portlet. You cannot get the content back, but you can know who has deleted the content and also the date and time too.

For that you need to install audit hook, audit report portlet and need to enable the filter of audit in portal-ext. properties. And all the events are stored in the audit_auditevent table in json format.

For more details related to audit portlet , check this link.

Thanks & Regards,
Amit Doshi
Yan Naing Oo
RE: create page table
August 9, 2012 12:40 AM
Answer

Yan Naing Oo

Rank: Regular Member

Posts: 180

Join Date: February 17, 2011

Recent Posts

Amit Doshi:
Yan Naing Oo:
I have seen that the relationship for Page .which is contain Page --- Portlets --- WebContent.
when the Page is deleted then Portlets are also deleted in the table only exists in Content in the db.

if so can we retrieve the information like auditing ? example , who deleted the page at datetime ?

thank


I don't think you can retrieve the content from Auditing portlet. You cannot get the content back, but you can know who has deleted the content and also the date and time too.

For that you need to install audit hook, audit report portlet and need to enable the filter of audit in portal-ext. properties. And all the events are stored in the audit_auditevent table in json format.

For more details related to audit portlet , check this link.

Thanks & Regards,
Amit Doshi




Hi Amit,

I saw that link. it could not be available in 6.0.6CE ? my version is CE 6.0.6 so anyway to download and install for it. document said EE only .