WHERE formatting alignment

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
JaneDilbert
Posts: 3
Joined: Mon 09 Aug 2021 07:06

WHERE formatting alignment

Post by JaneDilbert » Mon 09 Aug 2021 07:13

Hi,

I am struggling setting one part of my custom SQL Complete formatting profile for the WHERE clause alignment. Is this possible?

Current result:

Code: Select all

SELECT  * 
FROM    sys.objects o
WHERE   name = 'Something'
        AND object_id = 123
Desired result:

Code: Select all

SELECT  * 
FROM    sys.objects o
WHERE   name = 'Something'
AND     object_id = 123
Thanks!

alexa

Re: WHERE formatting alignment

Post by alexa » Tue 10 Aug 2021 10:34

You would need to unselect the following option

Image

JaneDilbert
Posts: 3
Joined: Mon 09 Aug 2021 07:06

Re: WHERE formatting alignment

Post by JaneDilbert » Thu 12 Aug 2021 23:53

Thanks for your reply alexa.

That would mean the conditions are not aligned at all. Isn't there a way to align the conditions instead of the logical operator?

Thanks

alexa

Re: WHERE formatting alignment

Post by alexa » Fri 13 Aug 2021 18:35

There is no such a possibility. Though, you can add a suggestion on the UserVoice forum where other users can vote for it https://devart.uservoice.com/forums/87893-sql-complete

We collect and analyze the information from this forum in order to make a proper roadmap for the future product releases.

JaneDilbert
Posts: 3
Joined: Mon 09 Aug 2021 07:06

Re: WHERE formatting alignment

Post by JaneDilbert » Sat 14 Aug 2021 01:05

I see. Thanks for your time. :)

gmoi19
Posts: 1
Joined: Fri 22 Apr 2022 09:37

Re: WHERE formatting alignment

Post by gmoi19 » Fri 22 Apr 2022 09:41

Thank you all. It's really helpful for me.

Post Reply