apex-query-builder icon indicating copy to clipboard operation
apex-query-builder copied to clipboard

No generalized form or LIKE and NOT LIKE

Open TrangOul opened this issue 1 year ago • 0 comments

The only LIKE and NOT LIKE conditions possible to be constructed with this framework are:

    Field__c LIKE '%x%' /* likeAnyBoth */
    Field__c LIKE '%x'  /* likeAnyLeft */
    Field__c LIKE  'x%' /* likeAnyRight */
NOT Field__c LIKE '%x%' /* notLikeAnyBoth */

These are the most common usages of LIKE, but not the only ones. While it is possible to write, say, LIKE '%x_y%z' by using likeAnyLeft('x_y%z'), there seems to be no way to write queries without % at one of the ends, like:

WHERE Email LIKE 'forename%.com'

TrangOul avatar Aug 13 '24 11:08 TrangOul