Khoros Community

Occasional Contributor dpowles
Occasional Contributor

How do I exclude replies from the count of Ideas in a board, and only show number of actual Ideas.

I have a set of Ideas boards in different categories. The list of boards shows a count of posts, but this count also includes replies to the ideas.

 

For example, Board A says "8 Ideas" but the board actually only contains 2 ideas, with a total of 6 replies to them. 

 

Where do I tweak this so that it only counts the top level nodes and so displays "2 Ideas"?

0 Kudos
9 Replies 9
Honored Contributor
Honored Contributor

Re: How do I exclude replies from the count of Ideas in a board, and only show number of actual Idea

@dpowles - You need to add "depth=0" if you are using LIQL query to get the ideas, it will display only the main idea post and exclude replies.

For example:

Select count(*) from messages where conversation.style='idea' and depth = 0

Please let me know if this helps.

Thanks!

0 Kudos
Reply
Loading...
Occasional Contributor dpowles
Occasional Contributor

Re: How do I exclude replies from the count of Ideas in a board, and only show number of actual Idea

Makes sense, but where would this change be made - within Studio?

 

I didn't configure this so I'm not familiar where to make these tweaks to queries.

0 Kudos
Reply
Loading...
Honored Contributor
Honored Contributor

Re: How do I exclude replies from the count of Ideas in a board, and only show number of actual Idea

@dpowles - Can you please confirm if you are using custom component or OOTB, means Khoros default component? 

0 Kudos
Reply
Loading...
Occasional Contributor dpowles
Occasional Contributor

Re: How do I exclude replies from the count of Ideas in a board, and only show number of actual Idea

@Payal , some custom components are in use - just not sure if this one is custom or OOTB.

0 Kudos
Reply
Loading...
Honored Contributor
Honored Contributor

Re: How do I exclude replies from the count of Ideas in a board, and only show number of actual Idea

@dpowles - If this is a custom component, then there will be  LIQL query used and you need to make a change in that. 

0 Kudos
Reply
Loading...
Advisor
Advisor

Re: How do I exclude replies from the count of Ideas in a board, and only show number of actual Idea

I have this same situation.  Ours is likely NOT a custom component. Do I need to use a custom one to make this change?

0 Kudos
Reply
Loading...
Khoros Staff SuzieH
Khoros Staff

Re: How do I exclude replies from the count of Ideas in a board, and only show number of actual Idea

@mhock in which out-of-the-box component are you seeing that incorrect count? That seems like a bug to me.

0 Kudos
Reply
Loading...
Advisor
Advisor

Re: How do I exclude replies from the count of Ideas in a board, and only show number of actual Idea

@SuzieH,

I am in studio looking for the page and I can't find it to give you the components.  It is landing page that list all of our idea boards.  

How would a page like that be labeled in studio? 

I can find the idea page but I am looking for one level above.  I would share the URL but we have a closed Community.  It wouldn't help. 

0 Kudos
Reply
Loading...
Khoros Guru
Khoros Guru

Re: How do I exclude replies from the count of Ideas in a board, and only show number of actual Idea

A page above ideation nodes sounds like a category page. You can identify a page type by looking at the URL. I assume the one you are looking at contains "ct-p" in the URL. See here for a full explanationhttps://community.khoros.com/t5/Community-FAQs/Understanding-SEO-Friendly-URLs/ta-p/6560

If that's the case you would need to have a look at the "Category Page" layout in Studio and check which component - out of the box or custom - is used on that location. Then we can identify next steps.



If you appreciate my efforts, please give me a kudo ↓
Accept as solution to help others find it faster.
0 Kudos
Reply
Loading...