API v2 operator "NOT IN"
Hi Lithium, When can we have this function for the API v2? For example, Customers would like to query all messages except for few boards. Peter
Views
Sign in to react to this post
Forum Discussion
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
TariqHussain yes, your query works. But if a customer has 100+ boards, and they just want to ignore (NOT IN) 1 board only. It is not a good idea to do board.id in ('board1', 'board2'..........'board300')
