{"id":1193,"date":"2012-03-12T16:29:40","date_gmt":"2012-03-12T14:29:40","guid":{"rendered":"http:\/\/www.fultek.com.tr\/?p=1193"},"modified":"2021-12-18T13:29:04","modified_gmt":"2021-12-18T11:29:04","slug":"scada-rapor-son-kayitlarin-getirilmesi","status":"publish","type":"post","link":"https:\/\/www.fultek.com.tr\/Deneme\/scada-rapor-son-kayitlarin-getirilmesi\/","title":{"rendered":"Scada Rapor &#8211; Son Kay\u0131tlar\u0131n Getirilmesi"},"content":{"rendered":"<p>WinTr Scada rapor mod\u00fcl\u00fcnde belli say\u0131daki son kay\u0131tlar\u0131n getirilmesi i\u00e7in bu sorguyu kullanabilirsiniz.<\/p>\n<p>SELECT [DateTime],[Kayit_No],[Operator] FROM Table1\u00a0\u00a0 where LastValue &gt; (Select max(LastValue) from Table1) &#8211; &#8216;Tag_istenen_kayit_sayisi&#8217;<\/p>\n<p>Bu sorgu ile son &#8216;Tag_istenen_kayit_sayisi&#8217; tag&#8217;\u0131n da belirtilen say\u0131da ki son kay\u0131tlar getirilir. Getirilen de\u011ferler select komutundan sonra yaz\u0131lm\u0131\u015f \u00fc\u00e7 tag&#8217;\u0131n t\u00fcm de\u011ferleridir.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>WinTr Scada rapor mod\u00fcl\u00fcnde belli say\u0131daki son kay\u0131tlar\u0131n getirilmesi i\u00e7in bu sorguyu kullanabilirsiniz. SELECT [DateTime],[Kayit_No],[Operator] FROM Table1\u00a0\u00a0 where LastValue &gt; (Select max(LastValue) from Table1) &#8211; &#8216;Tag_istenen_kayit_sayisi&#8217; Bu sorgu ile son &#8216;Tag_istenen_kayit_sayisi&#8217; tag&#8217;\u0131n da belirtilen say\u0131da ki son kay\u0131tlar getirilir. Getirilen de\u011ferler select komutundan sonra yaz\u0131lm\u0131\u015f \u00fc\u00e7 tag&#8217;\u0131n t\u00fcm de\u011ferleridir.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[114],"tags":[135,127,136,137],"class_list":["post-1193","post","type-post","status-publish","format-standard","hentry","category-scada","tag-rapor","tag-scada-2","tag-son-kayitlar","tag-sql-sorgu"],"taxonomy_info":{"category":[{"value":114,"label":"Scada Destek"}],"post_tag":[{"value":135,"label":"rapor"},{"value":127,"label":"Scada"},{"value":136,"label":"son kay\u0131tlar"},{"value":137,"label":"sql sorgu"}]},"featured_image_src_large":false,"author_info":{"display_name":"Scada","author_link":"https:\/\/www.fultek.com.tr\/Deneme\/author\/salih\/"},"comment_info":0,"category_info":[{"term_id":114,"name":"Scada Destek","slug":"scada","term_group":0,"term_taxonomy_id":117,"taxonomy":"category","description":"Scada payla\u015f\u0131m blo\u011fu.","parent":1,"count":28,"filter":"raw","cat_ID":114,"category_count":28,"category_description":"Scada payla\u015f\u0131m blo\u011fu.","cat_name":"Scada Destek","category_nicename":"scada","category_parent":1}],"tag_info":[{"term_id":135,"name":"rapor","slug":"rapor","term_group":0,"term_taxonomy_id":138,"taxonomy":"post_tag","description":"","parent":0,"count":3,"filter":"raw"},{"term_id":127,"name":"Scada","slug":"scada-2","term_group":0,"term_taxonomy_id":130,"taxonomy":"post_tag","description":"","parent":0,"count":4,"filter":"raw"},{"term_id":136,"name":"son kay\u0131tlar","slug":"son-kayitlar","term_group":0,"term_taxonomy_id":139,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":137,"name":"sql sorgu","slug":"sql-sorgu","term_group":0,"term_taxonomy_id":140,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"}],"_links":{"self":[{"href":"https:\/\/www.fultek.com.tr\/Deneme\/wp-json\/wp\/v2\/posts\/1193","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fultek.com.tr\/Deneme\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fultek.com.tr\/Deneme\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fultek.com.tr\/Deneme\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fultek.com.tr\/Deneme\/wp-json\/wp\/v2\/comments?post=1193"}],"version-history":[{"count":1,"href":"https:\/\/www.fultek.com.tr\/Deneme\/wp-json\/wp\/v2\/posts\/1193\/revisions"}],"predecessor-version":[{"id":1194,"href":"https:\/\/www.fultek.com.tr\/Deneme\/wp-json\/wp\/v2\/posts\/1193\/revisions\/1194"}],"wp:attachment":[{"href":"https:\/\/www.fultek.com.tr\/Deneme\/wp-json\/wp\/v2\/media?parent=1193"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fultek.com.tr\/Deneme\/wp-json\/wp\/v2\/categories?post=1193"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fultek.com.tr\/Deneme\/wp-json\/wp\/v2\/tags?post=1193"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}