Foren

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

RSS (Öffnet neues Fenster)

Kombinierte Ansicht Flache Ansicht Baumansicht
Threads [ Zurück | Nächste ]
toggle
Yan Naing Oo
create page table
6. August 2012 23:51
Antwort

Yan Naing Oo

Rang: Regular Member

Nachrichten: 172

Eintrittsdatum: 17. Februar 2011

Neue Beiträge

Hi all,

anybody know liferay's create a new page where to stored in which table ?
kennzeichnen
Samir Gami
RE: create page table
6. August 2012 23:55
Antwort

Samir Gami

Rang: Regular Member

Nachrichten: 159

Eintrittsdatum: 3. Februar 2011

Neue Beiträge

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

Yan Naing Oo

Rang: Regular Member

Nachrichten: 172

Eintrittsdatum: 17. Februar 2011

Neue Beiträge

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
kennzeichnen
Vishal Panchal
RE: create page table
6. August 2012 23:59
Antwort

Vishal Panchal

Rang: Expert

Nachrichten: 263

Eintrittsdatum: 20. Mai 2012

Neue Beiträge

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
kennzeichnen
Samir Gami
RE: create page table
7. August 2012 00:15
Antwort

Samir Gami

Rang: Regular Member

Nachrichten: 159

Eintrittsdatum: 3. Februar 2011

Neue Beiträge

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.
kennzeichnen
Amit Doshi
RE: create page table
7. August 2012 00:29
Antwort

Amit Doshi

Rang: Expert

Nachrichten: 491

Eintrittsdatum: 29. Dezember 2010

Neue Beiträge

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
kennzeichnen
Yan Naing Oo
RE: create page table
8. August 2012 00:02
Antwort

Yan Naing Oo

Rang: Regular Member

Nachrichten: 172

Eintrittsdatum: 17. Februar 2011

Neue Beiträge

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
kennzeichnen
Amit Doshi
RE: create page table
9. August 2012 00:09
Antwort

Amit Doshi

Rang: Expert

Nachrichten: 491

Eintrittsdatum: 29. Dezember 2010

Neue Beiträge

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
kennzeichnen
Yan Naing Oo
RE: create page table
9. August 2012 00:40
Antwort

Yan Naing Oo

Rang: Regular Member

Nachrichten: 172

Eintrittsdatum: 17. Februar 2011

Neue Beiträge

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 .
kennzeichnen