Thanks for the responses.  Yes, I'm aware of the customization link on pages,
but that's not quite our challenge.
 
The requirement is not to change the sort order of static columns.  It is to
allow the user to build a dynamic list of sort fields (and specify Asc/Desc for
each field) that they can then use to sort and resort an existing rowset in a
separate grid from an inquiry view (to give them multiple opportunities to view
this data from a single database call).
 
My page structure has work record at Level 0 containing fields that will be used
to build WHERE clause to retrieve rows from database using view.  Level 1 is a
grid containing result set from view.  The rows in this grid need to be able to
be sorted any number of ways using up to five different fields.  For example, by
Budget Year and Account; then by Fund, Grant; whatever the user desires.
 
My current requirement is to build a second rowset (e.g., in a second grid)
containing Field Name and Asc/Desc.  The user may insert up to five fields into
this grid (the fieldnames correspond to columns from the main Level 1 grid
-- which is the "view" result set).  This main Level 1 grid will be sorted using
the fields from second grid (using Sort rowset class method).
 
 

--- On Mon, 6/29/09, Denise M. White <dwhite@...> wrote:


From: Denise M. White <dwhite@...>
Subject: Re: work record with scroll/grid
To: peoplesoft-fans@yahoogroups.com
Date: Monday, June 29, 2009, 1:16 PM








Maybe I'm completely misunderstanding what you're trying to do, but are you
aware of the "Customize" link that shows on the grid header that gives the user
the option to customize the sort order of that grid? It sounds to me like you
are trying to duplicate functionality that is already there.

--- In peoplesoft-fans@ yahoogroups. com, "Schelske, Steve K." <skschelske@ ...>
wrote:
>
> Maybe you could include a sort check box and direction drop down along with
the field, instead of a different structure.
>
> FIELDA SORT Y/N SORT A/D
> FIELDB SORT Y/N SORT A/D
>
> -----Original Message-----
> From: peoplesoft-fans@ yahoogroups. com [mailto:peoplesoft-fans@ yahoogroups.
com] On Behalf Of Yuri Lakef
> Sent: Friday, June 26, 2009 2:41 PM
> To: peoplesoft-fans@ yahoogroups. com
> Subject: work record with scroll/grid
>
> Greetings -
>  
> I have an inquiry page that consists of a single work record at Level 0
containing several fields used for search criteria.  Level 1 is a view that
contains the results of the dynamic WHERE clause built based on Level 0 fields
that were populated.
>  
> What I'm trying to do is add sort fields to a scroll (or some structure) to
enable the user to dynamically "add" (similar to Insert Row by clicking on
"plus" sign) sort fields and whether the sort field is "Asc" or "Desc".  It
needs to be dynamic and could be any number of fields that exist in the search
criteria (the work fields at Level 0).
>  
> I know I can't have scroll or grid without having data record attached.  All I
really want is to build a list of fieldnames in the buffer so I can sort the
rowset based on these fields specified by user.
>  
> Any suggestions are appreciated.
>  
> Many thanks!
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------ --------- --------- ------
>
> Sponsored by Improvisations. net
> Visit http://www.improviz ations.com to see our site.
> PeopleSoft-Fans Home Page is http://groups. yahoo.com/ group/peoplesoft -fans
> Check out our new blog at http://kronos- fans.blogspot. com/ Check out the
eZine archives at http://community. icontact. com/p/improvizat ions/newsletters
/improvizationsn ews
> *Yahoo! Groups Links
>



















[Non-text portions of this message have been removed]