Happy Business Starts Here

Add "not like" operator to data source filters

There is an obvious operator missing from the filters in the export data sources functionality. 

While it is possible to filter a list by a LIKE operator, there is no NOT LIKE operator.  Thus if I want to export all subscriptions that start with "NF" I can do a filter "LIKE NF%" but if I want all the other subscriptions i.e. the ones that don't start with NF, I don't have a way of doing that.

So, can we please have a NOT LIKE operator on the filters...

5 Comments
Community Manager
Status changed to: More Feedback Needed
 
Community Manager
Status changed to: Under Consideration
 

This would be quite helpful to to our case as well, we have a custom string field which we would want to do the following:  select id, foo from bar where foo NOT LIKE 'this%'

Zuora Alumni

Could you create a detail report in reporting and get what you need here? Text operators like 'starts with,' 'does not start with,' 'contains,' 'does not contain,' etc are available there.

Zuora Staff

have you tried this - 

... where not (subscription.name like 'NF%')