Forum Discussion

ronaksomani's avatar
ronaksomani
Mentor
11 years ago

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 ...
bowenli's avatar
bowenli
Ace
11 years ago

a more maintainable version:

 

<#assign excIds = ["Id1", "Id2","Id3"] />

<#if excIds?seq_index_of(boardId)== -1 >

 //do something here
</#if>