PEGADiary: 2022

Monday, 27 June 2022

Get PageList Exported to excel

1. Create a Excel template as following format

A1: Column Name : Case ID

A2: Property Reference as : {ExcelPage.pxResults().CaseID} // inside {}

2. upload it as a Binary file in excel format

“excel” as the App name

File type extention as xlsx

3. Call pxGenerateExcelFile and keep primary page as the PageList which need to be exported

define a file name "Exported.xlsx"

define the template name as "excel!<FILENAME>!xlsx"

4. add the action set in the button as "open URL in Window" and define the activity name

pega.u.d.setProperty("PageName.Property","Value");

<html>

<body>

function SetPropertyValue(){

var v1 = document.GetElementByID("PropertyName").Value;

pega.u.d.setProperty("PageName.PropertyName","v1");

</body>

</html>

Remove Selected pages from PageList :

loop through the page list (PageList name --> PGList),
go to the page which need to be deleted and set pyDeletedObject == True,
call the function --> @Utilities.RemoveDeletedObjects(PGList). (outside the pageList context)

Remove Duplicate from PageList:

page list need to be referenced to Code-Pega-List (PGList.pxResults) ,duplicated property is ".Key"
call @pzRemoveDuplicatesFromListPage(PGList,".Key")

Get subscript from Current page in the pageList

param.pyForEachCount

Set Column type to nvarchar

ALTER TABLE {<DB>.<TableName>} ALTER COLUMN {<Column Name>} nvarchar(256) NULL;