Reverse filter match "in"

Shane Lenzen · Sep 4th 2019

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

Code

perch_collection('Cocktails',[
'template'=>'cocktails/_list_item.html',
'sort' => '_order',
'sort-order' => 'asc',
'filter' => [
[
'filter' => '_id',
'match' => 'neq',
'value' => $featured_cocktails[0]['feat_cocktail'][0],
],
[
'filter' => '_id',
'match' => 'neq',
'value' => $featured_cocktails[0]['visitor_ctr_cocktail'][0],
]
],
'match'=>'and',
'count'=>4,
'paginate'=>true,
]);

Display More

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:

Code

perch_collection('Cocktails',[
'template'=>'cocktails/_list_item.html',
'sort' => '_order',
'sort-order' => 'asc',
'filter' => [
[
'filter' => '_id',
'match' => 'in',
'value' => $featured_cocktails[0]['feat_cocktail'][0].','.$featured_cocktails[0]['visitor_ctr_cocktail'][0],
],
],
'match'=>'and',
'count'=>4,
'paginate'=>true,
]);

Display More

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?

Shane Lenzen · Sep 11th 2019

Bump? If anyone knows how to accomplish this I would greatly appreciate it! Also, sorry if I put this under the wrong topic...probably should have gone in Site Building Questions.

Byron Fitzgerald · Sep 12th 2019

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.