how to exclude posts with certain board ids
Hello, I want to execute a query where I can exclude posts from given board ids. I tried below approach : SELECT * FROM messages WHERE board.id NOT IN ('board-name') But getting exception that ...
Forum Discussion
ronaksomani - Try this instead, you dont need to use V2 for this, simple if condition can do this.
<#if boardID != "exclude_board">
//run you query here
SELECT * FROM messages WHERE board.id = 'boardID'
</#if>
VarunGrazitti : Can I pass list of board-ids to that if condition? As my requirement is to filter all those posts which have mentioned board-ids. Here I can have multiple board-ids which I want to filter.
ronaksomani - how long is the list of the boards to exclude? you can use or condition as below:
<#if boardID != "exclude_bd1" || boardID != "exclude_bd2" || boardID != "exclude_bd3">
</#if>
VarunGrazitti :List can have n number of board ids ranging any where from 0-25. So would perefer if there is any other solution for same. May be something like SELECT * FROM messages WHERE board.id NOT IN ('board-name'). NOT IN is part of SQL query. Is there any alternatives for this?
did you find how to do this?
I need it too, looking around and not able to find a simple one API call for all tkbs in specific category, all boards except one specific board.
