[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

HELP W/ ACCEPTING INPUT PARAMETERS FROM PEOPLESOFT PANELS



Hi,

I need to use a peoplesoft panel to accept a one or more parameters to be used 
in the where clause of a sql statement.

For example,

1. Product Field Sort criteria (number these in order that user would like them 
sorted):

Note: The product field is a 6 character field where the first is the customer 
type, second thru fourth is the Plan Type, fifth is the Type of Service and 
sixth is Allow/Unallow.

Customer Type ____

Plan Type ____

Type of Service ____

Allow/Unallow ____

2. Business Unit criteria:

All Business Units ____

Specified Business Unit(s) _________ , __________, __________, ...

3. Account criteria:

All Accounts ______

Specified Account ______

Range of Accounts __________ ____________

4. Time span:

Current Month _______

YTD ______

I know there are several ways but what do you think would be the correct way to 
do this?

I've only written simple interfaces without any input parameters from the user 
so this one's a bit challenging so any help would be appreciated.



---------------------------------
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!