This message was deleted.
# general
s
This message was deleted.
m
If you use your criteria setting "items purchased" to be "any of (items i want in my group) this will exclude those who have not purchased items
j
Currently, I have that set in my criteria setting, it doesn't seem to be excluding customers who have purchased "items within a group" alongside other items
r
The above will not work. Let's assume customer A, B And item X, Y. Customer B has purchased the item in transaction 1. Now if you do a search to see which all customers has bought the item X or item Y. You will get customer B as a result. But if you do a search for customers where they have not bought items X, Y. You will end up with get customer A and all transaction line of B where item was not among X, Y. The easiest way to achieve this is in suiteql where you do a nested query. Where you can get a list of all customers not present in the list of customers who purchased item in your specified criteria.
Select c.name FROM customers as c WHERE c.id NOT IN ( Select c.id --- your query to get those customers who bought the items meeting your criteria )
j
I've never used suiteql, as I'm trying to create this as a saved search to pass off to someone else, is there a way to get this same effect using a saved customer or transaction search? For added clarity: Lets say I have customers A,B and Items X,Y Customer A has bought ONLY item X Customer B has bought BOTH item X and Y I want to create a saved search that would only return customers that purchased items X exclusively. Currently, I have a saved search that can return customers that have purchased ANY of items X, and Y, but I am having troubles making it return customers that have purchased ONLY items X,Y
As of right now, if I run my saved search, Customer A and B will both appear, but my intended effect is for customer A to be the only one to appear
m
Ok use criteria summary count = 1 For Customer A have bought only Item X ( the count is 1) For customer B have bought item X and Y ( the count is 2)