Fórum
JournalArticle related content tables
Maximiliano Chiesa, modificado 11 Anos atrás.
JournalArticle related content tables
Junior Member Postagens: 47 Data de Entrada: 20/07/12 Postagens Recentes
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.
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.
RE: JournalArticle related content tables
Junior Member Postagens: 94 Data de Entrada: 24/09/12 Postagens Recentes
Hi Maximiliano.
Take a look at the following tables:
JournalArticle
JournalArticleResource ---> Resource_
JournalArticleImage ---> Image
Take a look at the following tables:
JournalArticle
JournalArticleResource ---> Resource_
JournalArticleImage ---> Image
Maximiliano Chiesa, modificado 11 Anos atrás.
RE: JournalArticle related content tables
Junior Member Postagens: 47 Data de Entrada: 20/07/12 Postagens Recentes
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!
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.
RE: JournalArticle related content tables
Junior Member Postagens: 94 Data de Entrada: 24/09/12 Postagens Recentes
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
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.
RE: JournalArticle related content tables
Junior Member Postagens: 47 Data de Entrada: 20/07/12 Postagens Recentes
Hi! Thank you very much for your answer, it was very useful.
d lopez, modificado 11 Anos atrás.
RE: JournalArticle related content tables
New Member Postagens: 16 Data de Entrada: 24/01/13 Postagens Recentes
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.
RE: JournalArticle related content tables
Regular Member Postagens: 164 Data de Entrada: 28/10/11 Postagens Recentes
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
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