{"id":6118,"date":"2023-03-15T15:50:42","date_gmt":"2023-03-15T15:50:42","guid":{"rendered":"https:\/\/bentego.com\/pega-platformunda-declare-index-report-definition-rule-index-tablosu-ve-pzpvstream-kolonu-hakkinda\/"},"modified":"2025-10-20T16:09:21","modified_gmt":"2025-10-20T16:09:21","slug":"pega-platformunda-declare-index-report-definition-rule-index-tablosu-ve-pzpvstream-kolonu-hakkinda","status":"publish","type":"post","link":"https:\/\/bentego.com\/tr\/pega-platformunda-declare-index-report-definition-rule-index-tablosu-ve-pzpvstream-kolonu-hakkinda\/","title":{"rendered":"Pega &#8211; Declare Index, Report Definition Rule, Index Tablosu ve PZPVSTREAM Kolonu"},"content":{"rendered":"<p><strong>Pega Platform\u2019unda Declare Index, Report Definition Rule, Index Tablosu ve PZPVSTREAM Kolonu Hakk\u0131nda<\/strong><\/p>\n<p>Pega platformunda \u00f6rne\u011fin bir Work Class\u2019\u0131 alt\u0131nda yeni bir Property Rule olu\u015fturdu\u011fumuzda Work Class\u2019\u0131n\u0131n ili\u015fkilendirildi\u011fi tabloda veritaban\u0131 seviyesinde yeni bir kolon olu\u015fturma <u>zorunlulu\u011fu<\/u> bulunmuyor.<\/p>\n<p>Pega platformunun pc_work veya pr_other gibi OOTB tablolar\u0131nda PZPVSTREAM ad\u0131nda binary large object tipinde bir kolon bulunuyor. Uygulaman\u0131n ihtiyac\u0131na g\u00f6re yeni case type lar tan\u0131mland\u0131ktan sonra olu\u015fan class lar\u0131n ili\u015fkilendirildi\u011fi tabloda da ayn\u0131 \u015fekilde PZPVSTREAM ad\u0131nda binary large object tipinde bir kolon otomatik olarak olu\u015fuyor.<\/p>\n<p>Uygulama seviyesinde ilgili property\u2019de tutulan bir bilgi spesifik bir kolon mapping\u2019i olmasa bile ilgili Work tablosundan okunabiliyor veya bu tabloya yaz\u0131labiliyor. \u00c7\u00fcnk\u00fc, Pega uygulamas\u0131 veritaban\u0131na bir commit i\u015flemi ger\u00e7ekle\u015ftirdi\u011finde property i serialize i\u015fleminden ge\u00e7irip otomatik olarak PZPVSTREAM kolonuna yaz\u0131yor. Ayn\u0131 \u015fekilde select sorgusu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131nda da PZPVSTREAM i\u00e7erisindeki veriyi Deserialize edip Pega uygulamas\u0131ndaki obje lere d\u00f6n\u00fc\u015ft\u00fcr\u00fcyor. Diyelim yeni a\u00e7t\u0131\u011f\u0131n\u0131z N adet property niz var ve bu N adet property\u2019de tutulan bilgilerin hepsi property tipinden ba\u011f\u0131ms\u0131z tekil veya liste olacak \u015fekilde PZPVSTREAM\u00a0 kolonunda topluca saklanabiliyor. Veritaban\u0131 seviyesinde PZPVSTREAM kolonundan bilgi okuyabilmek i\u00e7in ise a\u015fa\u011f\u0131daki OOTB function kullan\u0131labilir.<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-5089 aligncenter\" src=\"https:\/\/bentego.com\/wp-content\/uploads\/2023\/03\/1-1.png\" alt=\"\" width=\"647\" height=\"295\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Pega platformunun sa\u011flad\u0131\u011f\u0131 bu esneklik uygulama geli\u015ftirme s\u00fcresini k\u0131saltsa da di\u011fer taraftan PZPVSTREAM kolonundan bilgileri okuyabilmek i\u00e7in uygulanan ekstra i\u015flemden dolay\u0131 uygulama performans\u0131na olumsuz etki edebilir. Tek bir Case Instance\u2019\u0131n\u0131 a\u00e7arken (read: obj-open-by-handle) PZPVSTREAM kolonundan bilgileri okuma i\u015fleminin performansa olumsuz etkisi hissedilmesede rapor \u00e7ekme gibi toplu yap\u0131lacak i\u015flemlerde bu olumsuz etki hissedilecektir. Uygulamaya gelecek \u00a0de\u011fi\u015fiklik taleplerinde \u00f6zellikle rapor taleplerinde yava\u015fl\u0131k do\u011frudan hissedilece\u011finden dolay\u0131 Pega platformu Report Definition rule i\u00e7erisinde expose edilmemi\u015f bir property kullan\u0131m\u0131 alg\u0131lad\u0131\u011f\u0131nda Guardrail warnings k\u0131sm\u0131nda size a\u015fa\u011f\u0131daki \u015fekilde uyar\u0131 g\u00f6sterecektir.<\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-5090 aligncenter\" src=\"https:\/\/bentego.com\/wp-content\/uploads\/2023\/03\/mcpost2.jpg\" alt=\"\" width=\"970\" height=\"173\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Report Definition rule \u00e7al\u0131\u015ft\u0131r\u0131ld\u0131\u011f\u0131nda ise yine a\u015fa\u011f\u0131daki \u015fekilde uyar\u0131 g\u00f6sterilecektir.<\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-5091 aligncenter\" src=\"https:\/\/bentego.com\/wp-content\/uploads\/2023\/03\/mcpost3.jpg\" alt=\"\" width=\"1092\" height=\"62\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Bu duruma \u00f6nlem al\u0131nmal\u0131 \u00e7\u00fcnk\u00fc \u00f6rne\u011fin Pending durumlu y\u00fczlerce veya binlerce case\u2019i kullan\u0131c\u0131ya g\u00f6stermek istiyorsunuz ve rapor i\u00e7erisinde expose edilmemi\u015f property ler var. Bu durumda her bir sat\u0131r i\u00e7in PZPVSTREAM kolonundan bilgi okuma i\u015flemi yap\u0131laca\u011f\u0131ndan dolay\u0131 b\u00fcy\u00fck performans sorunlar\u0131 ya\u015fama ihtimali vard\u0131r. Bu durumda hem hatas\u0131z bir rapor \u00e7\u0131kt\u0131s\u0131 elde etmek, hem de major performans sorunlar\u0131 ya\u015fanmamas\u0131 i\u00e7in ilgili property i\u00e7in harici bir kolonun olu\u015fturulmas\u0131 gerekecektir.<\/p>\n<p>Pega platformunda property rule\u2019unun actions k\u0131sm\u0131nda \u201cOptimize for reporting\u201d ad\u0131nda bir \u00f6zellik var. Bu i\u015flem temel olarak ilgili property i\u00e7in ilgili tabloda spesifik bir kolon a\u00e7maya yar\u0131yor yani bu i\u015flem ger\u00e7ekle\u015fti\u011finde platform veritaban\u0131 seviyesinde ilgili tablo veya tablolar i\u00e7in ALTER TABLE .. ADD .. script\u2019ini \u00e7al\u0131\u015ft\u0131r\u0131p tekil bilgi saklayan property i\u00e7in kolonu Work class \u0131n\u0131n ili\u015fkilendirildi\u011fi tabloda olu\u015fturuyor. Alan uzunlu\u011funun de\u011ferini default olarak platforma b\u0131rakmak istemiyorsan\u0131z ilgili property rule unda max length alan\u0131na bilgi ihtiyaca g\u00f6re girilmelidir. \u0130lgili kolon olu\u015ftuktan sonra art\u0131k platform Report Definition rule unun \u00fcretece\u011fi select sorgusunda bu yeni kolondan bilgiyi okuyacak ve Work object ine bir commit i\u015flemi ger\u00e7ekle\u015fti\u011finde PZPVSTREAM\u2019e yazmas\u0131n\u0131n yan\u0131 s\u0131ra bu kolona da art\u0131k bilgiyi yazacakt\u0131r.<\/p>\n<p>Normal \u015fartlar alt\u0131nda Pega platformundan expose i\u015flemi ger\u00e7ekle\u015ftirildi\u011finde veritaban\u0131nda property ismiyle ayn\u0131 \u015fekilde kolon olu\u015fur ve ekstra bir i\u015flem yapmaya gerek kalmaz. Ancak e\u011fer bir sebepten property nin maplendi\u011fi kolon manuel olu\u015fturulduysa ve ismi property isminden tamamen farkl\u0131ysa bu durumda Work Class rule\u2019unun external mapping k\u0131sm\u0131nda property ile ilgili kolonun map lenmesi gerekecektir. Aksi takdirde platform \u00f6rne\u011fin activity rule undaki obj-browse methodu (ilgili property i\u00e7in select value only i\u015faretlense bile) ile veya report definition rule undan bilgiyi PZPVSTREAM alan\u0131ndan okumaya devam edecektir.<\/p>\n<p>Bu noktaya kadar \u00a0text, integer, decimal vb. tipte tekil bilgi tutan property rule lar\u0131 varsayarak a\u00e7\u0131klamalar yapm\u0131\u015ft\u0131k. Pega platformundaki veri yap\u0131lar\u0131nda tekil bilgi saklayan property tiplerinin yan\u0131 s\u0131ra single page ve page list tipinde property lerde var. Temel olarak single page\u2019e i\u00e7erisinde birden fazla property bar\u0131nd\u0131rabilen tek object, page list\u2019e de i\u00e7erisinde birden fazla page bar\u0131nd\u0131ran array\u2019e benzer bir veri yap\u0131s\u0131 diyebiliriz. Peki bu tipteki property leri ilgili Work tablosunun PZPVSTREAM kolonundan harici nas\u0131l okuyaca\u011f\u0131z veya bir di\u011fer deyi\u015fle nerede a\u00e7\u0131\u011fa \u00e7\u0131karaca\u011f\u0131z? Bu konuya \u00e7\u00f6z\u00fcm olarak Index tablosu ve Declare Index adl\u0131 rule u kullanaca\u011f\u0131z. Temel olarak Declare Index kullan\u0131m\u0131 single page veya page list tipindeki property lerdeki bilgileri ana case tablosuyla primary key &#8211; foreign key ili\u015fkisi olacak \u015fekilde farkl\u0131 bir tablo ile ili\u015fkilendirmeye yar\u0131yor diyebiliriz. \u0130lgili case\u2019in work object ine bir commit i\u015flemi ger\u00e7ekle\u015fti\u011finde e\u011fer declare index kullan\u0131l\u0131yorsa \u00f6rne\u011fin page list i\u00e7erisindeki bilgiler farkl\u0131 bir tabloya yaz\u0131lacakt\u0131r. Yaz\u0131n\u0131n devam\u0131nda Order &#8211; Items veri modeli \u00fczerinden pega platformundan declare index kullan\u0131m\u0131na \u00f6rnek verelim.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5092 aligncenter\" src=\"https:\/\/bentego.com\/wp-content\/uploads\/2023\/03\/mcpost4.png\" alt=\"\" width=\"527\" height=\"605\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Declare Index rule u olu\u015fturmadan \u00f6nce ilk etapta a\u015fa\u011f\u0131daki Review Harness\u2019da g\u00f6r\u00fcld\u00fc\u011f\u00fc gibi \u00a0bir Order Case\u2019i olu\u015fturup Pega platformunun Order case\u2019i alt\u0131nda bulunan Items Page List\u2019ini nereye yazd\u0131\u011f\u0131n\u0131 a\u015fa\u011f\u0131da payla\u015f\u0131lan sorgu vas\u0131tas\u0131yla g\u00f6relim.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5093 aligncenter\" src=\"https:\/\/bentego.com\/wp-content\/uploads\/2023\/03\/mcpost5.jpg\" alt=\"\" width=\"1818\" height=\"1137\" \/><\/p>\n<p><strong>QUERY<\/strong><\/p>\n<p><strong>SELECT <\/strong><\/p>\n<p>pyID,<\/p>\n<p>pr_read_from_stream(&#8216;.Items(1).Code&#8217;,pzInsKey,pzpvstream) AS FirstItemCode,<\/p>\n<p>pr_read_from_stream(&#8216;.Items(1).Cost&#8217;,pzInsKey,pzpvstream) AS\u00a0 FirstItemCost,<\/p>\n<p>pr_read_from_stream(&#8216;.Items(1).Quantity&#8217;,pzInsKey,pzpvstream) AS FirstItemQuantity,<\/p>\n<p>pr_read_from_stream(&#8216;.Items(1).Total&#8217;,pzInsKey,pzpvstream) AS FirstItemTotal,<\/p>\n<p>pr_read_from_stream(&#8216;.Items(2).Code&#8217;,pzInsKey,pzpvstream) AS SecondItemCode,<\/p>\n<p>pr_read_from_stream(&#8216;.Items(2).Cost&#8217;,pzInsKey,pzpvstream) AS\u00a0 SecondItemCost,<\/p>\n<p>pr_read_from_stream(&#8216;.Items(2).Quantity&#8217;,pzInsKey,pzpvstream) AS SecondItemQuantity,<\/p>\n<p>pr_read_from_stream(&#8216;.Items(2).Total&#8217;,pzInsKey,pzpvstream) AS SecondItemTotal,<\/p>\n<p>pr_read_from_stream(&#8216;.Items(3).Code&#8217;,pzInsKey,pzpvstream) AS ThirdItemCode,<\/p>\n<p>pr_read_from_stream(&#8216;.Items(3).Cost&#8217;,pzInsKey,pzpvstream) AS\u00a0 ThirdItemCost,<\/p>\n<p>pr_read_from_stream(&#8216;.Items(3).Quantity&#8217;,pzInsKey,pzpvstream) AS ThirdItemQuantity,<\/p>\n<p>pr_read_from_stream(&#8216;.Items(3).Total&#8217;,pzInsKey,pzpvstream) AS ThirdItemTotal,<\/p>\n<p>pr_read_from_stream(&#8216;.Items(4).Code&#8217;,pzInsKey,pzpvstream) AS FourthItemCode,<\/p>\n<p>pr_read_from_stream(&#8216;.Items(4).Cost&#8217;,pzInsKey,pzpvstream) AS\u00a0 FourthItemCost,<\/p>\n<p>pr_read_from_stream(&#8216;.Items(4).Quantity&#8217;,pzInsKey,pzpvstream) AS FourthItemQuantity,<\/p>\n<p>pr_read_from_stream(&#8216;.Items(4).Total&#8217;,pzInsKey,pzpvstream) AS FourthItemTotal,<\/p>\n<p>pr_read_from_stream(&#8216;.Total&#8217;,pzInsKey,pzpvstream) AS TotalCost<\/p>\n<p><strong>FROM<\/strong><\/p>\n<p>pc_work_dms<\/p>\n<p><strong>WHERE<\/strong><\/p>\n<p>pzInsKey = &#8216;DMORG-DMSAMPLE-WORK ORDER-36&#8217;<\/p>\n<p><strong>QUERY RESULT<\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"139\"><strong>pyID<\/strong><\/td>\n<td width=\"109\">Order-36<\/td>\n<\/tr>\n<tr>\n<td width=\"139\"><strong>FirstItemCode<\/strong><\/td>\n<td width=\"109\">82H8034TTX<\/td>\n<\/tr>\n<tr>\n<td width=\"139\"><strong>FirstItemCost<\/strong><\/td>\n<td width=\"109\">9.999<\/td>\n<\/tr>\n<tr>\n<td width=\"139\"><strong>FirstItemQuantity<\/strong><\/td>\n<td width=\"109\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"139\"><strong>FirstItemTotal<\/strong><\/td>\n<td width=\"109\">9.999<\/td>\n<\/tr>\n<tr>\n<td width=\"139\"><strong>SecondItemCode<\/strong><\/td>\n<td width=\"109\">BX8069510940X<\/td>\n<\/tr>\n<tr>\n<td width=\"139\"><strong>SecondItemCost<\/strong><\/td>\n<td width=\"109\">22.906<\/td>\n<\/tr>\n<tr>\n<td width=\"139\"><strong>SecondItemQuantity<\/strong><\/td>\n<td width=\"109\">3<\/td>\n<\/tr>\n<tr>\n<td width=\"139\"><strong>SecondItemCost<\/strong><\/td>\n<td width=\"109\">68.718<\/td>\n<\/tr>\n<tr>\n<td width=\"139\"><strong>ThirdItemCode<\/strong><\/td>\n<td width=\"109\">MHDC3TU\/A<\/td>\n<\/tr>\n<tr>\n<td width=\"139\"><strong>ThirdItemCost<\/strong><\/td>\n<td width=\"109\">15.999<\/td>\n<\/tr>\n<tr>\n<td width=\"139\"><strong>ThirdItemQuantity<\/strong><\/td>\n<td width=\"109\">2<\/td>\n<\/tr>\n<tr>\n<td width=\"139\"><strong>ThirdItemTotal<\/strong><\/td>\n<td width=\"109\">31.998<\/td>\n<\/tr>\n<tr>\n<td width=\"139\"><strong>FourthItemCode<\/strong><\/td>\n<td width=\"109\">PS719407775<\/td>\n<\/tr>\n<tr>\n<td width=\"139\"><strong>FourthItemCost<\/strong><\/td>\n<td width=\"109\">8.999<\/td>\n<\/tr>\n<tr>\n<td width=\"139\"><strong>FourthItemQuantity<\/strong><\/td>\n<td width=\"109\">1<\/td>\n<\/tr>\n<tr>\n<td width=\"139\"><strong>FourthItemTotal<\/strong><\/td>\n<td width=\"109\">8.999<\/td>\n<\/tr>\n<tr>\n<td width=\"139\"><strong>TotalCost<\/strong><\/td>\n<td width=\"109\">119.714<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p>G\u00f6r\u00fcld\u00fc\u011f\u00fc \u00fczere Items PageList\u2019inin her bir eleman\u0131 Work class\u2019\u0131n\u0131n ili\u015fkilendirildi\u011fi tablonun PZPVSTREAM kolonuna yukar\u0131daki gibi yaz\u0131lm\u0131\u015f.\u00a0 Yukar\u0131daki sorguyla tek tek her bir eleman\u0131n i\u00e7erisindeki bilgiler sorgu sonucunda getirildi. Ancak bu kullan\u0131m mevcut yap\u0131n\u0131n nas\u0131l i\u015fledi\u011fini bir \u00f6rnekle g\u00f6stermek i\u00e7indi. Rapor\u2019da sipari\u015f ve bu sipari\u015fin kalemlerini dinamik olarak g\u00f6stermemiz gerekecektir ve bunu ger\u00e7ekle\u015ftirebilmemiz i\u00e7in Items Page List\u2019inin farkl\u0131 bir tabloda a\u00e7\u0131k olarak tutulmas\u0131 gerekecektir. Bunun i\u00e7in \u00f6nce Index-Items isminde Index- Abstract Class\u2019\u0131ndan t\u00fcretilen bir Concrete Class olu\u015fturaca\u011f\u0131z ve ard\u0131ndan Declare Index Rule vas\u0131tas\u0131yla Pega platformunun Items bilgisini Index-Items Class\u2019\u0131n\u0131n ili\u015fkilendirildi\u011fi tabloya yazmas\u0131n\u0131 sa\u011flayaca\u011f\u0131z.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5094 aligncenter\" src=\"https:\/\/bentego.com\/wp-content\/uploads\/2023\/03\/mcpost6.png\" alt=\"\" width=\"1220\" height=\"992\" \/><\/p>\n<p>Keys k\u0131sm\u0131nda belirtilen pxInsIndexedKey alan\u0131na Work tablosundaki pzInsKey de\u011feri yaz\u0131lacakt\u0131r yani bu alan i\u00e7in foreign key bilgisini tutuyor diyebiliriz. pxIndexCount alan\u0131 index say\u0131s\u0131n\u0131 ve pxIndexPurpose da Declare Index rule un ismini tutuyor diyebiliriz.<\/p>\n<p>Pega platformu pr_Index_Items tablosunu olu\u015fturdu\u011funda sadece OOTB kolonlar\u0131 olu\u015fturacakt\u0131r. Bundan dolay\u0131 Items Page List Class\u2019\u0131nda bulunan ve a\u00e7\u0131\u011fa \u00e7\u0131kartmak istedi\u011fimiz t\u00fcm property ler de Index-Items Class\u2019\u0131 alt\u0131nda olu\u015fturulmal\u0131 ve property rule i\u00e7erisinde bulunan actions tu\u015fu alt\u0131nda bulunan \u201cOptimize for reporting\u201d fonksiyonu kullan\u0131larak a\u00e7\u0131\u011fa \u00e7\u0131kart\u0131lmal\u0131d\u0131r (tabloda yeni bir kolon olu\u015fturulmas\u0131). Bu arada Pega platformu concrete bir work class\u2019\u0131 veya data class \u0131 olu\u015fturdu\u011funda bu class lar\u0131n ili\u015fkilendirildi\u011fi tabloda PZPVSTREAM kolonunu olu\u015ftururken Index tablolar\u0131 i\u00e7in bu kolonun kullan\u0131m\u0131na gerek olmayaca\u011f\u0131ndan olu\u015fturmayacakt\u0131r.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5095 aligncenter\" src=\"https:\/\/bentego.com\/wp-content\/uploads\/2023\/03\/mcpost7.png\" alt=\"\" width=\"546\" height=\"418\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5096 aligncenter\" src=\"https:\/\/bentego.com\/wp-content\/uploads\/2023\/03\/mcpost8.png\" alt=\"\" width=\"441\" height=\"952\" \/><\/p>\n<p>Son olarak a\u015fa\u011f\u0131daki gibi Declare Index Rule\u2019u olu\u015fturup ard\u0131ndan yeni bir Order case\u2019i \u00fcretelim ve Items Page List\u2019indeki verilerin yaz\u0131ld\u0131\u011f\u0131 Index tablosunu kontrol edelim. Daha sonras\u0131nda Report Definition rule\u2019u \u00e7al\u0131\u015ft\u0131rarak ilgili Order ve Item lar\u0131n\u0131 getiren raporu Pega platformu \u00fczerinde \u00fcretelim.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5097 aligncenter\" src=\"https:\/\/bentego.com\/wp-content\/uploads\/2023\/03\/mcpost9.png\" alt=\"\" width=\"1645\" height=\"1108\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5098 aligncenter\" src=\"https:\/\/bentego.com\/wp-content\/uploads\/2023\/03\/mcpost10.png\" alt=\"\" width=\"1637\" height=\"1065\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5099 aligncenter\" src=\"https:\/\/bentego.com\/wp-content\/uploads\/2023\/03\/mcpost11.png\" alt=\"\" width=\"1681\" height=\"802\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5100 aligncenter\" src=\"https:\/\/bentego.com\/wp-content\/uploads\/2023\/03\/mcpost12.png\" alt=\"\" width=\"1646\" height=\"1067\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5101 aligncenter\" src=\"https:\/\/bentego.com\/wp-content\/uploads\/2023\/03\/mcpost13.png\" alt=\"\" width=\"1432\" height=\"990\" \/><\/p>\n<p>Order Work Class\u2019\u0131 alt\u0131na bir Report Definition Rule olu\u015ftural\u0131m. Report Definition Rule alt\u0131nda bir ba\u015fka tabloyla Join leyebilmek i\u00e7in Class Joins, Declarative Index Joins, Associations veya Sub Reports \u00f6zellikleri kullan\u0131labilir. Index tablosuyla Join lemek i\u00e7in gereksiz efor harcamamak i\u00e7in do\u011frudan Declarative Index Joins \u00f6zelli\u011fini kullanmak yerinde olacakt\u0131r. Di\u011fer taraftan Item\u2019\u0131n ismini Item bilgilerinin tutuldu\u011fu Master tablodan getirebilmek i\u00e7in Class Join kullanmam\u0131z uygun olur.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5102 aligncenter\" src=\"https:\/\/bentego.com\/wp-content\/uploads\/2023\/03\/mcpost14.png\" alt=\"\" width=\"1856\" height=\"1122\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5104 aligncenter\" src=\"https:\/\/bentego.com\/wp-content\/uploads\/2023\/03\/mcpost15.png\" alt=\"\" width=\"1817\" height=\"1108\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5105 aligncenter\" src=\"https:\/\/bentego.com\/wp-content\/uploads\/2023\/03\/mcpost16.png\" alt=\"\" width=\"1843\" height=\"545\" \/><\/p>\n<p><strong>Rapor \u00e7\u0131kt\u0131s\u0131<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5106 aligncenter\" src=\"https:\/\/bentego.com\/wp-content\/uploads\/2023\/03\/mcpost17.png\" alt=\"\" width=\"2125\" height=\"992\" \/><\/p>\n<p>Vakit ay\u0131rd\u0131\u011f\u0131n\u0131z i\u00e7in te\u015fekk\u00fcr ederim.<\/p>\n<p><a href=\"https:\/\/www.linkedin.com\/in\/mertcaldag\">Mert \u00c7alda\u011f<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pega Platform\u2019unda Declare Index, Report Definition Rule, Index Tablosu ve PZPVSTREAM Kolonu Hakk\u0131nda Pega platformunda \u00f6rne\u011fin bir Work Class\u2019\u0131 alt\u0131nda yeni bir [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":5926,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[87],"tags":[123,124,125,126,127],"class_list":["post-6118","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-declare-index-rule-tr","tag-index-table-tr","tag-pega-platform-tr","tag-pzpvstream-column-tr","tag-report-definition-rule-tr"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Pega - Declare Index, Report Definition Rule, Index Tablosu ve PZPVSTREAM Kolonu - Bentego<\/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:\/\/bentego.com\/tr\/pega-platformunda-declare-index-report-definition-rule-index-tablosu-ve-pzpvstream-kolonu-hakkinda\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pega - Declare Index, Report Definition Rule, Index Tablosu ve PZPVSTREAM Kolonu - Bentego\" \/>\n<meta property=\"og:description\" content=\"Pega Platform\u2019unda Declare Index, Report Definition Rule, Index Tablosu ve PZPVSTREAM Kolonu Hakk\u0131nda Pega platformunda \u00f6rne\u011fin bir Work Class\u2019\u0131 alt\u0131nda yeni bir [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/bentego.com\/tr\/pega-platformunda-declare-index-report-definition-rule-index-tablosu-ve-pzpvstream-kolonu-hakkinda\/\" \/>\n<meta property=\"og:site_name\" content=\"Bentego\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-15T15:50:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-20T16:09:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/bentego.com\/wp-content\/uploads\/2025\/06\/Frame-86__.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2400\" \/>\n\t<meta property=\"og:image:height\" content=\"1600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Bentego\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bentego\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/bentego.com\/tr\/pega-platformunda-declare-index-report-definition-rule-index-tablosu-ve-pzpvstream-kolonu-hakkinda\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/bentego.com\/tr\/pega-platformunda-declare-index-report-definition-rule-index-tablosu-ve-pzpvstream-kolonu-hakkinda\/\"},\"author\":{\"name\":\"Bentego\",\"@id\":\"https:\/\/bentego.com\/tr\/#\/schema\/person\/0348418b7b0cbca83fdd7a899d54821e\"},\"headline\":\"Pega &#8211; Declare Index, Report Definition Rule, Index Tablosu ve PZPVSTREAM Kolonu\",\"datePublished\":\"2023-03-15T15:50:42+00:00\",\"dateModified\":\"2025-10-20T16:09:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/bentego.com\/tr\/pega-platformunda-declare-index-report-definition-rule-index-tablosu-ve-pzpvstream-kolonu-hakkinda\/\"},\"wordCount\":1632,\"publisher\":{\"@id\":\"https:\/\/bentego.com\/tr\/#organization\"},\"image\":{\"@id\":\"https:\/\/bentego.com\/tr\/pega-platformunda-declare-index-report-definition-rule-index-tablosu-ve-pzpvstream-kolonu-hakkinda\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/bentego.com\/wp-content\/uploads\/2025\/06\/Frame-86__.png\",\"keywords\":[\"Declare Index Rule\",\"Index Table\",\"Pega Platform\",\"PZPVSTREAM Column\",\"Report Definition Rule\"],\"articleSection\":[\"Blog\"],\"inLanguage\":\"tr\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/bentego.com\/tr\/pega-platformunda-declare-index-report-definition-rule-index-tablosu-ve-pzpvstream-kolonu-hakkinda\/\",\"url\":\"https:\/\/bentego.com\/tr\/pega-platformunda-declare-index-report-definition-rule-index-tablosu-ve-pzpvstream-kolonu-hakkinda\/\",\"name\":\"Pega - Declare Index, Report Definition Rule, Index Tablosu ve PZPVSTREAM Kolonu - Bentego\",\"isPartOf\":{\"@id\":\"https:\/\/bentego.com\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/bentego.com\/tr\/pega-platformunda-declare-index-report-definition-rule-index-tablosu-ve-pzpvstream-kolonu-hakkinda\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/bentego.com\/tr\/pega-platformunda-declare-index-report-definition-rule-index-tablosu-ve-pzpvstream-kolonu-hakkinda\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/bentego.com\/wp-content\/uploads\/2025\/06\/Frame-86__.png\",\"datePublished\":\"2023-03-15T15:50:42+00:00\",\"dateModified\":\"2025-10-20T16:09:21+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/bentego.com\/tr\/pega-platformunda-declare-index-report-definition-rule-index-tablosu-ve-pzpvstream-kolonu-hakkinda\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/bentego.com\/tr\/pega-platformunda-declare-index-report-definition-rule-index-tablosu-ve-pzpvstream-kolonu-hakkinda\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/bentego.com\/tr\/pega-platformunda-declare-index-report-definition-rule-index-tablosu-ve-pzpvstream-kolonu-hakkinda\/#primaryimage\",\"url\":\"https:\/\/bentego.com\/wp-content\/uploads\/2025\/06\/Frame-86__.png\",\"contentUrl\":\"https:\/\/bentego.com\/wp-content\/uploads\/2025\/06\/Frame-86__.png\",\"width\":2400,\"height\":1600},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/bentego.com\/tr\/pega-platformunda-declare-index-report-definition-rule-index-tablosu-ve-pzpvstream-kolonu-hakkinda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/bentego.com\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pega &#8211; Declare Index, Report Definition Rule, Index Tablosu ve PZPVSTREAM Kolonu\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/bentego.com\/tr\/#website\",\"url\":\"https:\/\/bentego.com\/tr\/\",\"name\":\"Bentego\",\"description\":\"Turning data into enterprise value\",\"publisher\":{\"@id\":\"https:\/\/bentego.com\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/bentego.com\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/bentego.com\/tr\/#organization\",\"name\":\"Bentego\",\"url\":\"https:\/\/bentego.com\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/bentego.com\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/bentego.com\/wp-content\/uploads\/2025\/05\/logo-bentego.svg\",\"contentUrl\":\"https:\/\/bentego.com\/wp-content\/uploads\/2025\/05\/logo-bentego.svg\",\"width\":433,\"height\":109,\"caption\":\"Bentego\"},\"image\":{\"@id\":\"https:\/\/bentego.com\/tr\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/bentego.com\/tr\/#\/schema\/person\/0348418b7b0cbca83fdd7a899d54821e\",\"name\":\"Bentego\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Pega - Declare Index, Report Definition Rule, Index Tablosu ve PZPVSTREAM Kolonu - Bentego","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:\/\/bentego.com\/tr\/pega-platformunda-declare-index-report-definition-rule-index-tablosu-ve-pzpvstream-kolonu-hakkinda\/","og_locale":"tr_TR","og_type":"article","og_title":"Pega - Declare Index, Report Definition Rule, Index Tablosu ve PZPVSTREAM Kolonu - Bentego","og_description":"Pega Platform\u2019unda Declare Index, Report Definition Rule, Index Tablosu ve PZPVSTREAM Kolonu Hakk\u0131nda Pega platformunda \u00f6rne\u011fin bir Work Class\u2019\u0131 alt\u0131nda yeni bir [&hellip;]","og_url":"https:\/\/bentego.com\/tr\/pega-platformunda-declare-index-report-definition-rule-index-tablosu-ve-pzpvstream-kolonu-hakkinda\/","og_site_name":"Bentego","article_published_time":"2023-03-15T15:50:42+00:00","article_modified_time":"2025-10-20T16:09:21+00:00","og_image":[{"width":2400,"height":1600,"url":"https:\/\/bentego.com\/wp-content\/uploads\/2025\/06\/Frame-86__.png","type":"image\/png"}],"author":"Bentego","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Bentego","Tahmini okuma s\u00fcresi":"9 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/bentego.com\/tr\/pega-platformunda-declare-index-report-definition-rule-index-tablosu-ve-pzpvstream-kolonu-hakkinda\/#article","isPartOf":{"@id":"https:\/\/bentego.com\/tr\/pega-platformunda-declare-index-report-definition-rule-index-tablosu-ve-pzpvstream-kolonu-hakkinda\/"},"author":{"name":"Bentego","@id":"https:\/\/bentego.com\/tr\/#\/schema\/person\/0348418b7b0cbca83fdd7a899d54821e"},"headline":"Pega &#8211; Declare Index, Report Definition Rule, Index Tablosu ve PZPVSTREAM Kolonu","datePublished":"2023-03-15T15:50:42+00:00","dateModified":"2025-10-20T16:09:21+00:00","mainEntityOfPage":{"@id":"https:\/\/bentego.com\/tr\/pega-platformunda-declare-index-report-definition-rule-index-tablosu-ve-pzpvstream-kolonu-hakkinda\/"},"wordCount":1632,"publisher":{"@id":"https:\/\/bentego.com\/tr\/#organization"},"image":{"@id":"https:\/\/bentego.com\/tr\/pega-platformunda-declare-index-report-definition-rule-index-tablosu-ve-pzpvstream-kolonu-hakkinda\/#primaryimage"},"thumbnailUrl":"https:\/\/bentego.com\/wp-content\/uploads\/2025\/06\/Frame-86__.png","keywords":["Declare Index Rule","Index Table","Pega Platform","PZPVSTREAM Column","Report Definition Rule"],"articleSection":["Blog"],"inLanguage":"tr"},{"@type":"WebPage","@id":"https:\/\/bentego.com\/tr\/pega-platformunda-declare-index-report-definition-rule-index-tablosu-ve-pzpvstream-kolonu-hakkinda\/","url":"https:\/\/bentego.com\/tr\/pega-platformunda-declare-index-report-definition-rule-index-tablosu-ve-pzpvstream-kolonu-hakkinda\/","name":"Pega - Declare Index, Report Definition Rule, Index Tablosu ve PZPVSTREAM Kolonu - Bentego","isPartOf":{"@id":"https:\/\/bentego.com\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/bentego.com\/tr\/pega-platformunda-declare-index-report-definition-rule-index-tablosu-ve-pzpvstream-kolonu-hakkinda\/#primaryimage"},"image":{"@id":"https:\/\/bentego.com\/tr\/pega-platformunda-declare-index-report-definition-rule-index-tablosu-ve-pzpvstream-kolonu-hakkinda\/#primaryimage"},"thumbnailUrl":"https:\/\/bentego.com\/wp-content\/uploads\/2025\/06\/Frame-86__.png","datePublished":"2023-03-15T15:50:42+00:00","dateModified":"2025-10-20T16:09:21+00:00","breadcrumb":{"@id":"https:\/\/bentego.com\/tr\/pega-platformunda-declare-index-report-definition-rule-index-tablosu-ve-pzpvstream-kolonu-hakkinda\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/bentego.com\/tr\/pega-platformunda-declare-index-report-definition-rule-index-tablosu-ve-pzpvstream-kolonu-hakkinda\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/bentego.com\/tr\/pega-platformunda-declare-index-report-definition-rule-index-tablosu-ve-pzpvstream-kolonu-hakkinda\/#primaryimage","url":"https:\/\/bentego.com\/wp-content\/uploads\/2025\/06\/Frame-86__.png","contentUrl":"https:\/\/bentego.com\/wp-content\/uploads\/2025\/06\/Frame-86__.png","width":2400,"height":1600},{"@type":"BreadcrumbList","@id":"https:\/\/bentego.com\/tr\/pega-platformunda-declare-index-report-definition-rule-index-tablosu-ve-pzpvstream-kolonu-hakkinda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/bentego.com\/tr\/"},{"@type":"ListItem","position":2,"name":"Pega &#8211; Declare Index, Report Definition Rule, Index Tablosu ve PZPVSTREAM Kolonu"}]},{"@type":"WebSite","@id":"https:\/\/bentego.com\/tr\/#website","url":"https:\/\/bentego.com\/tr\/","name":"Bentego","description":"Turning data into enterprise value","publisher":{"@id":"https:\/\/bentego.com\/tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/bentego.com\/tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/bentego.com\/tr\/#organization","name":"Bentego","url":"https:\/\/bentego.com\/tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/bentego.com\/tr\/#\/schema\/logo\/image\/","url":"https:\/\/bentego.com\/wp-content\/uploads\/2025\/05\/logo-bentego.svg","contentUrl":"https:\/\/bentego.com\/wp-content\/uploads\/2025\/05\/logo-bentego.svg","width":433,"height":109,"caption":"Bentego"},"image":{"@id":"https:\/\/bentego.com\/tr\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/bentego.com\/tr\/#\/schema\/person\/0348418b7b0cbca83fdd7a899d54821e","name":"Bentego"}]}},"_links":{"self":[{"href":"https:\/\/bentego.com\/tr\/wp-json\/wp\/v2\/posts\/6118","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bentego.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bentego.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bentego.com\/tr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bentego.com\/tr\/wp-json\/wp\/v2\/comments?post=6118"}],"version-history":[{"count":1,"href":"https:\/\/bentego.com\/tr\/wp-json\/wp\/v2\/posts\/6118\/revisions"}],"predecessor-version":[{"id":6242,"href":"https:\/\/bentego.com\/tr\/wp-json\/wp\/v2\/posts\/6118\/revisions\/6242"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bentego.com\/tr\/wp-json\/wp\/v2\/media\/5926"}],"wp:attachment":[{"href":"https:\/\/bentego.com\/tr\/wp-json\/wp\/v2\/media?parent=6118"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bentego.com\/tr\/wp-json\/wp\/v2\/categories?post=6118"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bentego.com\/tr\/wp-json\/wp\/v2\/tags?post=6118"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}