How can I filter by 'is not' [variable]?

Get Help
1

I want to put a variable in this box, instead of a specific ID. In this case, I want to filter by cases where the HostCollectiveID ≠ CollectiveID but that ID itself changes for every row, so I need to define it by the variable. Is there a way?

45%20PM
45%20PM844×412 15.9 KB

2

Hi @alanna
I don't know your table structure, so it's difficult to say what you should do, but sounds like you would need to create a SQL question like this:

select * from transactions
where hostcollectiveid not in (select collectiveid from collectives where {{filter}})