Launching other applications from people code is one of commonly asked questions in peoplesoft forums. Here is method call a Crystal Report or SQR from peoplecode. The CreateProcessRequest function allows you to create a ProcessRequest object. Once you’ve created your object, you can assign values to its properties and use the Schedule method to submit […]
We can use Send Mail function provided by peoplesoft to send HTML based email to user. The Send Mail function sends a message using standard mail options, including recipient, CC, BCC, subject, and the text of the note. Below is the syntax of the send mail function Below is code that show sample usage the […]
Charts and graphs are a great way of representing your data. It is easy to draw them so that your data can quickly understood in a graphical format. Following section lists a step by step procedure on how you can leverage the chart object provided in PeopleSoft to enrich your dull web pages with colorful […]
In this article, we will see step by step procedure to attach a file and store it in the database. The article also shows how to view and delete the uploaded file. Assume that you have item table (PS_QNN_ITEM) with ITEM_ID as a key and basic item information such as Item Name, Description etc . […]
Views are a useful feature of SQL databases, letting us create virtual tables based on SQL select statements.
PeopleSoft 8 provides the functionality to create dynamic views. These are essentially SQL statements executed on the fly by the PeopleSoft component processor. We can use dynamic views in Peoplesoft pages only because they are Peopletools objects, not SQL Objects.
Using Dynamic as Prompt Table
In this article, we will see the use of Dynamic view as prompt table. Please note that dynamic view can be used for other purposes such as search records which will not discussed in the article.
One major question that pops up to many of us the first time we use dynamic view, why not use a normal view instead of dynamic view. A dynamic view’s select statement may include Peoplesoft’s meta-SQL, and it may be replaced by a different SQL statement while the user is using the page. And also there might be situations where which you do not save the view in the database.