sql preview select list

• select list(sqlid: 9757063)

  • fmt002_select_list_in_newline
    • false
    • true
      • fmt008_select_list_indent
  • fmt001_select_list_style
    • fit_into_one_line
    • stacked
      • fmt003_select_list_comma_option * before_item_outside_list_with_n_space * fmt004_select_list_comma_space(default:1)

  Samples for json code to save above sqlid with format options(this json code will be used to transport information from web application to back-end program).

  {"sqlid":"9757063",
    "formatOptons":
  	[{"fmt002_select_list_in_newline":true, "fmt008_select_list_indent":2},
  	 {"fmt001_select_list_style":"stacked", "fmt003_select_list_comma_option":"after_item"}
  	]
  }

  Or,

  {"sqlid":"9757063",
    "formatOptons":
  	[{"fmt002_select_list_in_newline":false},
  	 {"fmt001_select_list_style":"fit_into_one_line"}
  	]
  }

  Sample json code send from back-end program to web application

  { "sqlid":"9757063", 
    "formattedSql":"SELECT Name, ProductNumber, ListPrice AS Price\nFROM Production.Product\nORDER BY Name ASC;"
  }

• into clause(9757095)

  • fmt005_select_into_clause_in_newline
    • false
    • true
      • fmt006_select_into_clause_indent(default:2)

• from clause(9757122)

  • fmt009_select_table_in_newline

    • false
    • true
      • fmt010_select_table_indent(default:2)

  • fmt007_select_table_list_style

    • fit_into_one_line
    • stacked
      • fmt011_select_table_list_comma_option * before_item_outside_list_with_n_space * fmt012_select_table_list_comma_space(default:1)

• from clause(join)(9757963)

  • fmt013_join_indent

    • 0: Join clause at the same level with from clause
    • n>0: Join clause at the sub level with from clause

  • fmt014_join_table_in_newline

    • false
    • true
      • fmt015_join_table_indent(default:2)

  • fmt016_join_on_in_newline

    • false
    • true
      • fmt090_join_on_indent(default:2)

• where clause(9757983)

  • fmt017_where_condition_in_newline

    • false
    • true
      • fmt018_where_condition_indent(default:2)

  • fmt019_where_condition_andor

• Group by clause(9757994)

  • fmt021_groupby_list_in_newline

    • false
    • true
      • fmt022_groupby_list_indent(default:2)

  • fmt020_groupby_list_style * fit_into_one_line * stacked * fmt023_groupby_list_comma_option * before_item_outside_list_with_n_space * fmt024_groupby_list_comma_space(default:1)

• Having clause(9758005)

  • fmt025_having_condition_in_newline
    • false
    • true
      • fmt026_having_condition_indent(default:2)

• Order by clause(9758016)

  • fmt028_orderby_list_in_newline

    • false
    • true
      • fmt029_orderby_list_indent(default:2)

  • fmt027_orderby_list_style * fit_into_one_line * stacked * fmt030_orderby_list_comma_option * before_item_outside_list_with_n_space * fmt031_orderby_list_comma_space(default:1)

• Select as subquery(9758026)

  • fmt033_subquery_start_parenthesis_in_newline

    • false
    • true
      • fmt034_subquery_start_parenthesis_indent(default:2)

  • fmt037_subquery_select_keyword_in_newline

    • false
    • true
      • fmt038_subquery_select_keyword_indent(default:2)

  • fmt035_subquery_end_parenthesis_in_newline

    • false
    • true
      • fmt036_subquery_end_parenthesis_indent(default:2)