JournalArticle related content tables

[Maximiliano Chiesa, modificado 11 Anos atrás.]

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, modificado 11 Anos atrás.]

Hi Maximiliano.

Take a look at the following tables:

JournalArticle
JournalArticleResource ---> Resource_
JournalArticleImage ---> Image

[Maximiliano Chiesa, modificado 11 Anos atrás.]

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, modificado 11 Anos atrás.]

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

[Maximiliano Chiesa, modificado 11 Anos atrás.]

Hi! Thank you very much for your answer, it was very useful.

[d lopez, modificado 11 Anos atrás.]

Hi Maximiliano, how you solved your problem? I need to get all the related assets of a particular JournalArticle too

[Sujay Kumar Paul, modificado 9 Anos atrás.]

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