API v2 operator "NOT IN"

A few days ago, I also posted an idea for the same peterlu. Hope Lithium would implement it

https://community.lithium.com/t5/Product-Ideas/Exclude-posts-with-certain-board-ids/idi-p/305516

Hi guys,

there is already an idea for is: https://community.lithium.com/t5/Product-Ideas/quot-NOT-IN-quot-operator-for-APIv2/idi-p/218558.

Cheers,

Christian

peterlu

You can achieve this by custom freemarker function. Firstly you can store all the boards IDs that you do not want to show in a freemarker array. Please see below code:

<#assign boards_id = ['board_id_1','board_id_2','board_id_3'] />

After that you can make a rest api v1 or v2 call to fetch all messages and run through loop and also check if the board id exists or not. In my case I am using V2 call. See below code:

<#assign messages = rest("2.0", "/search?q=" + "select * from messages"?url).data.items />
<#list messages as message>
  <#if !boards_id?seq_contains(message.board.id)> <!-- checks if board id is not in mentioned IDs array -->
   <!-- display message's content other than boards you do not want to show -->
  </#if>
</#list>

Please give KUDOS if you find this helpful. Mark as Accepted Solution in case of solution you were looking for.

peterlu

If we achieve this through custom functionality then we certainly be handling the other cases through custom functionality only. We can build custom pagination using an endpoint to fetch results page wise that will have the same logic as I mentioned above. 

As long as we do not have the NOT IN operator we could use customizations to achieve the desired functionality :)

Please give KUDOS if you find this helpful. Mark as Accepted Solution in case of solution you were looking for.

peterlu - 

This query would work in pagination environment. 

select * from messages where board.id in ('board1,board2')

Give kudos if you find my posts helpful or mark solution if it answers your query

Tariq