search

jetstreamapp / soql-parser-js

Javascript SOQL parser
https://jetstreamapp.github.io/soql-parser-js/
MIT License
77 stars 20 forks source link

Format WHERE clause improvement #224

Open paustint opened 1 year ago

paustint commented 1 year ago

Description

WHERE clause formatting has some cases where formatting does not work properly.

SELECT ID FROM Account WHERE OwnerId = '0013t00001nJsHJAA0' AND ( AccountNumber = 'Open' OR AccountNumber = 'Called Off Rent' ) AND ( (NOT Name LIKE 'H%') OR (NOT Name LIKE 'L%') OR (NOT Name LIKE 'W%') OR (NOT Name LIKE 'R%') )
SELECT ID
FROM Account
WHERE OwnerId = '0013t00001nJsHJAA0'
    AND (
        AccountNumber = 'Open'
        OR AccountNumber = 'Called Off Rent'
    )
    AND (
(NOT Name LIKE 'H%')
    OR (NOT Name LIKE 'L%')
    OR (NOT Name LIKE 'W%')
    OR (NOT Name LIKE 'R%')
    )