Skip to content

Format WHERE clause improvement #224

@paustint

Description

@paustint
  • Feature
  • Bug

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%')
	)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions