NebulaQueryAndSearch icon indicating copy to clipboard operation
NebulaQueryAndSearch copied to clipboard

There is no NOT LIKE operator in SOQL

Open TrangOul opened this issue 1 year ago • 0 comments

There is no NOT LIKE operator in SOQL.

The following fails on the query:

new Query(Account.SObjectType)
	.filterWhere(new SOQL.QueryFilter(Account.Name, SOQL.Operator.IS_NOT_LIKE, 'xyz'))
	.getResults()

The correct syntax is NOT Field__c LIKE 'value'. Please either remove the SOQL.Operator.IS_NOT_LIKE operator or leave it as syntactic sugar, but with correct syntax, possibly as the negation of LIKE by making filters recursive and implementing the NOT operator (#53).

TrangOul avatar Aug 13 '24 11:08 TrangOul