Re: Can SQR get current values off of a Peoplesoft panel group?

[Arthur Coniglio <Arthur.CONIGLIO@EDDEPT.WA.EDU.AU>]

        Yes it is possible. We found that there is a limit of how much
data you can send to the Sqr.
        The Sqr must be define as an 'SQR Process'.

        Also what we did was set SQR Parameters on the Process
Definitions Options
        panel to Append and strung all our parameters into a derived
work field using peoplecode
        and defined that work field within the parameters....ie:

        SQR Parameters:          Append              %%Oprid%% O
:derived_ben_wa.parameters_wa

        Once the definition is setup, you can kick off the sqr process
thru your peoplecode....
        An example below:

        function Submit_Bulk_Booking;
           if Substring(%PanelGroup, 1, 8) = "BULK_VAC" then
              &PROCESS_NAME = "EDWA0072";
           else
              &PROCESS_NAME = "EDWA0058";
           end-if;
           SQLExec("select prcstype, runlocation from ps_prcsdefn where
prcsname = :1", &PROCESS_NAME, &PROCESS_TYPE, &PROCESS_LOCATION);
           if None(&SERVER_NAME) then
              &SERVER_NAME = "PSWIN";
           end-if;
           if None(&PROCESS_LOCATION) then
              &PROCESS_LOCATION = "C";
           end-if;
           &PROCESS_RC = ScheduleProcess(&PROCESS_TYPE, &PROCESS_NAME,
&PROCESS_LOCATION, &RUN_CNTL_ID, &PROCESS_INSTANCE);
           if &PROCESS_RC <> 0 then
              MessageBox(65, %Menu, 105, &PROCESS_RC, "ScheduleProcess
Message - %1 Not Found", &PROCESS_NAME);
           end-if;
           PROCESS_INSTANCE = &PROCESS_INSTANCE;
           UnGray(REFRESH_PANEL_WA);
        end-function;



        Refer to your Process Scheduler manual for more details....

        Cheers

        Arthur Coniglio
        Education Department of Western Australia.


>                 -----Original Message-----
>                 From:   Scott Straus
> [mailto:SStraus@CI.COLOSPGS.CO.US]
>                 Sent:   Thursday, September 10, 1998 12:39 PM
>                 To:     Multiple recipients of list SQR-USERS
>                 Subject:        Can SQR get current values off of a
> Peoplesoft panel group?
>
>                 I am trying to capture values displayed off of a
> Peoplesoft Purchasing
>                 panel group in order to create a contract for our
> Purchasing dept.  I
>                 was hoping that I would be able to add a button to an
> existing panel
>                 which would kick off a SQR process, which would
> somehow
> be able to
>                 'scrape' the current values off the screen.  Does
> anyone
> know if this is
>                 possible?