Forum Discussion

gatomonstruo's avatar
gatomonstruo
Adept
5 years ago
Solved

Custom Component - Latest post by Role

Hey!  This is my first time posting something here, so I'll be glad if you let me know if this is the proper board to do it or if some other place is more specific for this kind of question. ...
  • Tarun's avatar
    Tarun
    5 years ago

    Hi gatomonstruo ,

    You can use the ${coreNode.id} in Freemarker to get category ID, in the custom components.

    Following Is the reference document to get Core Node references:

    https://developer.khoros.com/khoroscommunitydevdocs/reference/corenode-1

    This will look something like following

    SELECT id, subject, view_href, post_time, kudos.sum(weight), author.login, author.id, board.title FROM messages WHERE category.id = '${coreNode.id}' AND conversation.style = 'forum' AND depth = 0 ORDER BY post_time DESC LIMIT 10

    Please Give Kudos if you find this post useful and also mark this as Accepted Solution if this is the required solution.

    Regards

    Tarun Kumar

peterlu's avatar
peterlu
Champion
5 years ago

gatomonstruo You can add category.id to your where clause

 

SELECT id, subject, view_href, post_time, kudos.sum(weight), author.login, author.id, board.title FROM messages WHERE category.id = 'xxx' AND conversation.style = 'forum' AND depth = 0 ORDER BY post_time DESC LIMIT 10
  • gatomonstruo's avatar
    gatomonstruo
    Adept
    5 years ago

    Hey peterlu, 

    Thanks for your reply! 

    Yes! I was thinking to do something like that, but by using 'category.id' the Query should display only content for that CatID. 

    So, the problem is that I need something dynamic, the component is need to be available for both communities environment, each with the results for that category. 

    Regards,