Negative Search Filters

Dan Kamins's Avatar

Dan Kamins

02 Jun, 2010 05:59 PM

To find all customers with PLAN1 or PLAN2 or PLAN3, we can post:

planCode[]=PLAN1&planCode[]=PLAN2&planCode[]=PLAN3

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).

This suggestion is for support to be able to post something like:

planCode_INV[]=FREETRIAL

And that would load all the customers who are not on the free trial. Otherwise we have to either:

  • denormalize / embed the list of current plans in all of our queries, which is difficult to maintain.

  • 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.

Thanks!

  1. Support Staff 1 Posted by Marc Guyer on 02 Jun, 2010 06:05 PM

    Marc Guyer's Avatar

    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.

  2. Marc Guyer closed this discussion on 02 Jun, 2010 06:05 PM.

  3. Dan Kamins re-opened this discussion on 02 Jun, 2010 06:11 PM

  4. 2 Posted by Dan Kamins on 02 Jun, 2010 06:11 PM

    Dan Kamins's Avatar

    That would be great. I was trying to generalize the suggestion, but really we just want to view our paying customers!

  5. Marc Guyer closed this discussion on 02 Jun, 2010 06:31 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac