[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
- Subject: HELP W/ ACCEPTING INPUT PARAMETERS FROM PEOPLESOFT PANELS
- From: Anthony Kim <anthonyjkim@YAHOO.COM>
- Date: Mon, 23 Sep 2002 01:48:15 -0700
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!