implement new code formatting options
SELECT
......p.PersonType,
......p.NameStyle,
......p.Title
FROM
......Person.BusinessEntity be
INNER JOIN
......Person.Person p
............ON
..................be.BusinessEntityID = p.BusinessEntityID
INNER JOIN
......Person.PersonPhone pp
............ON
..................p.BusinessEntityID = pp.BusinessEntityID
..................AND
..................be.ModifiedDate = pp.ModifiedDate
WHERE
............1 = 1
......AND
............p.Suffix = 'N'
......AND
............p.Title NOT IN ('A1', 'B1','C1')
......AND
............(
..................p.FirstName LIKE '%abc%'
..................OR
..................p.LastName LIKE '%def%'
............)
Add the following options to customize the code formatter regarding the example located above:
For JOIN's
one indent less than current
For WHERE clause
stack conditions
Line break after opening brace of logical operand
Line break before closing brace of logical operand
Indent condition in list braces
Wrap condition -> Arround any logical operator
-
AdminDevart (_, Devart) commented
Hi there,
Thanks for your patience!
Partial implementation of this feature has already been completed.
So we would like to suggest updating to the latest version and check there.
Best,
Devart Support Team -
Wolfgang commented
guys please implement this. The where clauses could use some cleaning and a proper indent helps finding issues especially in more complex queries.