{"id":951,"date":"2021-12-08T13:47:59","date_gmt":"2021-12-08T20:47:59","guid":{"rendered":"http:\/\/sqldbpros.com\/wordpress\/?p=951"},"modified":"2021-12-08T13:51:17","modified_gmt":"2021-12-08T20:51:17","slug":"format-sql-in-sisense-cdt","status":"publish","type":"post","link":"http:\/\/sqldbpros.com\/wordpress\/2021\/12\/format-sql-in-sisense-cdt\/","title":{"rendered":"Format SQL in Sisense CDT"},"content":{"rendered":"\n<p>This is one of those posts that's here for my own benefit more than yours. I can never seem to google up the solution to this one so if I put it here with a title that matches what I was googling, maybe I'll be able to google my own article.<\/p>\n\n\n\n<p>So, how do you automatically format the SQL query for a Sisense Cloud Data Teams chart?<\/p>\n\n\n\n<p>It can only be done via a keyboard shortcut, (and it seems the only place this feature is documented is on the Sisense CDT keyboard shortcuts page)<\/p>\n\n\n\n<p><strong>If you highlight your SQL and press \u2318+Shift+L on a mac (or Ctrl+Shift+L on other keyboards) your code will be formatted!<\/strong><\/p>\n\n\n\n<p>That's it! You're a wizard!<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"http:\/\/sqldbpros.com\/wordpress\/wp-content\/uploads\/2021\/12\/image.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"316\" src=\"http:\/\/sqldbpros.com\/wordpress\/wp-content\/uploads\/2021\/12\/image-1024x316.png\" alt=\"\" class=\"wp-image-952\" srcset=\"http:\/\/sqldbpros.com\/wordpress\/wp-content\/uploads\/2021\/12\/image-1024x316.png 1024w, http:\/\/sqldbpros.com\/wordpress\/wp-content\/uploads\/2021\/12\/image-300x93.png 300w, http:\/\/sqldbpros.com\/wordpress\/wp-content\/uploads\/2021\/12\/image-768x237.png 768w, http:\/\/sqldbpros.com\/wordpress\/wp-content\/uploads\/2021\/12\/image-1536x474.png 1536w, http:\/\/sqldbpros.com\/wordpress\/wp-content\/uploads\/2021\/12\/image-2048x632.png 2048w, http:\/\/sqldbpros.com\/wordpress\/wp-content\/uploads\/2021\/12\/image-1568x484.png 1568w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>Before...<\/figcaption><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"http:\/\/sqldbpros.com\/wordpress\/wp-content\/uploads\/2021\/12\/image-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"316\" src=\"http:\/\/sqldbpros.com\/wordpress\/wp-content\/uploads\/2021\/12\/image-1-1024x316.png\" alt=\"\" class=\"wp-image-953\" srcset=\"http:\/\/sqldbpros.com\/wordpress\/wp-content\/uploads\/2021\/12\/image-1-1024x316.png 1024w, http:\/\/sqldbpros.com\/wordpress\/wp-content\/uploads\/2021\/12\/image-1-300x93.png 300w, http:\/\/sqldbpros.com\/wordpress\/wp-content\/uploads\/2021\/12\/image-1-768x237.png 768w, http:\/\/sqldbpros.com\/wordpress\/wp-content\/uploads\/2021\/12\/image-1-1536x474.png 1536w, http:\/\/sqldbpros.com\/wordpress\/wp-content\/uploads\/2021\/12\/image-1-2048x632.png 2048w, http:\/\/sqldbpros.com\/wordpress\/wp-content\/uploads\/2021\/12\/image-1-1568x484.png 1568w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>After<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"http:\/\/sqldbpros.com\/wordpress\/wp-content\/uploads\/2021\/12\/Sisense-CDT-SQL-Format-scaled.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"768\" src=\"http:\/\/sqldbpros.com\/wordpress\/wp-content\/uploads\/2021\/12\/Sisense-CDT-SQL-Format-1024x768.jpg\" alt=\"\" class=\"wp-image-956\" srcset=\"http:\/\/sqldbpros.com\/wordpress\/wp-content\/uploads\/2021\/12\/Sisense-CDT-SQL-Format-1024x768.jpg 1024w, http:\/\/sqldbpros.com\/wordpress\/wp-content\/uploads\/2021\/12\/Sisense-CDT-SQL-Format-300x225.jpg 300w, http:\/\/sqldbpros.com\/wordpress\/wp-content\/uploads\/2021\/12\/Sisense-CDT-SQL-Format-768x576.jpg 768w, http:\/\/sqldbpros.com\/wordpress\/wp-content\/uploads\/2021\/12\/Sisense-CDT-SQL-Format-1536x1152.jpg 1536w, http:\/\/sqldbpros.com\/wordpress\/wp-content\/uploads\/2021\/12\/Sisense-CDT-SQL-Format-2048x1536.jpg 2048w, http:\/\/sqldbpros.com\/wordpress\/wp-content\/uploads\/2021\/12\/Sisense-CDT-SQL-Format-1568x1176.jpg 1568w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is one of those posts that's here for my own benefit more than yours. I can never seem to google up the solution to this one so if I put it here with a title that matches what I was googling, maybe I'll be able to google my own article. So, how do you [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-951","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/posts\/951","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/comments?post=951"}],"version-history":[{"count":3,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/posts\/951\/revisions"}],"predecessor-version":[{"id":957,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/posts\/951\/revisions\/957"}],"wp:attachment":[{"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/media?parent=951"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/categories?post=951"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/sqldbpros.com\/wordpress\/wp-json\/wp\/v2\/tags?post=951"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}