Creating a SQL view/record for PSQuery


Have you every been annoyed by creating a query in PIA, using PSQuery? The easier way to do it is to create a new record, turn that into a view, and then query the record in PSQuery. Instructions are below.

PSQuery – View

Step 1

Open up app designer and create a new record.

Step 2

Insert at least one record field, and hit save. (make sure the number of records match the number of columns in your select statement)

Step 3

Then under record type, select SQL view.

Step 4

Then input your SQL code under the SQL editor section. (make sure not to have a semicolon at the end of your query)

Step 5

Make a primary key. (double click > and select key, search key, and list box item)

Step 6

Then go to build > current definition.

Step 7

Select “Create views” and then select “Execute SQL now”.

Step 8

Then hit Build.

Step 9

Then add the record to the query access manager tree in PIA.

Step 10

Then you can select from the record/view in PSQuery.

Hope that helps!

You may also like:

PS – Move/Copy a Query to a new Database Here are instructions for moving/copying queries back and forth between different PeopleSoft databases. PeopleSoft Database Queries This includes mo...
SQL Developer – Use tnsnames.ora file This is a short tutorial on showing you how to setup SQL developer to use your tnsnames.ora file for new connections. SQL Developer In this example ...
Masking SSN in PeopleSoft I was looking for this in the PeopleBooks and could not find it. Also after searching Google for a bit, I also came up empty. So I thought I would sha...
Comments
  1. Posted by EricShi
    • Posted by Brian Jackson

Add Your Comment