tag:support.getcheddar.com,2009-06-01:/discussions/suggestions/47-negative-search-filtersCheddar: Discussion 2018-10-18T14:43:24Ztag:support.getcheddar.com,2009-06-01:Comment/18363652010-06-02T17:59:39Z2010-06-02T17:59:39ZNegative Search Filters<div><p>To find all customers with PLAN1 or PLAN2 or PLAN3, we can
post:<br></p>
<pre>
<code>planCode[]=PLAN1&planCode[]=PLAN2&planCode[]=PLAN3</code>
</pre>
<p>But let's say we have 20+ plans, and others are added from time
to time. We want to find all customers on ANY of the plans EXCEPT a
specific plan (which most commonly happens to be our "free trial
plan", i.e. we want to find all paying customers).</p>
<p><strong>This suggestion is for support to be able to post
something like:</strong></p>
<pre>
<code>planCode_INV[]=FREETRIAL</code>
</pre>
<p>And that would load all the customers who are not on the free
trial. Otherwise we have to either:</p>
<ul>
<li>
<p>denormalize / embed the list of current plans in all of our
queries, which is difficult to maintain.</p>
</li>
<li>
<p>load all plans at query time, build a special filter list for
the query, then execute the query, which is is slower and feels
overly complex.</p>
</li>
</ul>
<p>Thanks!</p></div>Dan Kaminstag:support.getcheddar.com,2009-06-01:Comment/18363652010-06-02T18:05:57Z2010-06-02T18:05:57ZNegative Search Filters<div><p>We'd like to keep that filter fairly simple. We'll entertain the
idea of a paid/free switch. It's on the agenda for discussion
here.</p></div>Marc Guyertag:support.getcheddar.com,2009-06-01:Comment/18363652010-06-02T18:11:05Z2010-06-02T18:11:05ZNegative Search Filters<div><p>That would be great. I was trying to generalize the suggestion,
but really we just want to view our paying customers!</p></div>Dan Kamins