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.

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!

Incoming search terms:

• steps to provide record access in psquery
• creating records in peoplesoft screenshots
• how to create sql view in peoplesoft
• search record sql view peoplesoft
• screenshots to create peoplesoft views
• record to get sql in psquery
• proplesoft sql view using rank
• how to include a view in psquery
• how to create sql view record in peoplesoft
• how to create a sql view in peoplesoft