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
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')
