Forums

Home » Liferay Portal » English » 3. Development

Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Maximiliano Chiesa
JournalArticle related content tables
November 20, 2012 5:55 AM
Answer

Maximiliano Chiesa

Rank: Junior Member

Posts: 47

Join Date: July 20, 2012

Recent Posts

Hi all!

Does anybody know in which tables of the Liferay database are saved the Journal Article's related content? (files, other articles, etc.)

Thanks in advance,
Maximiliano.
Pavel Savinov
RE: JournalArticle related content tables
November 20, 2012 8:06 AM
Answer

Pavel Savinov

Rank: Junior Member

Posts: 97

Join Date: September 24, 2012

Recent Posts

Hi Maximiliano.

Take a look at the following tables:

JournalArticle
JournalArticleResource ---> Resource_
JournalArticleImage ---> Image
Maximiliano Chiesa
RE: JournalArticle related content tables
November 20, 2012 9:11 AM
Answer

Maximiliano Chiesa

Rank: Junior Member

Posts: 47

Join Date: July 20, 2012

Recent Posts

Hi! Thanks for your answer, my Resource_ table is empty. I looked at the JournalArticleResource table but I don't see how to get the related assets of a JournalArticle there.

I tried joining JournalArticle and JournalArticleResource table by the field articleId and by resourcePrimKey but didn't find what I wanted.

I need to get all the related assets of a particular JournalArticle (I have all the information of the JournalArticle).

Thanks!
Pavel Savinov
RE: JournalArticle related content tables
November 20, 2012 10:41 AM
Answer

Pavel Savinov

Rank: Junior Member

Posts: 97

Join Date: September 24, 2012

Recent Posts

Yep...sorry, i've disoriented you.
Each article has associated asset from AssetEntry table.
Each file from DL has such assetEntry too.
Links are stored in AssetLink table, 2 records for 1 linked file (Liferay store file->article link and article->file as a different link).
Entries are interconnected in the next way:
JournalArticle.resourcePrimKey --> AssetEntry.classPK
AssetEntry.entryId --> AssetLink.entryId1 (and AssetLink.entryId2)

God bless Open Source emoticon
Maximiliano Chiesa
RE: JournalArticle related content tables
November 22, 2012 11:16 AM
Answer

Maximiliano Chiesa

Rank: Junior Member

Posts: 47

Join Date: July 20, 2012

Recent Posts

Hi! Thank you very much for your answer, it was very useful.
d lopez
RE: JournalArticle related content tables
January 28, 2013 4:24 AM
Answer

d lopez

Rank: New Member

Posts: 16

Join Date: January 24, 2013

Recent Posts

Hi Maximiliano, how you solved your problem? I need to get all the related assets of a particular JournalArticle too
Sujay Kumar Paul
RE: JournalArticle related content tables
May 20, 2014 11:19 PM
Answer

Sujay Kumar Paul

Rank: Regular Member

Posts: 165

Join Date: October 28, 2011

Recent Posts

Hi,
I am trying this query

select * from
journalarticle j,
assetentry a,
assetlink k
where
j.resourcePrimKey=a.classPK
and a.entryid=k.entryId1
and j.content like "%R%"

but getting no result.

Please help