SQLinForm SQL Formatter

Formatting Ideas, Issues and Questions

Last Post by Zero 8 months ago

7 Posts

3 Users

2 Reactions

271 Views

Zero

(@zero)

Member

Joined: 12 months ago

Posts: 11

Topic starter 02/04/2024 8:13 am

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: 2 years ago

Posts: 17

02/04/2024 12:04 pm

Hallo Zero
this is possible:

Guido reacted

ReplyQuote

Zero

(@zero)

Member

Joined: 12 months ago

Posts: 11

Topic starter 03/04/2024 8:09 am

Hello, thanks for your reply.

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

ReplyQuote

Guido

(@admin)

Member Admin

Joined: 3 years ago

Posts: 216

03/04/2024 9: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

Regards

Guido

This post was modified 8 months ago by Guido

ReplyQuote

Zero

(@zero)

Member

Joined: 12 months ago

Posts: 11

Topic starter 07/04/2024 2:46 am

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

ReplyQuote

Guido

(@admin)

Member Admin

Joined: 3 years ago

Posts: 216

09/04/2024 9:00 pm

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

ReplyQuote

Zero

(@zero)

Member

Joined: 12 months ago

Posts: 11

Topic starter 11/04/2024 3:31 pm

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

ReplyQuote

suggestions for AND/OR indent