Pega Convert Date MM/dd/yyyy to dd/MM/yyyy
Below Function is used in Pega for converting string date 12/31/2025 to 31/12/2025 FormatDateTime(toDateTime("12/31/2025"),"dd/MM/yyyy","Europe/Amsterdam","en_BE") Result = 31/12/2025
Posts
Validation Using Data Transform Add Message To Clipboard
@pxAddMessageToPage(Param.BGNameNotFound,Primary) Param.BGNotFound!="" Param.BGNameNotFound = "Assessment(s) Missing for " + Param.BGNotFound Param.SetError = @pxAddMessageToPage(Param.BGNameNotFound,Primary) ------------------------------------------------------------------------------------------------------------- !@IsInPageList(Param.BGLR,".pyLabel",ECBLTBGList.pxResults) ECBLTBGList HDFC-HDFCAuto-Work-RD ECBLTBGList.pxResults Code-Pega-List BGList HDFC-HDFCAuto-Work-RD BGList.pxResults Code-Pega-List
Delete Data From Pagelist Using Data Transform
Param.pxListSubscript = .pxListSubscript .pySelected = "true" Param.DeleteSelectedRows = @Utilities.RemoveDeletedObjects(<PageList>) .pySelected=="true" .pyDeletedObject = "true" Param.DeleteSelectedRows = @Utilities.RemoveDeletedObjects(.CountryList)
Remove Line Break & Special Character Using Data Transform
@replaceAll(.DeviationList(<CURRENT>).DeviationJustification,"\n"," ") @pxReplaceAllViaRegex(Param.RemovedLineBreak,"[^a-zA-Z]+"," " ") @replaceAll(.CountryList(<CURRENT>).CountryName,"\n"," ") @pxReplaceAllViaRegex(Param.RemovedLineBreak,"[^a-zA-Z]+"," ")
Create Index Table PEGA SQL QUERY
Imp Note => In table name only underscores are allowed. CREATE TABLE "<SCHEMA_NAME>"."<TABLE_NAME>" ( "PXCOMMITDATETIME TIMESTAMP(6), "PXCREATEDATETIME" TIMESTAMP(6), "PXCREATEOPNAME" VARCHAR2(128 BYTE), "PXCREATEOPERATOR" VARCHAR2(128 BYTE), "PXCREATESYSTEMID" VARCHAR2(128 BYTE), "PXINDEXCOUNT" NUMBER(18,0), "PXINDEXPURPOSE" VARCHAR2(255 BYTE), "PXINSINDEXEDCLASS" VARCHAR2(255 BYTE), "PXINSINDEXEDKEY" VARCHAR2(255 BYTE), "PXINSNAME" VARCHAR2(192 BYTE), "PXOBJCLASS" VARCHAR2(96 BYTE), "PXUPDATEDATETIME" TIMESTAMP(6), "PXUPDATEOPNAME" VARCHAR2(128 BYTE), "PXUPDATEOPERATOR" VARCHAR2(128 BYTE), "PXUPDATESYSTEMID" VARCHAR2(128 BYTE), "PYLABEL" VARCHAR2(255 BYTE), "PZINSKEY" VARCHAR2(255 BYTE) NOT NULL ENABLE, "PXSAVEDATETIME" TIMESTAMP(6) ); COMMIT;
Bank SQL Pega
Oracle SQL Queries Change Table Name ALTER TABLE "<TABALE_NAME>" RENAME TO NEW_TABLE_NAME; COMMIT; Select Query For Index Table SELECT * FROM <TABLE_NAME> where pxinsindexedkey like '%C-105%'; Case Count In Index Table SELECT COUNT(*) FROM INDEX_IN_B_DATA_CONTROL; Drop Column Command ALTER TABLE "<TABLE_NAME>" DROP COLUMN "<COLUMN_NAME>"; COMMIT; Add Column ALTER TABLE <TABLE_NAME> ( "ADDRESSCOUNTRY" VARCHAR2(255 BYTE) ); COMMIT; Modify Column ALTER TABLE <TABLE_NAME> MODIFY (LoanProvider VARCHAR2(255 BYTE)); COMMIT;