Happy Business Starts Here

Master

How to query "not like 'foo%'"?

I'm trying to query products that don't start with "Deactivated". None of the following querie were valid. How do I express this?

 

  • select name from product where name not like 'Deactivated%'
  • select name from product where not name like 'Deactivated%'
  • select name from product where (not name like 'Deactivated%')
  • select name from product where (name not like 'Deactivated%')
  • select name from product where not (name like 'Deactivated%')

 

Note that the following is valid:

 

  • select name from product where name like 'Deactivated%'

 

See https://knowledgecenter.zuora.com/DC_Developers/M_Export_ZOQL/F_Filter_Statements#Using_Parentheses_...

1 REPLY 1
Zuora Staff

Re: How to query "not like 'foo%'"?

Hi, 

 

There currently is no "not like" operator

 

This is under consideration.

Please up-vote this request: https://community.zuora.com/t5/Reporting-Ideas/Add-quot-not-like-quot-operator-to-data-source-filter...

 

Thanks,

Kevin