Scrollselect Level 1

You can populate data from record or view to grid or scroll on page peoplesoft by use syntax scrollselect level 1 at below

ScrollFlush(Record.COURSE);
ScrollSelect(1, Scroll.COURSE, Record.COURSE, “Where emplid = :1 and To_Char(DATE,’yyyymmdd’) = :2 “,  %EmployeeId&DATE);

Replace ENTER SQL/Peoplecode

PeopleCode: How to Replace ENTER in Peoplecode for write file in csv for report and other.

&NEW = SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(&COMMENTS_2000, CHAR(13), ” “),CHAR(10),” “),”,”,” “);

SQL: How to Replace ENTER in SQL

REPLACE(REPLACE(REPLACE(TEXT, CHR(10), ”), CHR(13), ”) , CHR(09), ”)

/* Character
CHR(9) — Horizontal tab
CHR(10) — Line feed
CHR(13) — Carriage return.
*/

How to Retrieve Image URL Using Java In PeopleCode ( FieldChange event)

Local JavaObject &joCertString, &joUrl, &joUrlConnection, &joInputStream, &joImageIO, &joBufferedImage, &joFile;
Local JavaObject &joCertificateFactoryClass, &joCertificateFactory, &joCertInputStream, &joCertificate;
Local JavaObject &joKeystoreClass, &joKeystore, &joTrustManagerFactoryClass, &joTrustManagerFactory;
Local JavaObject &joSSLContextClass, &joSSLContext, &joSSLFactory, &joCastObjectClass;
Local any &anyFileData;
Local Record &recTest;
Local string &sPhotosCert;
Local number &nPutResult;

/*Setup CertificateFactory*/
&sPhotosCert = GetHTMLText(HTML.PHOTOS_CERT);
&joCertString = CreateJavaObject(“java.lang.String”, &sPhotosCert);
&joCertificateFactoryClass = GetJavaClass(“java.security.cert.CertificateFactory”);
&joCertificateFactory = &joCertificateFactoryClass.getInstance(“X.509”);
&joCertInputStream = CreateJavaObject(“java.io.ByteArrayInputStream”, &joCertString.getBytes(“UTF-8”));
&joCertificate = &joCertificateFactory.generateCertificate(&joCertInputStream);

/*Create Keystore*/
&joKeystoreClass = GetJavaClass(“java.security.KeyStore”);
&joKeystore = &joKeystoreClass.getInstance(“JKS”);
&joKeystore.load( Null, Null);
&joKeystore.setCertificateEntry(“photos”, &joCertificate);

/*Create TrustManagerFactory*/
&joTrustManagerFactoryClass = GetJavaClass(“javax.net.ssl.TrustManagerFactory”);
&joTrustManagerFactory = &joTrustManagerFactoryClass.getInstance(&joTrustManagerFactoryClass.getDefaultAlgorithm());
&joTrustManagerFactory.init(&joKeystore);

/*Create SSLContext and get SSLSocketFactory*/
&joSSLContextClass = GetJavaClass(“javax.net.ssl.SSLContext”);
&joSSLContext = &joSSLContextClass.getInstance(“TLS”);
&joSSLContext.init( Null, &joTrustManagerFactory.getTrustManagers(), Null);
&joSSLFactory = &joSSLContext.getSocketFactory();

/*Create URL*/
&joUrl = CreateJavaObject(“java.net.URL”, “https://domain.com/handler.ashx?id=123456”);

/*Get URLConnection*/
&joUrlConnection = &joUrl.openConnection();

/*Cast to HttpsURLConnection*/
&joCastObjectClass = GetJavaClass(“com.domain.CastObject”);
&joUrlConnection = &joCastObjectClass.objectToHttpsURLConnection(&joUrlConnection);

/*Set connection properties*/
&joUrlConnection.setSSLSocketFactory(&joSSLFactory);
&joUrlConnection.setRequestMethod(“GET”);

/*Get InputStream*/
&joInputStream = GetJavaClass(“java.io.InputStream”);
&joInputStream = &joUrlConnection.getInputStream();

/*Get Image From Stream*/
&joImageIO = GetJavaClass(“javax.imageio.ImageIO”);
&joBufferedImage = CreateJavaObject(“java.awt.image.BufferedImage”, 1, 1, 1);
&joBufferedImage = &joImageIO.read(&joInputStream);

/*Write Image to File*/
&joFile = CreateJavaObject(“java.io.File”, “/temp/URLImage2.jpg”);
&joImageIO.write(&joBufferedImage, “jpg”, &joFile);

/*Put the File into a PS record so we can get a BLOB of it*/
&nPutResult = PutAttachment(“record://PSFILE_ATTDET”, “013505.jpg”, “/temp/URLImage2.jpg”);

/*Grab that BLOB*/
SQLExec(“SELECT FILE_DATA FROM PSFILE_ATTDET WHERE ATTACHSYSFILENAME = :1 AND VERSION = 1”, “013505.jpg”, &anyFileData);

/*Clean up the temp row we inserted*/
SQLExec(“DELETE FROM PSFILE_ATTDET WHERE ATTACHSYSFILENAME = :1 AND VERSION = 1”, “013505.jpg”);

/*Setup an employee photo record*/
&recTest = CreateRecord(Record.EMPL_PHOTO);
&recTest.EMPLID.Value = “013505”;
&recTest.PSIMAGEVER.Value = (Days365(Date3(1999, 12, 31), %Date) * 86400) + (%Time – Time3(0, 0, 0));
&recTest.EMPLOYEE_PHOTO.Value = &anyFileData;

/*Insert/Update the employee photo record*/
&recTest.Insert();
&recTest.Update();

Credit:http://stackoverflow.com/questions/18921658/retrieve-image-from-ashx-url-using-java-in-peoplesoft-peoplecode

How to Delete Multiple Files Using PeopleCode

How to Delete Multiple Files Using PeopleCode : Deleting files sitting on a server using PeopleCode is one thing I’m sure you will be doing sometime during your PeopleSoft career. The code below should help you out and get you started!

/*The path to the files you need to delete*/
&oldFilesPath = “/my_directory/my_folder”;

/*Notice the “*” at the end of the file name. This means any file that starts with “file_name” will be deleted*/
&oldFiles = “file_name” | “*”;
&PathAndName = &oldFilesPath | &oldFiles;
/*Display file path and name to be deleted */
MessageBox(0, “”, 0, 0, “Delete file: “ | &PathAndName);
&oldFileNames = FindFiles(&PathAndName, %FilePath_Absolute);
/*Loop through files found and delete one by one */
While &oldFileNames.Len > 0/* Delete files one at a time */
&deleteFile = “../../../..” | &oldFileNames.Shift();
/*Display file path and name deleted */
&retcode = DeleteAttachment(URL, &deleteFile);
MessageBox(0, “”, 0, 0, “Deleted file: “ | &deleteFile);
/*Check delete status*/
If (&retcode = %Attachment_Success) Then

MessageBox(0, “File Attachment Status”, 0, 0, “DeleteAttachment succeeded”);
End-If;

If (&retcode = %Attachment_Failed) Then

MessageBox(0, “File Attachment Status”, 0, 0, “DeleteAttachment failed”);

End-If;

If (&retcode = %Attachment_Cancelled) Then

MessageBox(0, “File Attachment Status”, 0, 0, “DeleteAttachment cancelled”);

End-If;

If (&retcode = %Attachment_FileTransferFailed) Then

MessageBox(0, “File Attachment Status”, 0, 0, “DeleteAttachment failed: File Transfer did not succeed”);

End-If;
End-While;

Credit: http://www.compshack.com/peoplesoft/delete-multiple-files-using-peoplecode