Negative Search Filters
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!
Discussions are closed to public comments.
If you need help with Cheddar please
start a new discussion.
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
Support Staff 1 Posted by Marc Guyer on 02 Jun, 2010 06:05 PM
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.
Marc Guyer closed this discussion on 02 Jun, 2010 06:05 PM.
Dan Kamins re-opened this discussion on 02 Jun, 2010 06:11 PM
2 Posted by Dan Kamins on 02 Jun, 2010 06:11 PM
That would be great. I was trying to generalize the suggestion, but really we just want to view our paying customers!
Marc Guyer closed this discussion on 02 Jun, 2010 06:31 PM.