suggestions for AND/OR indent

 
Formatting Ideas, Issues and Questions
Last Post by Zero 2 years ago
7 Posts
3 Users
2 Reactions
533 Views
 Zero
(@zero)
Member
Joined: 2 years ago
Posts: 11
Topic starter 02/04/2024 9:13 am   [#109]

Hi, I have  a suggestion for adding a "indent AND/OR in AND/OR condition" option, please and the features if you agree with it, thanks

Example:

-- origin code:

select * from tables
where 1=1 and (2=2 or (3=3 and 4=4 and 5=5))

;

-- now formatted:

SELECT
       *
  FROM TABLES
 WHERE 1 = 1
       AND(2 = 2
       OR(3  = 3
       AND 4 = 4
       AND 5 = 5 ) )

;

-- hope: add a "indent AND/OR in AND/OR condition" option

SELECT
       *
  FROM TABLES
 WHERE 1 = 1
       AND(2 = 2
           OR(3  = 3
              AND 4 = 4
              AND 5 = 5 ) )


   
Guido reacted
Quote
 Benjamin Moeller
(@benjamin-moeller)
Member
Joined: 4 years ago
Posts: 17
02/04/2024 1:04 pm  

Hallo Zero
this is possible:

image


   
Guido reacted
ReplyQuote
 Zero
(@zero)
Member
Joined: 2 years ago
Posts: 11
Topic starter 03/04/2024 9:09 am  

Hello, thanks for your reply.

Follow the setting in my vscode with plugin v2.0.60, It seems don't work

image


   
ReplyQuote
Guido
 Guido
(@admin)
Member Admin
Joined: 4 years ago
Posts: 295
03/04/2024 10:35 pm  

Hello @zero, thanks for your reply.

Are you working with the free or pro Version of VSCode Plugin?

This is what I get in VSCode

grafik

Regards

Guido



   
ReplyQuote
 Zero
(@zero)
Member
Joined: 2 years ago
Posts: 11
Topic starter 07/04/2024 3:46 am  

Hi @admin , In my VSCode(1.88.0) with Plugin(v2.0.60) and  pro Version, I get this:

image


   
ReplyQuote
Guido
 Guido
(@admin)
Member Admin
Joined: 4 years ago
Posts: 295
09/04/2024 10:00 pm  

Could you please send me the results of this command via mail to info@sqlinform.com

grafik


   
ReplyQuote
 Zero
(@zero)
Member
Joined: 2 years ago
Posts: 11
Topic starter 11/04/2024 4:31 pm  

@admin I have send you the file, please check your mailbox, thanks



   
ReplyQuote
Forum Jump:
  Previous Topic
Next Topic  
Share: