Tag Archives: Dynamic View

  • Dynamic View In Peoplesoft

    Posted on May 30, 2012 by in Other Programming, People Soft

    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.

    Post Tagged with , ,