{"id":649,"date":"2015-01-15T10:01:08","date_gmt":"2015-01-15T08:01:08","guid":{"rendered":"http:\/\/www.ozgurguler.net\/?p=649"},"modified":"2015-10-16T17:40:12","modified_gmt":"2015-10-16T14:40:12","slug":"rapor-ve-formlarda-kullanilan-fonksiyonlar","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/rapor-ve-formlarda-kullanilan-fonksiyonlar\/","title":{"rendered":"RAPOR VE FORMLARDA KULLANILAN FONKS\u0130YONLAR"},"content":{"rendered":"

RAPOR VE FORMLARDA KULLANILAN FONKS\u0130YONLAR<\/p>\n

 <\/p>\n

FONKS\u0130YON L\u0130STES\u0130<\/p>\n\n\n\n\n\n\n\n\n\n\n
MIN(number, number)<\/td>\nDAYS(firstdate, lastdate)<\/td>\nCREATE(date, base curr., base rate, dest. curr)<\/p>\n

 <\/td>\n

SQR(number)<\/td>\nDATESTR(date, format)<\/td>\nSUBSTR(text, start, length)<\/p>\n

 <\/td>\n<\/tr>\n

MAX(number, number)<\/td>\nDAYOF(date)<\/td>\nSTRPOS<\/p>\n

(search string, string)<\/td>\n

SQRT(number)<\/td>\nMONTHSTR(month)<\/td>\nUPCASE(text)<\/td>\n<\/tr>\n
MOD(number, divisor)<\/td>\nMONTHOF(date)<\/p>\n

 <\/td>\n

FLOOR(number)<\/td>\nCOS(number)<\/td>\nWDAYSTR(weekday)<\/td>\nLOWCASE(text)<\/td>\n<\/tr>\n
DIV(number, divisor)<\/td>\nYEAROF(date)<\/p>\n

 <\/td>\n

CEIL(number)<\/td>\nSIN(number)<\/td>\nNUMSTR(number, decimals, format)<\/td>\nTRIMSPC(text, option)<\/td>\n<\/tr>\n
ABS(number)<\/td>\nWDAYOF(date)<\/td>\nFRAC(number)<\/p>\n

 <\/td>\n

TAN(number)<\/td>\nTIMESTR(time, format)<\/td>\nJUSTIFY(text, direction, fill, length)<\/td>\n<\/tr>\n
VAL(text)<\/td>\nROUND(number)<\/td>\nEXP(number)<\/td>\nSTRLEN(text)<\/td>\nRESXSTR(list resource, tag)<\/td>\nWRNUM(language, numer, part)<\/td>\n<\/tr>\n
DATE<\/p>\n

(day, month, year)<\/p>\n

 <\/td>\n

TRUNC(number)<\/td>\nLN(number)<\/td>\nWEEKNUM(year start, first week, date)<\/td>\nRESSTR(string resource)<\/p>\n

 <\/td>\n

IF(expression, value1, value2)<\/p>\n

 <\/td>\n<\/tr>\n

AFTER(days, year)<\/td>\nERATE<\/p>\n

(date, currency)<\/td>\n

POWER<\/p>\n

(base, exponent)<\/p>\n

 <\/td>\n

STR(number)<\/td>\nCRESSTR(list id., tag)<\/p>\n

 <\/td>\n

<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

<\/p>\n

\u00d6RNEK FONKS\u0130YONLARIN KULLANIMI<\/p>\n

MIN(number, number)<\/p>\n

Fonsiyonun i\u00e7erindeki say\u0131lardan k\u00fc\u00e7\u00fck olan\u0131 verir.<\/p>\n

Program kullan\u0131m :\u00a0\u00a0\u00a0\u00a0\u00a0 MIN(5, 6)=5<\/p>\n

S\u011fl Kullan\u0131m : SELECT MIN(DATE_) FROM LG_035_01_STLINE<\/p>\n

\u00d6rnek:\u00a0 \u0130lk son eklenen faturan\u0131n tarihi<\/p>\n

SELECT MIN(DATE_) FROM LG_035_01_INVOICE WHERE GRPCODE=2 AND CLIENTREF=4778<\/p>\n

—————————————————————————————–<\/p>\n

MAX(number, number)<\/p>\n

Fonsiyonun i\u00e7erindeki say\u0131lardan b\u00fcy\u00fck olan\u0131 verir.<\/p>\n

Program kullan\u0131m :\u00a0\u00a0\u00a0\u00a0\u00a0 MAX(5, 6)\u00a0\u00a0\u00a0\u00a0 =\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 6<\/p>\n

S\u011fl Kullan\u0131m : SELECT MIN(DATE_) FROM LG_035_01_STLINE<\/p>\n

\u00d6rnek: En son eklenen faturan\u0131n tarihi<\/p>\n

SELECT max(DATE_) FROM LG_035_01_INVOICE WHERE GRPCODE=2 AND CLIENTREF=4778<\/p>\n

—————————————————————————————–<\/p>\n

MOD(number, divisor)<\/p>\n

Bir say\u0131n\u0131n di\u011fer bir say\u0131ya b\u00f6l\u00fcnd\u00fc\u011f\u00fcnde kalan\u0131 verir.<\/p>\n

Program kullan\u0131m :\u00a0\u00a0\u00a0\u00a0\u00a0 MOD(37, 6)\u00a0\u00a0 =1\u00a0\u00a0 \/\u00a0\u00a0 MOD(42, 7)=0<\/p>\n

Sql Kullan\u0131m : Select 10 % 3<\/p>\n

—————————————————————————————–<\/p>\n

DIV(number, divisor)<\/p>\n

Bir say\u0131n\u0131n di\u011fer bir say\u0131ya b\u00f6l\u00fcnd\u00fc\u011f\u00fcnde b\u00f6l\u00fcm\u00fc verir.<\/p>\n

Program kullan\u0131m :\u00a0\u00a0\u00a0\u00a0\u00a0 DIV(35,6)=5\u00a0\u00a0 \/ DIV(42, 7)=6<\/p>\n

Sql Kullan\u0131m : Select 10 \/ 3<\/p>\n

—————————————————————————————–<\/p>\n

ABS(number)<\/p>\n

Bir say\u0131n\u0131n mutlak de\u011ferini al\u0131r.<\/p>\n

Program kullan\u0131m : ABS(7) =7\u00a0 \/ ABS(-7)=7<\/p>\n

Sql Kullan\u0131m : select ABS(-23)<\/p>\n

—————————————————————————————–<\/p>\n

VAL(text)<\/p>\n

Metin olarak yaz\u0131lm\u0131\u015f bir say\u0131y\u0131 say\u0131 format\u0131na \u00e7evirir.<\/p>\n

Program kullan\u0131m :VAL(\u201c1000\u201d)=1000<\/p>\n

Sql Kullan\u0131m : SELECT CAST(100 AS INT)<\/p>\n

SELECT CONVERT(INT, 100)<\/p>\n

VAL(STR(100))<\/p>\n

—————————————————————————————–<\/p>\n

STRLEN(text)<\/p>\n

Se\u00e7ilen metnin ka\u00e7 karakterden olu\u015ftu\u011fu bilgisini verir. T\u00fcr\u00fc say\u0131d\u0131r.<\/p>\n

Program kullan\u0131m :\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 STRLEN(\u201cabcdefg\u201d) =7\u00a0\u00a0 \/ STRLEN(\u201c999\u201d)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 =\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3<\/p>\n

Sql Kullan\u0131m :\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SELECT LEN(NAME) FROM LG_035_ITEMS<\/p>\n

—————————————————————————————–<\/p>\n

SUBSTR(text, start, length)<\/p>\n

Se\u00e7ilen metin alan\u0131 istenilen karakterden ba\u015flayarak istenilen uzunlukta yazmak i\u00e7in kullan\u0131l\u0131r.<\/p>\n

Program kullan\u0131m :SUBSTR(\u201cabcdef\u201d,2,3)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 =bcd\u00a0 \/ SUBSTR(\u201cabcdef\u201d,1,4)=abcd<\/p>\n

Sql Kullan\u0131m : SELECT SUBSTRING(NAME,9,LEN(NAME)) FROM LG_035_ITEMS<\/p>\n

—————————————————————————————–<\/p>\n

STR(text)<\/p>\n

Say\u0131 olarak tan\u0131mlanm\u0131\u015f alan\u0131 metin format\u0131nda yazar.<\/p>\n

Program kullan\u0131m :\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 STR(1234)=1234<\/p>\n

Sql Kullan\u0131m : \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SELECT STR(12345)<\/p>\n

SELECT STR(12345)+’ABC’<\/p>\n

—————————————————————————————–<\/p>\n

DATESTR(date, format)<\/p>\n

Verilen tarihi metne \u00e7evirerek istenen formatta yazar.<\/p>\n

Program kullan\u0131m :\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DATESTR(DATE(23,12,2013),1)=12.23.2013\u00a0\u00a0 \/\u00a0 DATESTR(DATE(23,12,2013),2)=\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 23.12.2013<\/p>\n

Sql Kullan\u0131m : \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SELECT CONVERT(VARCHAR(10), DATE_, 111) AS [YYYY\/MM\/DD] FROM LG_035_01_INVOICE<\/p>\n

SELECT CONVERT(VARCHAR(10), DATE_, 112) AS [YYYYMMDD] FROM LG_035_01_INVOICE<\/p>\n

SELECT REPLACE(CONVERT(VARCHAR(10), DATE_, 111),’\/’,’_’) AS [YYYY MM DD]\u00a0 FROM LG_035_01_INVOICE<\/p>\n

SELECT UPPER(REPLACE(CONVERT(VARCHAR,DATE_,6),’ ‘,’-‘)) AS [DD MM YY] FROM LG_035_01_INVOICE<\/p>\n

SELECT CONVERT(VARCHAR(10), DATE_, 110) AS [YYYY\/MM\/DD] FROM LG_035_01_INVOICE<\/p>\n

—————————————————————————————–<\/p>\n

DATE(day, month, year)<\/p>\n

G\u00fcn, ay ve y\u0131l bilgisine g\u00f6re tarih format\u0131na \u00e7evirir.<\/p>\n

Program kullan\u0131m :DATE(31, 12, 2013)=31.12.2013<\/p>\n

Sql Kullan\u0131m :\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SELECT convert(datetime, ’10\/23\/2016’, 101) — ay\/gun\/y\u0131ll<\/p>\n

SELECT convert(datetime, ‘2016.10.23’, 102) — y\u0131ll.ay.gun<\/p>\n

SELECT convert(datetime, ’23\/10\/2016′, 103) — gun\/ay\/y\u0131ll<\/p>\n

SELECT convert(datetime, ‘23.10.2016’, 104) — gun.ay.y\u0131ll<\/p>\n

SELECT convert(datetime, ’23-10-2016′, 105) — gun-ay-y\u0131ll<\/p>\n

SELECT convert(datetime, ’23 OCT 2016′, 106) — gun mon y\u0131ll<\/p>\n

SELECT convert(datetime, ‘Oct 23, 2016’, 107) — mon gun, y\u0131ll<\/p>\n

 <\/p>\n

SELECT<\/p>\n

CAST(CONVERT(datetime,DATE_) as bigint) AS DATETOINT1,<\/p>\n

CONVERT(bigint,CONVERT(datetime,DATE_))\u00a0 AS DATETOINT2,<\/p>\n

CAST(CONVERT(datetime,DATE_) as bigint) AS DATETOINT3<\/p>\n

FROM LG_035_01_STLINE<\/p>\n

 <\/p>\n

—————————————————————————————–<\/p>\n

AFTER(days, date)<\/p>\n

Bir tarihten verilen g\u00fcn say\u0131s\u0131 kadar sonraki tarihi verir.<\/p>\n

Program kullan\u0131m : AFTER(10, DATE(10,02,2001))=20.02.2001<\/p>\n

AFTER(10, [G\u00fcn\u00fcn tarihi])=15.02.2001 (G\u00fcn\u00fcn tarihi 05.02.2001 ise)<\/p>\n

AFTER(-25,[G\u00fcn\u00fcn Tarihi])<\/p>\n

Sql Kullan\u0131m : select (DATE_-10),(DATE_+10) from LG_035_01_INVOICE<\/p>\n

—————————————————————————————–<\/p>\n

DAYS(firstdate, lastdate)<\/p>\n

\u0130ki tarih aras\u0131ndaki g\u00fcn say\u0131s\u0131n\u0131 verir.<\/p>\n

Program kullan\u0131m : DAYS(DATE(13,10,2013), DATE(21,10,2013))=8\u00a0\u00a0 \/ DAYS([G\u00fcn\u00fcn Tarihi],[AFTER KULLANIMI])<\/p>\n

Sql Kullan\u0131m : \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 select DateDiff(mm,DATE_,CAPIBLOCK_CREADEDDATE) from LG_035_01_INVOICE<\/p>\n

select DateDiff(hh,DATE_,CAPIBLOCK_CREADEDDATE) from LG_035_01_INVOICE<\/p>\n

select DateDiff(DAYOFYEAR,DATE_,CAPIBLOCK_CREADEDDATE) from LG_035_01_INVOICE<\/p>\n

select DateDiff(YYYY,DATE_,CAPIBLOCK_CREADEDDATE) from LG_035_01_INVOICE<\/p>\n

\u00f6rnek: Faturan\u0131n olu\u015fturulma tarihi ile fatura tarihi farkl\u0131 olanlar<\/p>\n

select * from LG_035_01_INVOICE WHERE DateDiff(mm,DATE_,CAPIBLOCK_CREADEDDATE)>0<\/p>\n

—————————————————————————————–<\/p>\n

DAYOF(date)<\/p>\n

Verilen tarihin g\u00fcn\u00fcn\u00fc verir.<\/p>\n

Program kullan\u0131m :\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DAYOF(DATE(10,12,2000))=10\u00a0\u00a0 \/ DAYOF([G\u00fcn\u00fcn Tarihi])=14<\/p>\n

Sql Kullan\u0131m : \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SELECT DAY(DATE_) FROM LG_035_01_INVOICE<\/p>\n

—————————————————————————————–<\/p>\n

MONTHOF(date)<\/p>\n

Verilen tarihin ay\u0131n\u0131 verir.<\/p>\n

Program kullan\u0131m :\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 MONTHOF(DATE(10,12,2000))=12\u00a0\u00a0\u00a0 \/ MONTHOF([G\u00fcn\u00fcn Tarihi])=6<\/strong><\/p>\n

Sql Kullan\u0131m : \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SELECT MONTH(DATE_) FROM LG_035_01_INVOICE<\/p>\n

\u00d6rnek: Ocak ay\u0131 toplam sat\u0131\u015f fatura adedi<\/p>\n

SELECT COUNT(LOGICALREF) FROM LG_035_01_INVOICE WHERE\u00a0 MONTH(DATE_)=1 AND GRPCODE=2<\/p>\n

—————————————————————————————–<\/p>\n

YEAROF(date)<\/p>\n

Verilen tarihin y\u0131l\u0131n\u0131 verir.<\/p>\n

Program kullan\u0131m :\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 YEAROF (DATE(10,12,2000))=2000\u00a0 \/ YEAROF([G\u00fcn\u00fcn Tarihi])=2013<\/strong><\/p>\n

Sql Kullan\u0131m : \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SELECT YEAR(DATE_) FROM LG_035_01_INVOICE<\/p>\n

—————————————————————————————–<\/p>\n

WDAYOF(date)<\/p>\n

Verilen tarihin haftan\u0131n ka\u00e7\u0131nc\u0131 g\u00fcn\u00fc oldu\u011funu verir.<\/p>\n

Program kullan\u0131m :\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 WDAYOF (DATE(30,03,2001))\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 =5<\/p>\n

Sql Kullan\u0131m :\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SELECT DATEPART (DW, DATE_),DATE_ FROM LG_035_01_INVOICE\u00a0 —Haftan\u0131n ka\u00e7\u0131nc\u0131 g\u00fcn\u00fc<\/p>\n

SELECT DATEPART (wk, DATE_),DATE_ FROM LG_035_01_INVOICE\u00a0 —Haftay\u0131 almak i\u00e7in<\/p>\n

SELECT DATEPART (dy, DATE_),DATE_ FROM LG_035_01_INVOICE\u00a0 —Y\u0131l\u0131n ka\u00e7\u0131nc\u0131 g\u00fcn\u00fc<\/p>\n

SELECT DATEPART (qq, DATE_),DATE_ FROM LG_035_01_INVOICE\u00a0 —Y\u0131l\u0131n ka\u00e7\u0131nc\u0131 \u00e7eyre\u011fi<\/p>\n

SELECT DATEPART (hh, DATE_),DATE_ FROM LG_035_01_INVOICE\u00a0 —Saat bilgisini almak i\u00e7in<\/p>\n

SELECT DATEPART (mi, DATE_),DATE_ FROM LG_035_01_INVOICE\u00a0 —Dakika bilgisini almak i\u00e7in<\/p>\n

SELECT DATEPART (ss, DATE_),DATE_ FROM LG_035_01_INVOICE\u00a0 —Saniye bilgisini almak i\u00e7in<\/p>\n

SELECT DATEPART (ms, DATE_),DATE_ FROM LG_035_01_INVOICE\u00a0 —Milisaniye bilgisini almak i\u00e7in<\/p>\n

—————————————————————————————–<\/p>\n

ROUND(number)<\/p>\n

Verilen say\u0131y\u0131 en yak\u0131n tamsay\u0131ya \u00e7evirir.<\/p>\n

Program kullan\u0131m :\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ROUND(5.25)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 =5\/\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ROUND(5.61)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 =6<\/p>\n

Sql Kullan\u0131m :\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SELECT ROUND(DEBIT,2) FROM LG_035_01_EMFLINE<\/p>\n

—————————————————————————————–<\/p>\n

TRUNC(number)<\/p>\n

Verilen say\u0131n\u0131n ondal\u0131kl\u0131 k\u0131sm\u0131n\u0131 kald\u0131rarak tamsay\u0131ya \u00e7evirir.<\/p>\n

Program kullan\u0131m :\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TRUNC(5.25)=5 \/ TRUNC(26.85)=26<\/p>\n

Sql Kullan\u0131m :\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SELECT FLOOR(NETTOTAL),NETTOTAL FROM LG_035_01_INVOICE<\/p>\n

 <\/p>\n

—————————————————————————————–<\/p>\n

IF(expression, value1, value2)<\/p>\n

Belirtilen ko\u015ful (expression) sa\u011flan\u0131yorsa birinci de\u011feri(value1); sa\u011flanm\u0131yorsa ikinci de\u011feri (value2) getirir. T\u00fcr\u00fc say\u0131d\u0131r.<\/p>\n

IF(2*2=4, \u201c\u0130ki kere iki d\u00f6rt eder\u201d, 1500)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 =\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u0130ki kere iki d\u00f6rt eder<\/p>\n

IF(2*2=100, \u201c\u0130ki kere iki d\u00f6rt eder\u201d, 1500)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 =\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1500<\/p>\n

Sql Kullan\u0131m \u00a01:\u00a0\u00a0 SELECT IIF(ACTIVE=1,’KULLANIMDA’,’KULLANIM DI\u015eI’) AS STATU FROM LG_035_ITEMS<\/p>\n

 <\/p>\n

Sql Kullan\u0131m 2:\u00a0\u00a0 SELECT<\/p>\n

CASE<\/p>\n

WHEN ACTIVE = 1 THEN’Kullan\u0131mda’<\/p>\n

WHEN ACTIVE = 0 THEN’Kullan\u0131m D\u0131\u015f\u0131’<\/p>\n

END’stat\u00fc’<\/p>\n

FROM LG_035_ITEMS<\/p>\n

—————————————————————————————-<\/p>\n

ERATE(date, currency)<\/p>\n

\u0130stenilen d\u00f6viz cinsinin, otomatik kullan\u0131mda olan t\u00fcr\u00fcn\u00fcn, belli tarihteki kurunu getirir.<\/p>\n

Program kullan\u0131m :\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ERATE(DATE(13,06,2013),20)\u00a0 —05.05.2002 tarihine girilen EURO kurunu getirir<\/p>\n

—————————————————————————————–<\/p>\n

CREATE(date, base curr., base rate, dest curr)<\/p>\n

\u0130stenilen d\u00f6vizli tutar\u0131n \u00e7apraz kurla \u00e7evrilen de\u011ferini getirir.<\/p>\n

Program kullan\u0131m :\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CREATE(DATE(13,06,2013),1,1500,20) = 1.453,25<\/p>\n

USD kurun 1,89 TL, EURO kurun da 2,55 TL oldu\u011funu kabul edelim. 1500 EURO\u2019nun bu tarihteki USD kar\u015f\u0131l\u0131\u011f\u0131n\u0131 bulmak i\u00e7in CREATE fonksiyonu yukar\u0131daki \u015fekilde kullan\u0131l\u0131r ve fonksiyon 1.789,68 sonucunu bulur. (Matematiksel form\u00fcl: 1.500*2.55\/1,89)<\/p>\n

—————————————————————————————–<\/p>\n

STRPOS(search string, string)<\/p>\n

Metin i\u00e7ersinde aranacak olan karakterin metnin ka\u00e7\u0131nc\u0131 karakteri oldu\u011fu bilgisini verir.<\/p>\n

Program kullan\u0131m :\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0 STRPOS(\u201cE\u201d,\u201dKALEM\u201d) =\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4<\/p>\n

Sql Kullan\u0131m :\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0SELECT PATINDEX(‘%A%’,NAME),NAME FROM\u00a0 LG_035_ITEMS<\/p>\n

—————————————————————————————–<\/p>\n

FLOOR(number)<\/p>\n

Verilen say\u0131y\u0131 kendisinden k\u00fc\u00e7\u00fck en yak\u0131n tamsay\u0131ya \u00e7evirir.<\/p>\n

Program kullan\u0131m : \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 FLOOR(2,8)=2\u00a0\u00a0 \/ FLOOR(-2,8)=-3<\/p>\n

Sql Kullan\u0131m :\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SELECT FLOOR(NETTOTAL) FROM LG_035_01_INVOICE<\/p>\n

—————————————————————————————–<\/p>\n

CEIL(number)<\/p>\n

Verilen say\u0131n\u0131n ondal\u0131k k\u0131sm\u0131n\u0131 1\u2019e tamamlayarak tamsay\u0131ya \u00e7evirir.<\/p>\n

Program kullan\u0131m : \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CEIL(15.25)=16\u00a0 \/\u00a0 CEIL(15.75)=16<\/p>\n

Sql Kullan\u0131m :\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0SELECT CEILING(NETTOTAL) FROM LG_035_01_INVOICE<\/p>\n

—————————————————————————————–<\/p>\n

FRAC(number)<\/p>\n

Verilen say\u0131dan say\u0131n\u0131n tamsay\u0131 k\u0131sm\u0131n\u0131 \u00e7\u0131kard\u0131ktan sonra kalan say\u0131y\u0131 0 ve +\/-1 den yak\u0131n olan\u0131na \u00e7evirir.<\/p>\n

Program kullan\u0131m : \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0FRAC(3,15)= 0\u00a0 \/ FRAC(-3,15)=0\u00a0\u00a0 \/ FRAC(3,75)\u00a0 = 1\u00a0\u00a0 \/\u00a0 FRAC(-3,75)=\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 -1<\/p>\n

Sql Kullan\u0131m :<\/p>\n

—————————————————————————————–<\/p>\n

EXP(number)<\/p>\n

Do\u011fal logaritma(ln) fonksiyonunun tersidir. Do\u011fal logaritma fonksiyonunun taban\u0131n\u0131n (e) verilen say\u0131 kadar kendisi ile \u00e7arp\u0131m\u0131n\u0131n en yak\u0131n oldu\u011fu tamsay\u0131y\u0131 verir.<\/p>\n

Program kullan\u0131m :\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 EXP(1)=3 (e\u2019nin yakla\u015f\u0131k de\u011feri)\u00a0 \/\u00a0\u00a0 EXP(2)=7<\/p>\n

—————————————————————————————-<\/p>\n

LN(number)<\/p>\n

Do\u011fal logaritma fonksiyonudur. \u201ce\u201d taban\u0131na g\u00f6re logartima fonksiyonunu sonucunu en ayk\u0131n tamsay\u0131ya \u00e7evirir..<\/p>\n

Program kullan\u0131m :\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 LN(2)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 =1\u00a0\u00a0 \/ \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 EXP (LN (5))=5<\/p>\n

—————————————————————————————<\/p>\n

POWER(base, exponent)<\/p>\n

Bir say\u0131n\u0131n belirtilen kuvvetini verir.<\/p>\n

Program kullan\u0131m :\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0POWER(9,2)=81(92<\/sup>)\u00a0\u00a0 \/\u00a0 POWER(2,3)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 =8(23<\/sup>)<\/p>\n

Sql Kullan\u0131m :\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 select POWER(9,2)<\/p>\n

—————————————————————————————–<\/p>\n

SQR(number)<\/p>\n

Bir say\u0131n\u0131n karesini (kendisi ile \u00e7arp\u0131m\u0131n\u0131) verir.<\/p>\n

Program kullan\u0131m :\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SQR(2)=4\u00a0\u00a0\u00a0 \/\u00a0 SQR(7)=49<\/p>\n

Sql Kullan\u0131m :<\/p>\n

—————————————————————————————–<\/p>\n

SQRT(number)<\/p>\n

Bir say\u0131n\u0131n karek\u00f6k\u00fcn\u00fc verir.<\/p>\n

Program kullan\u0131m :\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SQRT(81)=9 \/ SQRT(225)=15<\/p>\n

Sql Kullan\u0131m : \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 select SQRT(49)<\/p>\n

—————————————————————————————–<\/p>\n

COS(number)<\/p>\n

Bir say\u0131n\u0131n (radyan cinsinden verilen a\u00e7\u0131n\u0131n) cosin\u00fcs\u00fcn\u00fc verir.<\/p>\n

COS(0)\u00a0\u00a0 =\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<\/p>\n

—————————————————————————————–<\/p>\n

SIN(number)<\/p>\n

Bir say\u0131n\u0131n (radyan cinsinden verilen a\u00e7\u0131n\u0131n) sin\u00fcs\u00fcn\u00fc verir.<\/p>\n

—————————————————————————————–<\/p>\n

TAN(number)<\/p>\n

Bir say\u0131n\u0131n (radyan cinsinden verilen a\u00e7\u0131n\u0131n) tanjant\u0131n\u0131 verir.<\/p>\n

—————————————————————————————–<\/p>\n

WEEKNUM(year start, first week, date)<\/p>\n

\u0130lgili tarihin y\u0131l\u0131n ka\u00e7\u0131nc\u0131 haftas\u0131 oldu\u011funa dair bilgi getirir. First week parametresi MS Outlook\u2019ta oldu\u011fu gibi \u00e7al\u0131\u015f\u0131r.<\/p>\n

1: Y\u0131l\u0131n ilk haftas\u0131 Ocak 1 ile ba\u015flar<\/p>\n

2: \u0130lk 4 g\u00fcnl\u00fck hafta y\u0131l\u0131n ilk haftas\u0131d\u0131r (Ocak 1 Cuma ise y\u0131l\u0131n ilk haftas\u0131 ay\u0131n 4\u2019\u00fc ile basl\u0131yor)<\/p>\n

3: \u0130lk tam hafta y\u0131l\u0131n ilk haftas\u0131d\u0131r.<\/p>\n

WEEKNUM (DATE(01,01,2002),1, Teslim tarihi)<\/p>\n

—————————————————————————————–<\/p>\n

MONTHSTR(month)<\/p>\n

Verilen say\u0131ya kar\u015f\u0131l\u0131k gelen ay\u0131 metin olarak yazar.<\/p>\n

MONTHSTR(2)=\u015eubat\u00a0\u00a0 \/\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 MONTHSTR(12)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 =Aral\u0131k<\/p>\n

—————————————————————————————–<\/p>\n

 <\/p>\n

WDAYSTR(weekday)<\/p>\n

Verilen say\u0131ya kar\u015f\u0131l\u0131k gelen g\u00fcn\u00fc metin olarak yazar.<\/p>\n

WDAYSTR(3)=\u00c7ar\u015famba\u00a0\u00a0 \/\u00a0\u00a0 WDAYSTR(5)=Cuma<\/p>\n

—————————————————————————————–<\/p>\n

NUMSTR(number, decimals, format)<\/p>\n

Verilen say\u0131y\u0131 metne \u00e7evirerek istenen formatta yazar.<\/p>\n

NUMSTR(1234,3,1)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 =\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1234<\/p>\n

NUMSTR(1234,3,6)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 =\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1234,000 %<\/p>\n

NUMSTR(1234,2,7)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1.234,00<\/p>\n

NUMSTR(-1234,1,1)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 =\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1.234,0 (A)<\/p>\n

—————————————————————————————–<\/p>\n

TIMESTR(time, format)<\/p>\n

Verilen saat bilgisini metne \u00e7evirerek istenen formatta yazar.<\/p>\n

—————————————————————————————–<\/p>\n

RESXSTR(list source, tag)<\/p>\n

Resource klas\u00f6r\u00fc alt\u0131nda bulunan LRF uzant\u0131l\u0131 dosyalardaki liste numaras\u0131 (list source) ve bu numaral\u0131 listedeki eleman numaras\u0131na (tag) kar\u015f\u0131l\u0131k gelen metni getirir.<\/p>\n

RESXSTR(25550,1)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 =\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Stok kodu<\/p>\n

RESXSTR(25550,2)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 =\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Stok a\u00e7\u0131klamas\u0131<\/p>\n

—————————————————————————————–<\/p>\n

RESSTR(string resource)<\/p>\n

Resource klas\u00f6r\u00fc alt\u0131nda bulunan LRF uzant\u0131l\u0131 dosyalardaki metinleri getirir.<\/p>\n

RESSTR(29057)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 =Uygun kay\u0131t bulunamam\u0131\u015ft\u0131r.<\/p>\n

—————————————————————————————–<\/p>\n

CRESSTR(list id., tag)<\/p>\n

—————————————————————————————–<\/p>\n

UPCASE(text)<\/p>\n

Verilen metni b\u00fcy\u00fck harflerle yazar.<\/p>\n

UPCASE(\u201cText\u201d)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 =\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TEXT<\/p>\n

—————————————————————————————–<\/p>\n

LOWCASE(text)<\/p>\n

Verilen metni k\u00fc\u00e7\u00fck harflerle yazar.<\/p>\n

LOWCASE(\u201cText\u201d)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 =\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 text<\/p>\n

—————————————————————————————–<\/p>\n

TRIMSPC(text, option)<\/p>\n

Se\u00e7ilen metnin ba\u015f\u0131ndaki ve\/veya sonundaki bo\u015fluklar\u0131 atar.<\/p>\n

TRIMSPC(\u201c\u00a0\u00a0 ABC\u00a0\u00a0 \u201d,1)\u00a0\u00a0\u00a0\u00a0 =\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ABC<\/p>\n

TRIMSPC(\u201c\u00a0\u00a0 ABC\u00a0\u00a0 \u201d,2)\u00a0\u00a0\u00a0\u00a0 =\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0 ABC<\/p>\n

TRIMSPC(\u201c\u00a0\u00a0 ABC\u00a0\u00a0 \u201d,3)\u00a0\u00a0\u00a0\u00a0 =\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ABC<\/p>\n

—————————————————————————————–<\/p>\n

JUSTIFY(text, direction, fill, length)<\/p>\n

Se\u00e7ilen metni istenilen uzunlukta yazar. Metinde olu\u015fan bo\u015fluklar\u0131 istenen karakterle doldurur.<\/p>\n

JUSTIFY(STR(4),1,\u201c0\u201d,3) =\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 004<\/p>\n

JUSTIFY(\u201cABC\u201d,2,\u201cF\u201d,7)\u00a0\u00a0 =\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 FFABCFF<\/p>\n

—————————————————————————————–<\/p>\n

WRNUM(language, number, part)<\/p>\n

Bir say\u0131n\u0131n tamsay\u0131 ya da ondal\u0131k k\u0131sm\u0131n\u0131n belirtilen dilde yaz\u0131 haline getirir.<\/p>\n

Dillere (language) kar\u015f\u0131l\u0131k gelen say\u0131lar \u00a0Logoset.cfg dosyalar\u0131nda tan\u0131mlanm\u0131\u015ft\u0131r. (1=T\u00fcrk\u00e7e, 2=\u0130ngilizce, 4=Almanca…) Tamsay\u0131 k\u0131sm\u0131n istenen dilde yaz\u0131lmas\u0131 i\u00e7in part\u2019a 1, kuru\u015f hanesinin yaz\u0131lmas\u0131 i\u00e7inse part\u2019a 2 de\u011feri verilir.<\/p>\n

WRNUM(1,100,1)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 =\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Y\u00fcz<\/p>\n

WRNUM(2,1000,1)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 =\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 OneThousand<\/p>\n

WRNUM(1,100.05,2)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 =\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Be\u015f<\/p>\n

WRNUM(4,100.05,1)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 =\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Ein(s)Hundert<\/p>\n

 <\/p>\n

WRNUM(1,[Fatura Net Toplam\u0131],1) = TL Tutar gelir<\/p>\n

WRNUM(1,[Fatura Net Toplam\u0131],2) = TL kuru\u015f hane gelir<\/p>\n

—————————————————————————————-<\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

RAPOR VE FORMLARDA KULLANILAN FONKS\u0130YONLAR   FONKS\u0130YON L\u0130STES\u0130 MIN(number, number) DAYS(firstdate, lastdate) CREATE(date, base curr., base rate, dest. curr)   SQR(number) DATESTR(date, format) SUBSTR(text, start, length)   MAX(number, number) DAYOF(date) STRPOS (search string, string) SQRT(number) MONTHSTR(month) UPCASE(text) MOD(number, divisor) MONTHOF(date)   FLOOR(number) COS(number) WDAYSTR(weekday) LOWCASE(text) DIV(number, divisor) YEAROF(date)   CEIL(number) SIN(number) NUMSTR(number, decimals, format) TRIMSPC(text, […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-649","post","type-post","status-publish","format-standard","hentry","category-logorapor"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/649","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/comments?post=649"}],"version-history":[{"count":1,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/649\/revisions"}],"predecessor-version":[{"id":650,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/649\/revisions\/650"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=649"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=649"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=649"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}