Happy Business Starts Here

Add "not like" operator to data source filters

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
Zuora-Community
Community Manager
Status changed to: More Feedback Needed
 
Zuora-Community
Community Manager
Status changed to: Under Consideration
 
lderezinski
Tutor

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%'

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

jagan
Zuora Alumni

have you tried this - 

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