{"id":220,"date":"2013-03-09T16:38:44","date_gmt":"2013-03-09T14:38:44","guid":{"rendered":"http:\/\/wintrscada.com\/?p=220"},"modified":"2021-12-18T13:30:52","modified_gmt":"2021-12-18T11:30:52","slug":"sql-server-rapor-sorgulari","status":"publish","type":"post","link":"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/sql-server-rapor-sorgulari\/","title":{"rendered":"SQL Server Rapor Sorgular\u0131"},"content":{"rendered":"<p>WinTr <a title=\"Scada\" href=\"http:\/\/www.fultek.com.tr\/programlar\/scada\/\">Scada<\/a> ver 4.1.0 ile birlikte Sql server\u2019a kay\u0131t giri\u015fleri farkl\u0131 metodlar ile yap\u0131labiliyor.<\/p>\n<ul>\n<li>Not Historical: Database\u2019e kayd\u0131 yap\u0131lmayan Tag.<\/li>\n<li>Periodically: Tag de\u011feri s\u00fcrekli olarak database\u2019e kaydedilir. Kay\u0131t periyotu <a title=\"kontrol\" href=\"http:\/\/www.fultek.com.tr\/\">kontrol<\/a> panelinde mili saniye olarak se\u00e7ilebilir.<\/li>\n<li>Every Minute: Tag de\u011feri her dakikada bir defa kaydedilir.<\/li>\n<li>Every Hour: Tag de\u011feri her saatde bir defa kaydedilir.<\/li>\n<li>Every Day: Tag de\u011feri her g\u00fcn de bir defa kaydedilir.<\/li>\n<li>Only value changed: Tag de\u011feri her de\u011fi\u015fti\u011finde bir defa kaydedilir.<\/li>\n<li>Triggered: Ba\u015fka bir tag\u0131n de\u011feri her de\u011fi\u015fti\u011finde tipi triggered olarak se\u00e7ilen tag\u0131n de\u011feri kaydedilir.<\/li>\n<\/ul>\n<p>Bu se\u00e7enekler ile database gereksiz yere b\u00fcy\u00fcmeden kay\u0131t i\u015flemlerini ger\u00e7ekle\u015ftirir. Ayr\u0131ca eski versiyonlarda olay bazl\u0131 kay\u0131tlar i\u00e7in script yazmak gerekliydi, Triggered se\u00e7ene\u011fiyle birlikte olay bazl\u0131 kay\u0131t i\u015flemleri yap\u0131labilir. Periodically se\u00e7ene\u011fi haricindeki kay\u0131t y\u00f6ntemlerinden birini kulland\u0131\u011f\u0131n\u0131z taktirde database sat\u0131rlar\u0131nda bo\u015fluklar olu\u015facakt\u0131r. Bunun neticesinde rapor mod\u00fcl\u00fc ile olu\u015fturaca\u011f\u0131n\u0131z raporlarda da ayn\u0131 bo\u015fluklar olu\u015facakt\u0131r. Raporlar\u0131n\u0131zda bu bo\u015fluklar\u0131 g\u00f6rmek istemiyorsn\u0131z veya ba\u015fka ihtiya\u00e7lardan dolay\u0131 farkl\u0131 raporlar olu\u015fturmak istiyorsan\u0131z a\u015fa\u011f\u0131da ki \u00f6rnek rapor sorgular\u0131n\u0131 kullanabilirsiniz.<\/p>\n<p>1. Sorgular\u0131n sonuna Tag_1 is not null se\u00e7ene\u011fi ekleyerek bo\u015fluk olmayan de\u011ferlerin getirilmesiniz sa\u011flayabilirsiniz. Bir den fazla Tag de\u011feri getiren sorgularda \u2018and\u2019 komutu ile di\u011fer tag lar i\u00e7in de is not null se\u00e7eveni\u011fini ekleyebilirsiniz.<\/p>\n<p>SELECT [DateTime],[Tag_1] FROM Table1 Where Tag_1 is not null and Tag_2 is not null<\/p>\n<p>2. Sat\u0131rdaki de\u011fer bo\u015f oldu\u011funda daha \u00f6nceki dolu de\u011feri yerine koyan sorgu:<\/p>\n<p>select T.DateTime, V1.Tag_1, V2.Tag_2 from Table1 T CROSS APPLY (select top (1) Tag_1 from Table1 T1 where T1.Datetime &lt;=T.Datetime and T1.Tag_1 IS NOT NULL order by T1.DateTime DESC) V1 CROSS APPLY (select top (1) Tag_2 from Table1 T2 where T2.Datetime &lt;=T.Datetime and T2.Tag_2 IS NOT NULL order by T2.DateTime DESC) V2<\/p>\n<p>3. \u0130kinci sorgu ile ayn\u0131 \u015fekilde \u00e7al\u0131\u015fabilecek bir di\u011fer sorgu. Bu sorguya ba\u015flang\u0131\u00e7 ve biti\u015f k\u0131s\u0131tlamas\u0131 eklenmi\u015ftir.<\/p>\n<p>Select DateTime, Coalesce(Tag_1, MaxPrevVal1) FROM Table1 M1\u00a0\u00a0\u00a0 Cross Apply (select top(1 )Tag_1 as MaxPrevVal1 From Table1 M2 where M2.DateTime &lt; m1.DateTime and Tag_1 is not null order by DateTime DESC) as CS1\u00a0\u00a0\u00a0\u00a0 where DateTime between \u20194\/28\/2012 2:04:13 PM\u2019 and \u20195\/28\/2012 2:04:15 PM\u2019<\/p>\n<p>4. Alternatif bir sorgu daha.<\/p>\n<p>Select DateTime,Tag_1,Tag_2,Tag_3 from Table1 where DateTime between \u201905.12.2012 11:38:07\u2032 and \u201906.12.2012 11:39:59\u2032 and Tag_1 is not null and Tag_2 is not null and Tag_3 is not null UNION all Select Top 1 DateTime, Coalesce(Tag_1, PrevVal1),Coalesce(Tag_2, PrevVal2),Coalesce(Tag_3, PrevVal3) FROM Table1 M1\u00a0\u00a0 Cross Apply (select top(1) Tag_1 as PrevVal1 From Table1 M2 where M2.DateTime &lt; m1.DateTime and Tag_1 is not null order by DateTime DESC) as CS1\u00a0\u00a0\u00a0 Cross Apply (select top(1) Tag_2 as PrevVal2 From Table1 M2 where M2.DateTime &lt; m1.DateTime and Tag_2 is not null order by DateTime DESC) as CS2\u00a0\u00a0 Cross Apply (select top(1) Tag_3 as PrevVal3 From Table1 M2 where M2.DateTime &lt; m1.DateTime and Tag_3 is not null order by DateTime DESC) as CS3\u00a0\u00a0\u00a0\u00a0 where DateTime between \u201905.12.2012 11:38:07\u2032 and \u201906.12.2012 11:39:59\u2032 UNION all Select DateTime,Tag_1,Tag_2,Tag_3 from Table1 where DateTime between \u201905.12.2012 11:38:07\u2032 and \u201906.12.2012 11:39:59\u2032<\/p>\n<p>5. B\u00fcy\u00fck database\u2019ler den rapor olu\u015fturdu\u011funuzda \u00e7ok fazla data getirilecektir. Bu raporun olu\u015fturulmas\u0131 uzun s\u00fcrece\u011finden rapor k\u0131saltmak i\u00e7in de\u011ferlerin belli kurallar ile ortalamas\u0131n\u0131 almay\u0131 d\u00fc\u015f\u00fcnmelisiniz. A\u015fa\u011f\u0131daki sorgu her 5 de\u011ferin ortalamas\u0131n\u0131 1 de\u011fer olarak getirir.<\/p>\n<p>WITH OrderedRows AS ( SELECT (Row_Number() OVER (ORDER BY LastValue ASC) \u2013 1) \/ 5 As LastValue2 ,DateTime,Tag_1,Tag_2,Tag_3\u00a0 FROM Table1 where DateTime between \u201905.12.2012 11:38:07\u2032 and \u201906.22.2012 11:39:59\u2032) SELECT min(DateTime) as DateTime, Avg(Tag_1) as Tag_1,Avg(Tag_2) as Tag_2,Avg(Tag_3) as Tag_3 FROM\u00a0\u00a0\u00a0 OrderedRows GROUP BY LastValue2 order by LastValue2 ASC<\/p>\n<p>Not: WinTr scada rapor olu\u015fturdu\u011funda sayfada bulunan data gridde \u00e7ok fazla de\u011fer olabilir. Bu de\u011ferler silinmedi\u011fi taktirde rapor sayfas\u0131n\u0131n kapanmas\u0131 ve a\u00e7\u0131lmas\u0131 yava\u015flayabilir. Bu sorunu ortadan kald\u0131rmak i\u00e7in rapor i\u00e7in kulland\u0131\u011f\u0131n\u0131z datagridlerde row tag\u2019\u0131 kullanabilirsiniz. \u00d6rne\u011fin: Tag_1 de\u011fi\u015fkenini row tag\u2019\u0131 olarak datagrid de i\u015faretleyin. Rapor butonunda ilk \u00f6nce Tag_1\u2032e \u20191\u2032 de\u011ferini yaz\u0131n ikinci i\u015flem ise rapor olu\u015fturmak olsun. Sayfadan \u00e7\u0131k\u0131\u015f\u0131 sa\u011flayan(Ba\u015fka bir sayfay\u0131 a\u00e7an) t\u00fcm butonlarda Tag_1\u2032e \u201c0\u2033 de\u011ferini altar\u0131n ve sonraki fonksiyon i\u00e7in a\u00e7mak istedi\u011finiz sayfay\u0131 se\u00e7in. B\u00f6ylece sayfa kapat\u0131lmadan \u00f6nce datagrid temizlenecek ve sayfa tekrar a\u00e7\u0131ld\u0131\u011f\u0131nda h\u0131zl\u0131 olarak a\u00e7\u0131lacakt\u0131r.<\/p>\n<p>Not: \u00c7ok b\u00fcy\u00fck raporlar olu\u015fturulurken scada di\u011fer g\u00f6revlerini aksatabilir. \u00c7\u00f6z\u00fcm olarak ayn\u0131 bilgisayarda iki farkl\u0131 scada program\u0131 \u00e7al\u0131\u015ft\u0131rabilirsiniz. Bir tanesi as\u0131l scada program\u0131m\u0131z di\u011fer ise sadece rapor almak i\u00e7in kullanaca\u011f\u0131m\u0131z di\u011fer scada program\u0131 olabilir. \u00c7ift \u00e7ekirdekli bir bilgisayarda rapor i\u00e7in \u00e7al\u0131\u015fan scada program\u0131n\u0131n cpu kullan\u0131m\u0131 as\u0131l scada program\u0131m\u0131z\u0131 etkilemeyecektir.<\/p>\n<p>Not: \u0130leri seviye kullan\u0131c\u0131 de\u011filseniz veya scada projeniz b\u00fcy\u00fck bir proje de\u011filse database\u2019e kaydedilmesini istedi\u011fimiz tag\u2019lar\u0131 periodically olarak se\u00e7elim. B\u00f6ylece yukar\u0131da yazd\u0131\u011f\u0131m\u0131z komplike sorgular yerine daha basit sorgular ile rapor olu\u015fturabiliriz. Projemiz b\u00fcy\u00fck olmayaca\u011f\u0131ndan dolay\u0131 her hangi bir yava\u015fl\u0131k olmayacakt\u0131r. Periodically se\u00e7ti\u011fimizde kontrol panelinden kay\u0131t periyotunu m\u00fcmk\u00fcn olan en uzun aral\u0131\u011f\u0131 da se\u00e7meyi unutmay\u0131n. WinTr scada milisaniye baz\u0131nda kay\u0131t i\u015flemi yapabilir. Bu i\u015flemler tamamen bilgisayar performans\u0131n\u0131z ile alakal\u0131d\u0131r.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>WinTr Scada ver 4.1.0 ile birlikte Sql server\u2019a kay\u0131t giri\u015fleri farkl\u0131 metodlar ile yap\u0131labiliyor. Not Historical: Database\u2019e kayd\u0131 yap\u0131lmayan Tag. Periodically: Tag de\u011feri s\u00fcrekli olarak database\u2019e kaydedilir. Kay\u0131t periyotu kontrol panelinde mili saniye olarak se\u00e7ilebilir. Every Minute: Tag de\u011feri her dakikada bir defa kaydedilir. Every Hour: Tag de\u011feri her saatde bir defa kaydedilir. Every Day: [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_swpsp_post_exclude":false,"footnotes":""},"categories":[28],"tags":[136],"class_list":["post-220","post","type-post","status-publish","format-standard","hentry","category-scada-report","tag-muhtelif-rapor-sorgulari"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Server Rapor Sorgular\u0131 - 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\/sql-server-rapor-sorgulari\/\" \/>\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=\"5 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\\\/sql-server-rapor-sorgulari\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2013\\\/03\\\/sql-server-rapor-sorgulari\\\/\"},\"author\":{\"name\":\"Salih\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/#\\\/schema\\\/person\\\/b439f08807fdc9e273a233976c5eb1be\"},\"headline\":\"SQL Server Rapor Sorgular\u0131\",\"datePublished\":\"2013-03-09T14:38:44+00:00\",\"dateModified\":\"2021-12-18T11:30:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2013\\\/03\\\/sql-server-rapor-sorgulari\\\/\"},\"wordCount\":983,\"commentCount\":1,\"keywords\":[\"Muhtelif Rapor Sorgular\u0131\"],\"articleSection\":[\"Rapor\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2013\\\/03\\\/sql-server-rapor-sorgulari\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2013\\\/03\\\/sql-server-rapor-sorgulari\\\/\",\"url\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2013\\\/03\\\/sql-server-rapor-sorgulari\\\/\",\"name\":\"SQL Server Rapor Sorgular\u0131 - SCADA E\u011fitim Sitesi\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/#website\"},\"datePublished\":\"2013-03-09T14:38:44+00:00\",\"dateModified\":\"2021-12-18T11:30:52+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\\\/sql-server-rapor-sorgulari\\\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2013\\\/03\\\/sql-server-rapor-sorgulari\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/2013\\\/03\\\/sql-server-rapor-sorgulari\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.fultek.com.tr\\\/scada-yardim\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Rapor Sorgular\u0131\"}]},{\"@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":"SQL Server Rapor Sorgular\u0131 - 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\/sql-server-rapor-sorgulari\/","twitter_misc":{"Yazan:":"Salih","Tahmini okuma s\u00fcresi":"5 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/sql-server-rapor-sorgulari\/#article","isPartOf":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/sql-server-rapor-sorgulari\/"},"author":{"name":"Salih","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/#\/schema\/person\/b439f08807fdc9e273a233976c5eb1be"},"headline":"SQL Server Rapor Sorgular\u0131","datePublished":"2013-03-09T14:38:44+00:00","dateModified":"2021-12-18T11:30:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/sql-server-rapor-sorgulari\/"},"wordCount":983,"commentCount":1,"keywords":["Muhtelif Rapor Sorgular\u0131"],"articleSection":["Rapor"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/sql-server-rapor-sorgulari\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/sql-server-rapor-sorgulari\/","url":"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/sql-server-rapor-sorgulari\/","name":"SQL Server Rapor Sorgular\u0131 - SCADA E\u011fitim Sitesi","isPartOf":{"@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/#website"},"datePublished":"2013-03-09T14:38:44+00:00","dateModified":"2021-12-18T11:30:52+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\/sql-server-rapor-sorgulari\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/sql-server-rapor-sorgulari\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.fultek.com.tr\/scada-yardim\/2013\/03\/sql-server-rapor-sorgulari\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fultek.com.tr\/scada-yardim\/"},{"@type":"ListItem","position":2,"name":"SQL Server Rapor Sorgular\u0131"}]},{"@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\/220","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=220"}],"version-history":[{"count":2,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/posts\/220\/revisions"}],"predecessor-version":[{"id":1063,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/posts\/220\/revisions\/1063"}],"wp:attachment":[{"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/media?parent=220"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/categories?post=220"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fultek.com.tr\/scada-yardim\/wp-json\/wp\/v2\/tags?post=220"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}