LIQL - How to exclude message from board which has setting "Hide messages in this board from lists"

Question

I want to exclude messages from the boards which has setting "Hide messages in this board from lists" using LIQL query. Does anyone have any suggestions?

varungrazitti · Answer

pradeepc&nbsp;- You need to pass an additional parameter to the API, show_hidden=false

vikasb · Answer

Hi&nbsp;pradeepc&nbsp; If the setting is "Hide messages in this board from lists" then automatically it will exclude the message from that board. &nbsp;

pradeepc · Answer

VikasB&nbsp;I have custom query which fetches latest posts from all the boards and I want to apply this setting in this query.

vikasb · Answer

Hi&nbsp;pradeepc&nbsp; You are right. It's showing the messages from those boards even setting "Hide messages in this board from lists" is applied. Might be it's an issue on lithium side. You can raise a to confirm it.&nbsp;If you want to exclude the messages from some specific and known boards than you can use the custom approach as well.&nbsp;&lt;#assign excIds = ["Id1", "Id2","Id3"] /&gt;  //boards ids from which messages need to be excluded
&lt;#assign msgs= rest( "2.0", "/search?q=" + "select * from messages order by post_time desc"?url).data /&gt;
&lt;#list msgs.items as msg&gt;
&lt;#if excIds?seq_index_of(msg.board.id)== -1 &gt;
//do something here
&lt;/#if&gt;
&lt;/#list&gt;&nbsp;&nbsp;

satya · Answer

Hi&nbsp;pradeepc,&nbsp;Hope this might help you&nbsp;SELECT id, view_href, title, messages.count(*) FROM boards WHERE hidden = falseThanks &amp; Regards,Srujana Satya Datla.

Forum Discussion

LIQL - How to exclude message from board which has setting "Hide messages in this board from lists"

Related Content

API for "Hide messages in this board from lists"

API to get status of "Hide from lists and menus" of Idea Inside any Category

Quickest way to get "unanswered topic count" in a board list?

how to modify the "Hide from lists and menus" property using REST API

Messages and Categories

Recent Discussions

Connecting Khoros data to CRM (Salesforce)

How do I get the article ID in Freemarker in a TkbArticle?

400/404 error on POST request

Online User Count is Completely Wrong

TinyMceEditor is undefined