{"id":218,"date":"2013-03-09T16:37:20","date_gmt":"2013-03-09T14:37:20","guid":{"rendered":"http:\/\/wintrscada.com\/?p=218"},"modified":"2021-12-18T13:30:53","modified_gmt":"2021-12-18T11:30:53","slug":"rapor-saatlik-veri","status":"publish","type":"post","link":"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/rapor-saatlik-veri\/","title":{"rendered":"Rapor Saat&#8217;lik Veri"},"content":{"rendered":"<p>WinTr <a title=\"scada\" href=\"http:\/\/www.fultek.com.tr\/programlar\/scada\/\">scada<\/a> historical taglar\u0131 <a title=\"kontrol\" href=\"http:\/\/www.fultek.com.tr\/\">kontrol<\/a> panelinde belirtilen periyotda kaydeder. Scada rapor mod\u00fcl\u00fc ile bu verilerden olu\u015fan raporlar yapabilirsiniz. Bu raporlar\u0131 pdf veya excel olarak kaydedebilirsiniz. Kay\u0131t periyotu k\u0131sa oldu\u011funda raporda \u00e7ok fazla sat\u0131r olabilir. Bilgisayar\u0131n b\u00f6yle bir raporu olu\u015fturmas\u0131 uzun s\u00fcrebilir. B\u00fcy\u00fck raporlar al\u0131nmas\u0131 gereken durumlarda ayn\u0131 bilgisayar i\u00e7ersinde iki farkl\u0131 scada projesi \u00e7al\u0131\u015ft\u0131r\u0131labilir. Ana scada projesinin haricinde yaln\u0131zca rapor i\u00e7in ayr\u0131 bir scada projesi daha haz\u0131rlayabiliriz. B\u00f6ylece uzun s\u00fcrecek rapor i\u015fleminde ana scada projemiz normal \u00e7al\u0131\u015fmas\u0131na devam edecektir.<\/p>\n<p>Di\u011fer bir yol ise y\u00fczde parametresi ile olu\u015fturulan rapordaki veri say\u0131s\u0131n\u0131 azaltmakt\u0131r. WinTr scada rapor mod\u00fcl\u00fcnde olu\u015fturulan sorgunun sonuna \u201c% 50 = 0\u2033 bu \u015fekilde y\u00fczde parametresini girebilirsiniz. 50 yerine bir tag\u2019da yazabilirsiniz \u201c% \u2018Tag_1\u2032 = 0\u2033<\/p>\n<p>Bu yaz\u0131da as\u0131l anlatmak istedi\u011fim ise saat ba\u015f\u0131 verilerinin getirilmesidir. Bu model ile ba\u015flang\u0131\u00e7 ve biti\u015f tarihleri aras\u0131nda her saat i\u00e7in bir veri getirilebilir. Ayn\u0131 \u015fekilde her dakika,ay,y\u0131l i\u00e7inde benzer bir sorgu olu\u015fturabilirsiniz. A\u015fa\u011f\u0131daki sorguyu scada rapor mod\u00fcl\u00fcnde \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131n\u0131zda belirtilen tarih aral\u0131\u011f\u0131ndaki her saatin ilk verisini getirir. Min yerine Max etiketini kullanarak her saatin en son de\u011ferini getirir. Ortalamas\u0131 i\u00e7in AVG etiketi gibi daha bir \u00e7ok matematiksel i\u015flemler yapt\u0131rabilirsiniz.<\/p>\n<p>SELECT<\/p>\n<p>a.[DateTime],a.[Shift1LineABillets],a.[Shift1LineBBillets],a.[Shift2LineABil<\/p>\n<p>lets],a.[Shift2LineBBillets],a.[Shift3LineABillets],a.[Shift3LineBBillets]<\/p>\n<p>FROM Table1 As a<\/p>\n<p>INNER JOIN (SELECT DateAdd(hh, DateDiff(hh, 0, DateTime), 0) As the_hour ,<\/p>\n<p>Min(DateTime) As latest_record FROM Table1<\/p>\n<p>WHERE [DateTime] &gt;= \u20194\/18\/2012 10:19:28\u00a0 AM\u2019 And [DateTime] &lt;\u00a0 \u20194\/18\/2012 10:19:28\u00a0 PM\u2019<\/p>\n<p>GROUP BY DateAdd(hh,DateDiff(hh, 0, DateTime), 0) )As b<\/p>\n<p>ON a.DateTime = b.latest_record<\/p>\n<p>Ba\u015flang\u0131\u00e7 biti\u015f zamanlar\u0131n\u0131 tag de\u011ferinden almak i\u00e7in Where sat\u0131r\u0131 a\u015fa\u011f\u0131daki gibi olmal\u0131d\u0131r.<\/p>\n<p>WHERE [DateTime] &gt;= \u2018ReportStartDate\u2019 And [DateTime] &lt; \u2018ReportEndDate\u2019<\/p>\n","protected":false},"excerpt":{"rendered":"<p>WinTr scada historical taglar\u0131 kontrol panelinde belirtilen periyotda kaydeder. Scada rapor mod\u00fcl\u00fc ile bu verilerden olu\u015fan raporlar yapabilirsiniz. Bu raporlar\u0131 pdf veya excel olarak kaydedebilirsiniz. Kay\u0131t periyotu k\u0131sa oldu\u011funda raporda \u00e7ok fazla sat\u0131r olabilir. Bilgisayar\u0131n b\u00f6yle bir raporu olu\u015fturmas\u0131 uzun s\u00fcrebilir. B\u00fcy\u00fck raporlar al\u0131nmas\u0131 gereken durumlarda ayn\u0131 bilgisayar i\u00e7ersinde iki farkl\u0131 scada projesi \u00e7al\u0131\u015ft\u0131r\u0131labilir. Ana [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28],"tags":[135],"class_list":["post-218","post","type-post","status-publish","format-standard","hentry","category-scada-report","tag-her-saatlik-veri"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Rapor Saat&#039;lik Veri - SCADA E\u011fitim Sitesi<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/rapor-saatlik-veri\/\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Salih\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2013\\\/03\\\/rapor-saatlik-veri\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2013\\\/03\\\/rapor-saatlik-veri\\\/\"},\"author\":{\"name\":\"Salih\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/#\\\/schema\\\/person\\\/b439f08807fdc9e273a233976c5eb1be\"},\"headline\":\"Rapor Saat&#8217;lik Veri\",\"datePublished\":\"2013-03-09T14:37:20+00:00\",\"dateModified\":\"2021-12-18T11:30:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2013\\\/03\\\/rapor-saatlik-veri\\\/\"},\"wordCount\":337,\"commentCount\":1,\"keywords\":[\"Her Saatlik Veri\"],\"articleSection\":[\"Rapor\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2013\\\/03\\\/rapor-saatlik-veri\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2013\\\/03\\\/rapor-saatlik-veri\\\/\",\"url\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2013\\\/03\\\/rapor-saatlik-veri\\\/\",\"name\":\"Rapor Saat'lik Veri - SCADA E\u011fitim Sitesi\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/#website\"},\"datePublished\":\"2013-03-09T14:37:20+00:00\",\"dateModified\":\"2021-12-18T11:30:53+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/#\\\/schema\\\/person\\\/b439f08807fdc9e273a233976c5eb1be\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2013\\\/03\\\/rapor-saatlik-veri\\\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2013\\\/03\\\/rapor-saatlik-veri\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2013\\\/03\\\/rapor-saatlik-veri\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Rapor Saat&#8217;lik Veri\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/#website\",\"url\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/\",\"name\":\"SCADA E\u011fitim Sitesi\",\"description\":\"SCADA program\u0131 hakk\u0131nda bilmek istedikleriniz.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/#\\\/schema\\\/person\\\/b439f08807fdc9e273a233976c5eb1be\",\"name\":\"Salih\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/71953beeb6b97dd8eeecb5d9b86339eedb7662215ebdf0761d17ac26bc31f94b?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/71953beeb6b97dd8eeecb5d9b86339eedb7662215ebdf0761d17ac26bc31f94b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/71953beeb6b97dd8eeecb5d9b86339eedb7662215ebdf0761d17ac26bc31f94b?s=96&d=mm&r=g\",\"caption\":\"Salih\"},\"sameAs\":[\"http:\\\/\\\/www.fultek.com.tr\"],\"url\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/author\\\/salih\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Rapor Saat'lik Veri - SCADA E\u011fitim Sitesi","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/rapor-saatlik-veri\/","twitter_misc":{"Yazan:":"Salih","Tahmini okuma s\u00fcresi":"2 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/rapor-saatlik-veri\/#article","isPartOf":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/rapor-saatlik-veri\/"},"author":{"name":"Salih","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/#\/schema\/person\/b439f08807fdc9e273a233976c5eb1be"},"headline":"Rapor Saat&#8217;lik Veri","datePublished":"2013-03-09T14:37:20+00:00","dateModified":"2021-12-18T11:30:53+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/rapor-saatlik-veri\/"},"wordCount":337,"commentCount":1,"keywords":["Her Saatlik Veri"],"articleSection":["Rapor"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/rapor-saatlik-veri\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/rapor-saatlik-veri\/","url":"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/rapor-saatlik-veri\/","name":"Rapor Saat'lik Veri - SCADA E\u011fitim Sitesi","isPartOf":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/#website"},"datePublished":"2013-03-09T14:37:20+00:00","dateModified":"2021-12-18T11:30:53+00:00","author":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/#\/schema\/person\/b439f08807fdc9e273a233976c5eb1be"},"breadcrumb":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/rapor-saatlik-veri\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/rapor-saatlik-veri\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/rapor-saatlik-veri\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fultek.com.tr\/scada-yardim\/"},{"@type":"ListItem","position":2,"name":"Rapor Saat&#8217;lik Veri"}]},{"@type":"WebSite","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/#website","url":"https:\/\/www.fultek.com.tr\/scada-yardim\/","name":"SCADA E\u011fitim Sitesi","description":"SCADA program\u0131 hakk\u0131nda bilmek istedikleriniz.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fultek.com.tr\/scada-yardim\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/#\/schema\/person\/b439f08807fdc9e273a233976c5eb1be","name":"Salih","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/secure.gravatar.com\/avatar\/71953beeb6b97dd8eeecb5d9b86339eedb7662215ebdf0761d17ac26bc31f94b?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/71953beeb6b97dd8eeecb5d9b86339eedb7662215ebdf0761d17ac26bc31f94b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/71953beeb6b97dd8eeecb5d9b86339eedb7662215ebdf0761d17ac26bc31f94b?s=96&d=mm&r=g","caption":"Salih"},"sameAs":["http:\/\/www.fultek.com.tr"],"url":"https:\/\/www.fultek.com.tr\/scada-yardim\/author\/salih\/"}]}},"_links":{"self":[{"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/posts\/218","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/comments?post=218"}],"version-history":[{"count":2,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/posts\/218\/revisions"}],"predecessor-version":[{"id":1064,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/posts\/218\/revisions\/1064"}],"wp:attachment":[{"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/media?parent=218"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/categories?post=218"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/tags?post=218"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}