Page 1 of 1

WHERE formatting alignment

Posted: Mon 09 Aug 2021 07:13
by JaneDilbert
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!

Re: WHERE formatting alignment

Posted: Tue 10 Aug 2021 10:34
by alexa
You would need to unselect the following option

Image

Re: WHERE formatting alignment

Posted: Thu 12 Aug 2021 23:53
by JaneDilbert
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

Re: WHERE formatting alignment

Posted: Fri 13 Aug 2021 18:35
by alexa
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.

Re: WHERE formatting alignment

Posted: Sat 14 Aug 2021 01:05
by JaneDilbert
I see. Thanks for your time. :)

Re: WHERE formatting alignment

Posted: Fri 22 Apr 2022 09:41
by gmoi19
Thank you all. It's really helpful for me.