Options
issue - placeWhereConditionOnNewLine doesn't work with "WHERE Match" (graph tables)
aisberg
Posts: 15 Bronze 1
missing line break between Where and MATCH
formatted sql
options are
formatted sql
<div>Select</div><div> Object1.[RepoObject_fullname] As ReferencingObjectName</div><div> , Object1.[RepoObject_type]</div><div> , Object2.[RepoObject_fullname] As ReferencedObjectName</div><div> , Object2.[RepoObject_type]</div><div>--, Object1.[RepoObject_guid]</div><div>--, Object2.[RepoObject_guid]</div><div>From</div><div> [graph].[RepoObject] As Object1</div><div> , [graph].[ReferencedObject] As referenced</div><div> , [graph].[RepoObject] As Object2</div><div><b>Where MATCH(</b></div><div> Object1-(referenced)->Object2)</div><div> And Object1.[RepoObject_type] In ( 'u', 'v' )</div><div> And Object2.[RepoObject_type] In ( 'u', 'v' )</div><div>Order By</div><div> Object1.[RepoObject_fullname]</div><div> , Object2.[RepoObject_fullname]<br></div>
<div> "dml": {</div><div> "clauses": {},</div><div> "listItems": {},</div><div> "addNewLineAfterDistinctAndTopClauses": true,</div><div> "collapseStatementsShorterThan": 75,</div><div> "collapseShortSubqueries": true,</div><div> "collapseSubqueriesShorterThan": 75,</div><div> "listItems": {</div><div> "placeGroupByAndOrderByOnNewLine": "always",</div><div> "placeFromTableOnNewLine": "always",</div><div> <b>"placeWhereConditionOnNewLine": "always"</b></div><div> }</div><div> },</div>
Tagged:
Answers