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

Add NOT conditional operator

Open TrangOul opened this issue 1 year ago • 1 comments

I see not way to introduce NOT operator (not to be confused with NOT IN) in the WHERE part, otherwise than rewriting the query. Example:

WHERE NOT (Industry = 'Agriculture' OR Industry = 'Biotechnology')

cannot be built in this framework; we need to rewrite it as:

WHERE Industry != 'Agriculture' AND Industry != 'Biotechnology'

TrangOul avatar Aug 13 '24 10:08 TrangOul

Hi @TrangOul. Thank you for taking an interest in the repo! I've seen your comments but I cannot get back to them soon due to my workload. I'll try to make some time for this next month.

Regarding this type of condition: yes, the implemented Conditions are rather limited compared to what SOQL allows, so currently to implement this type of condition the best you can do is to use the SimpleConditon class and past the whole string.

4an70m avatar Aug 13 '24 10:08 4an70m