Khoros Atlas Logo

%3CLINGO-SUB%20id%3D%22lingo-sub-539983%22%20slang%3D%22en-US%22%3EHow%20do%20I%20exclude%20replies%20from%20the%20count%20of%20Ideas%20in%20a%20board%2C%20and%20only%20show%20number%20of%20actual%20Ideas.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-539983%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20set%20of%20Ideas%20boards%20in%20different%20categories.%20The%20list%20of%20boards%20shows%20a%20count%20of%20posts%2C%20but%20this%20count%20also%20includes%20replies%20to%20the%20ideas.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%2C%20Board%20A%20says%20%228%20Ideas%22%20but%20the%20board%20actually%20only%20contains%202%20ideas%2C%20with%20a%20total%20of%206%20replies%20to%20them.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhere%20do%20I%20tweak%20this%20so%20that%20it%20only%20counts%20the%20top%20level%20nodes%20and%20so%20displays%20%222%20Ideas%22%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-541492%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20exclude%20replies%20from%20the%20count%20of%20Ideas%20in%20a%20board%2C%20and%20only%20show%20number%20of%20actual%20Idea%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-541492%22%20slang%3D%22en-US%22%3E%3CP%3EIt%20appears%20to%20be%20a%20LIQL%20query%20since%20it%20is%20out%20of%20box.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20a%20neophyte%20on%20coding.%26nbsp%3B%20Am%20I%20able%20to%20simply%20place%20your%20%22Select%22%20example%20in%20this%20code.%3C%2FP%3E%3CP%3E%26lt%3B%23assign%20qry%20%3D%20%22SELECT%20id%2C%20title%2C%20view_href%2C%20description%2C%20topics.count(*)%2C%20c_node_icon_url%20FROM%20boards%20WHERE%20parent_category.id%20%3D%20'%24%7BcoreNode.id%7D'%20AND%20hidden%3Dfalse%20ORDER%20BY%20position%20ASC%22%20%2F%26gt%3B%3CBR%20%2F%3E%26lt%3B%23assign%20boards%20%3D%20executeLiQLQuery(qry)%20%2F%26gt%3B%3C%2FP%3E%3CP%3EShould%20I%20replace%20the%20current%20topics.count(*)%20and%20change%20it%20to%20read%3A%3C%2FP%3E%3CP%3E%26lt%3B%23assign%20qry%20%3D%20%22SELECT%20id%2C%20title%2C%20view_href%2C%20description%2C%20%3CSTRONG%3Ecount(*)%20from%20messages%20where%20conversation.style%3D'idea'%20and%20depth%20%3D%200%3C%2FSTRONG%3E%2C%20c_node_icon_url%20FROM%20boards%20WHERE%20parent_category.id%20%3D%20'%24%7BcoreNode.id%7D'%20AND%20hidden%3Dfalse%20ORDER%20BY%20position%20ASC%22%20%2F%26gt%3B%3CBR%20%2F%3E%26lt%3B%23assign%20boards%20%3D%20executeLiQLQuery(qry)%20%2F%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-541489%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20exclude%20replies%20from%20the%20count%20of%20Ideas%20in%20a%20board%2C%20and%20only%20show%20number%20of%20actual%20Idea%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-541489%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fcommunity.khoros.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F157150i49CFB5DC8E355C8B%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20srcset%3D%22%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F157150i49CFB5DC8E355C8B%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%201.0x%2C%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F157150i49CFB5DC8E355C8B%2Fimage-dimensions%2F800x314%3Fv%3D1.0%202.0x%2C%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F157150i49CFB5DC8E355C8B%2Fimage-dimensions%2F1200x471%3Fv%3D1.0%203.0x%22%20alt%3D%22Categorypage-Components.png%22%20title%3D%22Categorypage-Components.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%3CA%20href%3D%22https%3A%2F%2Fcommunity.khoros.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F63194%22%20target%3D%22_blank%22%3E%40ClaudiusH%3C%2FA%3E%26nbsp%3BThanks%20for%20the%20direction.%26nbsp%3B%20Found%20the%20category%20page%20and%20the%20component%20is%20the%20theme-lib.category-board-tiles.%26nbsp%3B%20It%20appears%20to%20be%20an%20out%20of%20the%20box%20component.%3C%2FP%3E%3CP%3EAs%20for%20the%20LIQL%20query%2C%20I%20have%20no%20idea%20where%20I%20am%20headed%20there.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-541283%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20exclude%20replies%20from%20the%20count%20of%20Ideas%20in%20a%20board%2C%20and%20only%20show%20number%20of%20actual%20Idea%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-541283%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.khoros.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F63194%22%20target%3D%22_blank%22%3E%40ClaudiusH%3C%2FA%3E%26nbsp%3Bit's%20a%20category%20page%20using%20an%20out%20of%20the%20box%20component%2C%20and%20the%20requirement%20would%20be%20to%20display%20the%20counts%20differently%20for%20these%20ideation%20nodes%20than%20for%20other%20content%20types%20(forums%2C%20TKBs%20etc)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-540712%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20exclude%20replies%20from%20the%20count%20of%20Ideas%20in%20a%20board%2C%20and%20only%20show%20number%20of%20actual%20Idea%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-540712%22%20slang%3D%22en-US%22%3E%3CP%3EA%20page%20above%20ideation%20nodes%20sounds%20like%20a%20category%20page.%20You%20can%20identify%20a%20page%20type%20by%20looking%20at%20the%20URL.%20I%20assume%20the%20one%20you%20are%20looking%20at%20contains%20%22%3CSPAN%3Ect-p%22%20in%20the%20URL.%20See%20here%20for%20a%20full%20explanation%3C%2FSPAN%3E%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fcommunity.khoros.com%2Ft5%2FCommunity-FAQs%2FUnderstanding-SEO-Friendly-URLs%2Fta-p%2F6560%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Fcommunity.khoros.com%2Ft5%2FCommunity-FAQs%2FUnderstanding-SEO-Friendly-URLs%2Fta-p%2F6560%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EIf%20that's%20the%20case%20you%20would%20need%20to%20have%20a%20look%20at%20the%20%22Category%20Page%22%20layout%20in%20Studio%20and%20check%20which%20component%20-%20out%20of%20the%20box%20or%20custom%20-%20is%20used%20on%20that%20location.%20Then%20we%20can%20identify%20next%20steps.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-540703%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20exclude%20replies%20from%20the%20count%20of%20Ideas%20in%20a%20board%2C%20and%20only%20show%20number%20of%20actual%20Idea%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-540703%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.khoros.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F28708%22%20target%3D%22_blank%22%3E%40SuzieH%3C%2FA%3E%2C%3C%2FP%3E%3CP%3EI%20am%20in%20studio%20looking%20for%20the%20page%20and%20I%20can't%20find%20it%20to%20give%20you%20the%20components.%26nbsp%3B%20It%20is%20landing%20page%20that%20list%20all%20of%20our%20idea%20boards.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20would%20a%20page%20like%20that%20be%20labeled%20in%20studio%3F%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%20find%20the%20idea%20page%20but%20I%20am%20looking%20for%20one%20level%20above.%26nbsp%3B%20I%20would%20share%20the%20URL%20but%20we%20have%20a%20closed%20Community.%26nbsp%3B%20It%20wouldn't%20help.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-540087%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20exclude%20replies%20from%20the%20count%20of%20Ideas%20in%20a%20board%2C%20and%20only%20show%20number%20of%20actual%20Idea%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-540087%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.khoros.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F70953%22%20target%3D%22_blank%22%3E%40mhock%3C%2FA%3E%26nbsp%3Bin%20which%20out-of-the-box%20component%20are%20you%20seeing%20that%20incorrect%20count%3F%20That%20seems%20like%20a%20bug%20to%20me.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-540021%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20exclude%20replies%20from%20the%20count%20of%20Ideas%20in%20a%20board%2C%20and%20only%20show%20number%20of%20actual%20Idea%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-540021%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20this%20same%20situation.%26nbsp%3B%20Ours%20is%20likely%20NOT%20a%20custom%20component.%20Do%20I%20need%20to%20use%20a%20custom%20one%20to%20make%20this%20change%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-539999%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20exclude%20replies%20from%20the%20count%20of%20Ideas%20in%20a%20board%2C%20and%20only%20show%20number%20of%20actual%20Idea%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-539999%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.khoros.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F83105%22%20target%3D%22_blank%22%3E%40dpowles%3C%2FA%3E%26nbsp%3B-%20If%20this%20is%20a%20custom%20component%2C%20then%20there%20will%20be%26nbsp%3B%20LIQL%20query%20used%20and%20you%20need%20to%20make%20a%20change%20in%20that.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-539998%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20exclude%20replies%20from%20the%20count%20of%20Ideas%20in%20a%20board%2C%20and%20only%20show%20number%20of%20actual%20Idea%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-539998%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.khoros.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F53294%22%20target%3D%22_blank%22%3E%40Payal%3C%2FA%3E%26nbsp%3B%2C%20some%20custom%20components%20are%20in%20use%20-%20just%20not%20sure%20if%20this%20one%20is%20custom%20or%20OOTB.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-539997%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20exclude%20replies%20from%20the%20count%20of%20Ideas%20in%20a%20board%2C%20and%20only%20show%20number%20of%20actual%20Idea%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-539997%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.khoros.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F83105%22%20target%3D%22_blank%22%3E%40dpowles%3C%2FA%3E%26nbsp%3B-%20Can%20you%20please%20confirm%20if%20you%20are%20using%20custom%20component%20or%20OOTB%2C%20means%20Khoros%20default%20component%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-539996%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20exclude%20replies%20from%20the%20count%20of%20Ideas%20in%20a%20board%2C%20and%20only%20show%20number%20of%20actual%20Idea%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-539996%22%20slang%3D%22en-US%22%3E%3CP%3EMakes%20sense%2C%20but%20where%20would%20this%20change%20be%20made%20-%20within%20Studio%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20didn't%20configure%20this%20so%20I'm%20not%20familiar%20where%20to%20make%20these%20tweaks%20to%20queries.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-539995%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20exclude%20replies%20from%20the%20count%20of%20Ideas%20in%20a%20board%2C%20and%20only%20show%20number%20of%20actual%20Idea%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-539995%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.khoros.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F83105%22%20target%3D%22_blank%22%3E%40dpowles%3C%2FA%3E%26nbsp%3B-%20You%20need%20to%20add%20%22depth%3D0%22%20if%20you%20are%20using%20LIQL%20query%20to%20get%20the%20ideas%2C%20it%20will%20display%20only%20the%20main%20idea%20post%20and%20exclude%20replies.%3C%2FP%3E%3CP%3EFor%20example%3A%3C%2FP%3E%3CP%3E%3CSTRONG%3ESelect%26nbsp%3Bcount(*)%20from%20messages%20where%20conversation.style%3D'idea'%20and%20depth%20%3D%200%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EPlease%20let%20me%20know%20if%20this%20helps.%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Advisor
Occasional Advisor

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

@ClaudiusH it's a category page using an out of the box component, and the requirement would be to display the counts differently for these ideation nodes than for other content types (forums, TKBs etc)

0 Kudos
Reply
Loading...
Highlighted
Frequent Advisor
Frequent Advisor

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

Categorypage-Components.png

@ClaudiusH Thanks for the direction.  Found the category page and the component is the theme-lib.category-board-tiles.  It appears to be an out of the box component.

As for the LIQL query, I have no idea where I am headed there. 

 

0 Kudos
Reply
Loading...
Frequent Advisor
Frequent Advisor

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

It appears to be a LIQL query since it is out of box. 

I am a neophyte on coding.  Am I able to simply place your "Select" example in this code.

<#assign qry = "SELECT id, title, view_href, description, topics.count(*), c_node_icon_url FROM boards WHERE parent_category.id = '${coreNode.id}' AND hidden=false ORDER BY position ASC" />
<#assign boards = executeLiQLQuery(qry) />

Should I replace the current topics.count(*) and change it to read:

<#assign qry = "SELECT id, title, view_href, description, count(*) from messages where conversation.style='idea' and depth = 0, c_node_icon_url FROM boards WHERE parent_category.id = '${coreNode.id}' AND hidden=false ORDER BY position ASC" />
<#assign boards = executeLiQLQuery(qry) />

 

0 Kudos
Reply
Loading...