I'm not sure which options controls this... Boolean clauses, with parentheses, are not indented "properly". The sample code in the plugin has only very simple Boolean and doesn't reflect a complex clause. See example below
Notepad++ v8.4.5 (x64)
SQLinForm GUI 6.22.9.9, Engine 6.22.03.31
Here is example of as close as I could get.
CASE
WHEN SHORT_DCE_TYPE IN ('S', 'N')
AND ( ALGN_TYPE = 'C'
OR ( ALGN_TYPE = 'V'
AND VA_CAT = 'C' ) )
AND FIN_ELIG = 1
AND BENE_RATIO <= 3.00
AND ( ( BNMRK = 'A'
AND RYSUM.BENE_DCNT_ANNUAL_RY >= 1500 )
OR ( BNMRK = 'E'
AND RYSUM.BENE_DCNT_ANNUAL_RY >= 50 ) )
THEN 0.12345
WHEN SHORT_DCE_TYPE = 'H'
OR ( SHORT_DCE_TYPE IN ('S', 'N')
AND ALGN_TYPE = 'V'
AND VA_CAT = 'N' )
THEN 0.56789
ELSE NULL
END AS THIS_VALUE
The nested indentation of Boolean causes I'm trying to obtain should be something like this:
CASE
WHEN SHORT_DCE_TYPE IN ('S', 'N')
AND ( ALGN_TYPE = 'C'
OR ( ALGN_TYPE = 'V'
AND VA_CAT = 'C' ) )
AND FIN_ELIG = 1
AND BENE_RATIO <= 3.00
AND ( ( BNMRK = 'A'
AND RYSUM.BENE_DCNT_ANNUAL_RY >= 1500 )
OR ( BNMRK = 'E'
AND RYSUM.BENE_DCNT_ANNUAL_RY >= 50 ) )
THEN 0.12345
WHEN SHORT_DCE_TYPE = 'H'
OR ( SHORT_DCE_TYPE IN ('S', 'N')
AND ALGN_TYPE = 'V'
AND VA_CAT = 'N' )
THEN 0.56789
ELSE NULL
END AS THIS_VALUE
Yes, that would be very helpful ?
@jpotelle Hi,
the new release 06.22.09.30 is available for download from my website.
In case you do not see the new release you may need to delete the browser's cache
Please give it a try
Regards
Guido
It's working. Thank you! ?