Fóruns

Início » Liferay Portal » English » 3. Development

Visualização combinada Visão plana Exibição em árvore
Tópicos [ Anterior | Próximo ]
toggle
Maximiliano Chiesa
JournalArticle related content tables
20 de Novembro de 2012 05:55
Resposta

Maximiliano Chiesa

Ranking: Junior Member

Mensagens: 47

Data de entrada: 20 de Julho de 2012

Mensagens 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.
Pavel Savinov
RE: JournalArticle related content tables
20 de Novembro de 2012 08:06
Resposta

Pavel Savinov

Ranking: Junior Member

Mensagens: 97

Data de entrada: 24 de Setembro de 2012

Mensagens recentes

Hi Maximiliano.

Take a look at the following tables:

JournalArticle
JournalArticleResource ---> Resource_
JournalArticleImage ---> Image
Maximiliano Chiesa
RE: JournalArticle related content tables
20 de Novembro de 2012 09:11
Resposta

Maximiliano Chiesa

Ranking: Junior Member

Mensagens: 47

Data de entrada: 20 de Julho de 2012

Mensagens 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!
Pavel Savinov
RE: JournalArticle related content tables
20 de Novembro de 2012 10:41
Resposta

Pavel Savinov

Ranking: Junior Member

Mensagens: 97

Data de entrada: 24 de Setembro de 2012

Mensagens 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 emoticon
Maximiliano Chiesa
RE: JournalArticle related content tables
22 de Novembro de 2012 11:16
Resposta

Maximiliano Chiesa

Ranking: Junior Member

Mensagens: 47

Data de entrada: 20 de Julho de 2012

Mensagens recentes

Hi! Thank you very much for your answer, it was very useful.
d lopez
RE: JournalArticle related content tables
28 de Janeiro de 2013 04:24
Resposta

d lopez

Ranking: New Member

Mensagens: 16

Data de entrada: 24 de Janeiro de 2013

Mensagens recentes

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
20 de Maio de 2014 23:19
Resposta

Sujay Kumar Paul

Ranking: Regular Member

Mensagens: 165

Data de entrada: 28 de Outubro de 2011

Mensagens 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