Hi Joris! ________________________________________ From: users-bounces@xwiki.org [users-bounces@xwiki.org] On Behalf Of Joris Dirks [joris@user.stekje.nl] Sent: 27 February 2012 17:01 To: XWiki Users Subject: [xwiki-users] Blog entries for specific category

Hi,

I'm missing an option to show recent blog entries for a specific category, e.g. in a panel. Is there such a feature available? I can imagine others have needed/used such a feature before. Right now I'm just trying to hack Blog.RecentPostsPanel to filter on category, but I can't wrap my head around the query needed. In 'getEntriesForCategory' (Blog.CategoriesCode), the query is: #set($query = ", DBStringListProperty as categories join categories.list as category${query} and obj.id = categories.id.id and categories.id.name='category' and category in (${parameters})")

But that's about 10 degrees too difficult for me to comprehend :)

This could help: http://platform.xwiki.org/xwiki/bin/view/DevGuide/velocityHqlExamples#HPubli... Greetings!

Any hints? Thanks!

Joris

users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users Nota: A informaci?n contida nesta mensaxe e os seus posibles documentos adxuntos ? privada e confidencial e est? dirixida ?nicamente ? seu destinatario/a. Se vostede non ? o/a destinatario/a orixinal desta mensaxe, por favor elim?nea. A distribuci?n ou copia desta mensaxe non est? autorizada. Nota: La informaci?n contenida en este mensaje y sus posibles documentos adjuntos es privada y confidencial y est? dirigida ?nicamente a su destinatario/a. Si usted no es el/la destinatario/a original de este mensaje, por favor elim?nelo. La distribuci?n o copia de este mensaje no est? autorizada. See more languages: http://www.sergas.es/aviso_confidencialidad.htm

Hi Joris, On Tue, Feb 28, 2012 at 11:19 AM, Joris Dirks <joris@user.stekje.nl> wrote:

On 28 February 2012 00:26, <Ricardo.Julio.Rodriguez.Fernandez@sergas.es

...

wrote:

...

Hi Joris! ________________________________________ From: users-bounces@xwiki.org [users-bounces@xwiki.org] On Behalf Of Joris Dirks [joris@user.stekje.nl] Sent: 27 February 2012 17:01 To: XWiki Users Subject: [xwiki-users] Blog entries for specific category

...

Hi,

I'm missing an option to show recent blog entries for a specific category, e.g. in a panel. Is there such a feature available? I can imagine others have needed/used such a feature before. Right now I'm just trying to hack Blog.RecentPostsPanel to filter on category, but I can't wrap my head around the query needed. In 'getEntriesForCategory' (Blog.CategoriesCode), the query is: #set($query = ", DBStringListProperty as categories join categories.list as category${query} and obj.id = categories.id.id and categories.id.name='category' and category in (${parameters})")

But that's about 10 degrees too difficult for me to comprehend :)

This could help:

http://platform.xwiki.org/xwiki/bin/view/DevGuide/velocityHqlExamples#HPubli...

...

Greetings!

Thanks, I've stared at that many times but I just can't comprehend how to filter on a value in a the 'Category' object, which is of the database tree type.

It's actually pretty complex. I tried to do it myself a couple times, but I never managed to make it work. Could someone who knows how to do this please update the query guide with an example? Thanks in advance, Guillaume

_______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users