Reverse filter match "in"

  • I'm trying to filter a collection using multiple values that do NOT equal an item ID. First I tried this:



    I then realized that I'm supposed to use match type "in" with comma separated values. The problem is I need the reverse of that output. Basically, I need the reverse of this:



    Do I need to use a callback function? If so, will it work with paging, and how can I bring the IDs into the function?

  • You might be able to use notcontains as notin is not supported, it does use NOT REGEXP in the query, so you might need to check the format of the value. Have you checked the SQL query thats being generated, you should be able to find this if you have PERCH_DEBUG turned on.