{"id":41128,"date":"2022-04-21T01:53:21","date_gmt":"2022-04-21T00:53:21","guid":{"rendered":"https:\/\/developer.kore.ai\/v10-1\/?p=41128"},"modified":"2022-04-21T01:53:38","modified_gmt":"2022-04-21T00:53:38","slug":"table-views","status":"publish","type":"post","link":"https:\/\/developer.kore.ai\/v10-1\/docs\/bots\/advanced-topics\/table-views\/?lang=ko","title":{"rendered":"\ud14c\uc774\ube14 \ubdf0"},"content":{"rendered":"<section class=\"l-section wpb_row height_auto\"><div class=\"l-section-h i-cf\"><div class=\"g-cols vc_row type_default valign_top\"><div class=\"vc_col-sm-12 wpb_column vc_column_container\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\">\r\n\t<div class=\"wpb_text_column \">\r\n\t\t<div class=\"wpb_wrapper\">\r\n\t\t\t<p>\ud14c\uc774\ube14 \ubdf0\ub780 \ud558\ub098 \uc774\uc0c1\uc758 \ub370\uc774\ud130 \ud14c\uc774\ube14\uc744 \uacb0\ud569\ud558\uc5ec \uc0ac\uc6a9\uc790 \uc815\uc758 \ub370\uc774\ud130 \uc138\ud2b8\ub97c \uc0dd\uc131\ud560 \uc218 \uc788\uac8c \ud574\uc90d\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uc815\uc758\ub294 \ucffc\ub9ac\ub85c \ubcc0\ud658\ub418\uc5b4 \ud544\uc694\ud55c \uc870\uc778\uc744 \uc0ac\uc6a9\ud568\uc73c\ub85c\uc368 \ud558\ub098 \uc774\uc0c1\uc758 \ud14c\uc774\ube14\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac00\uc838\uc635\ub2c8\ub2e4.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"i\">\uc815\uc758<\/span><\/h2>\n<p>\ubdf0 \uc815\uc758\ub294 \ud3ec\ud568\ud569\ub2c8\ub2e4:<\/p>\n<ul>\n<li>\ubdf0\uc5d0 \ub300\ud55c <strong>\uc774\ub984<\/strong>\uc785\ub2c8\ub2e4.<\/li>\n<li>\ubdf0 <strong>\uc124\uba85<\/strong><\/li>\n<li>\ubdf0\uc5d0 \uc561\uc138\uc2a4\ud558\uae30 \uc704\ud55c \ubd07 \ubc0f \uc571 <strong>\ud560\ub2f9<\/strong><br \/> <a ref=\"magnificPopup\" href=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125645\/data_views.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-28026\" src=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125645\/data_views.png\" alt=\"\" width=\"1365\" height=\"291\" srcset=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125645\/data_views.png 1365w, https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125645\/data_views-300x64.png 300w, https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125645\/data_views-1024x218.png 1024w\" sizes=\"auto, (max-width: 1365px) 100vw, 1365px\" \/><\/a><\/li>\n<li>\ubdf0\ub294 <strong>\ub2e8\uc77c \ud14c\uc774\ube14<\/strong> \ub610\ub294 <strong>\ub2e4\uc911 \ud14c\uc774\ube14<\/strong>\uc5d0\uc11c \uad6c\ucd95\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\n<ul>\n<li>\ub450 \uc720\ud615 \ubaa8\ub450, \ub2e4\uc74c\uacfc \uac19\uc774 \ud574\uc57c \ud569\ub2c8\ub2e4.\n<ul>\n<li><strong>\ud14c\uc774\ube14<\/strong>\uc744 \uc120\ud0dd\ud569\ub2c8\ub2e4;<\/li>\n<li>\ubdf0\uc5d0 \ud3ec\ud568\ub420 <strong>\uc5f4<\/strong>\uc744 \uc120\ud0dd\ud558\uace0, <code>sum, avg, min, max and count<\/code>\uc640 \uac19\uc740 \ud1b5\uacc4 \ud568\uc218\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc0ac\uc6a9 \uc608\uc2dc: <code>count(&lt;table_name&gt;.&lt;column_name&gt;)<\/code><\/li>\n<li>\ub2e4\uc74c\uc744 \uc0ac\uc6a9\ud558\uc5ec \uacb0\uacfc\ub97c <strong>\ud544\ud130\ub9c1\ud558\uae30 \uc704\ud55c \ubc94\uc704<\/strong>\n<ul>\n<li>\uc5f4 \uc774\ub984 &#8211; \ub4dc\ub86d\ub2e4\uc6b4 \ubaa9\ub85d \uc911 \uc120\ud0dd;<\/li>\n<li>\ube44\uad50 \uc5f0\uc0b0\uc790 &#8211; =, !=, &lt;  \ub610\ub294 &gt; \uc911 \uc120\ud0dd<\/li>\n<li>\ube44\uad50 \uc5f0\uc0b0\uc790<\/li>\n<li>AND\/OR \uc5f0\uc0b0\uc790\ub85c \uc5f0\uacb0\ub41c \ub2e4\uc911 \ud544\ud130 \ubc94\uc704\ub97c \uc124\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n<\/li>\n<li><code>&lt;table_name&gt;.&lt;column_name&gt;<\/code>\uc640 \uac19\uc740 \uadf8\ub8f9\uc5d0 \uac19\uc740 \ub370\uc774\ud130\ub97c \ubc30\uc5f4\ud558\uae30 \uc704\ud55c <strong>\uadf8\ub8f9\ubcc4<\/strong> \uc5f4, \uadf8\ub9ac\uace0<\/li>\n<li>\uacb0\uacfc\uc758 \uc21c\uc11c\ub97c \uc9c0\uc815\ud558\uae30 \uc704\ud55c <strong>\uc815\ub82c \uae30\uc900<\/strong> \uc5f4 <code>&lt;table_name&gt;.&lt;column_name&gt; asc\/desc<\/code><\/li>\n<\/ul>\n<p><a ref=\"magnificPopup\" href=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125728\/data_views_single.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-28028\" src=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125728\/data_views_single.png\" alt=\"\" width=\"679\" height=\"693\" srcset=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125728\/data_views_single.png 679w, https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125728\/data_views_single-294x300.png 294w\" sizes=\"auto, (max-width: 679px) 100vw, 679px\" \/><\/a><\/li>\n<li>\uadf8\ubc16\uc5d0, \ub2e4\uc911 \ud14c\uc774\ube14 \ubdf0\uc5d0 \ub300\ud574\uc11c\ub294, \ub2e4\uc74c\uc744 \uc124\uc815\ud558\uc5ec <strong>\uacb0\ud569<\/strong> \ubc94\uc704\ub97c \uc9c0\uc815\ud574\uc57c \ud569\ub2c8\ub2e4.\n<ul>\n<li>\uacb0\ud569\ud560 <strong>\ud14c\uc774\ube14<\/strong>;<\/li>\n<li><strong>\uacb0\ud569 \uc720\ud615<\/strong> \ub0b4\ubd80, \uc88c \ub610\ub294 \uc6b0 \uc678\ubd80;<\/li>\n<li><strong>\uacb0\ud569 \uc5f4<\/strong> &#8211; \ub4dc\ub86d\ub2e4\uc6b4 \ubaa9\ub85d\uc5d0\uc11c \uc120\ud0dd\ud558\uace0<\/li>\n<li>\uc5f0\uc0b0\uc790 =. !=, &gt; \ub610\ub294 &lt; \ub97c \uc0ac\uc6a9\ud558\uc5ec <strong>\uacb0\ud569 \ubc94\uc704<\/strong>\ub97c \uc9c0\uc815\ud569\ub2c8\ub2e4.<\/li>\n<li>\uc5ec\ub7ec \uac1c\uc758 \uacb0\ud569 \uaddc\uce59\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4. \ucd5c\ub300 4\uac1c\uc758 \uacb0\ud569 \uaddc\uce59\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<p><a ref=\"magnificPopup\" href=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125755\/data_views_mult.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-28030\" src=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125755\/data_views_mult.png\" alt=\"\" width=\"684\" height=\"899\" srcset=\"https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125755\/data_views_mult.png 684w, https:\/\/kore-wordpress.s3.us-east-2.amazonaws.com\/developer.kore.ai\/v10-1\/wp-content\/uploads\/sites\/35\/20210624125755\/data_views_mult-228x300.png 228w\" sizes=\"auto, (max-width: 684px) 100vw, 684px\" \/><\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\r\n\t\t<\/div>\r\n\t<\/div>\r\n<div class=\"w-separator size_small with_line width_default thick_1 style_solid color_border align_center\"><div class=\"w-separator-h\"><\/div><\/div><\/div><\/div><\/div><div class=\"vc_col-sm-12 wpb_column vc_column_container\"><div class=\"vc_column-inner\"><div class=\"wpb_wrapper\"><\/div><\/div><\/div><\/div><\/div><\/section>\n","protected":false},"excerpt":{"rendered":"\ud14c\uc774\ube14 \ubdf0\ub780 \ud558\ub098 \uc774\uc0c1\uc758 \ub370\uc774\ud130 \ud14c\uc774\ube14\uc744 \uacb0\ud569\ud558\uc5ec \uc0ac\uc6a9\uc790 \uc815\uc758 \ub370\uc774\ud130 \uc138\ud2b8\ub97c \uc0dd\uc131\ud560 \uc218 \uc788\uac8c \ud574\uc90d\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uc815\uc758\ub294 \ucffc\ub9ac\ub85c \ubcc0\ud658\ub418\uc5b4 \ud544\uc694\ud55c \uc870\uc778\uc744 \uc0ac\uc6a9\ud568\uc73c\ub85c\uc368 \ud558\ub098 \uc774\uc0c1\uc758 \ud14c\uc774\ube14\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uac00\uc838\uc635\ub2c8\ub2e4. \uc815\uc758 \ubdf0 \uc815\uc758\ub294 \ud3ec\ud568\ud569\ub2c8\ub2e4: \ubdf0\uc5d0 \ub300\ud55c \uc774\ub984\uc785\ub2c8\ub2e4. \ubdf0 \uc124\uba85 \ubdf0\uc5d0 \uc561\uc138\uc2a4\ud558\uae30 \uc704\ud55c \ubd07 \ubc0f \uc571 \ud560\ub2f9 \ubdf0\ub294 \ub2e8\uc77c \ud14c\uc774\ube14 \ub610\ub294 \ub2e4\uc911 \ud14c\uc774\ube14\uc5d0\uc11c \uad6c\ucd95\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub450 \uc720\ud615 \ubaa8\ub450,...","protected":false},"author":22,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-41128","post","type-post","status-publish","format-standard","hentry","category-advanced-topics"],"_links":{"self":[{"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/posts\/41128","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/users\/22"}],"replies":[{"embeddable":true,"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/comments?post=41128"}],"version-history":[{"count":1,"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/posts\/41128\/revisions"}],"predecessor-version":[{"id":41129,"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/posts\/41128\/revisions\/41129"}],"wp:attachment":[{"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/media?parent=41128"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/categories?post=41128"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/developer.kore.ai\/v10-1\/wp-json\/wp\/v2\/tags?post=41128"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}