mbiel
Expert
Joined 8 years ago
Joined 8 years ago
For board.id != operator only support one time in the constraints at the moment and not worked with multiple != for same constraints.
To achieve this you need some more coding knowledge.
I would suggest firstly get all the boards from that category and match the board id which you don't want to include for results and create the collection of these boards with comma separated('wireless', 'routers').
Pass this collection to query with IN operator for board.id like below:
SELECT id FROM messages WHERE board.id IN ('wireless', 'routers')