I also need to know how to query a field that is not blank. We can query filed "is blank" but cannot query "is not blank". We need that to create a segment of contacts purchasing direct from us versus our distribution channels. There is an ID number that would allow us to quickly create the segment we need, but we need the option to query the custom field in a general sense. If Big Commerce ID is not blank that will segment our customers from our imported Salesforce list of contacts.
... View more
