Harald Blotand
|
| Posted: 05/26/2002, 6:49 AM |
|
I have a grid in which most columns have sorters implemented. The grid
itself normally only displays a subset of the data from the table. The Data
Source includes the following restriction:
SELECT RequestID, PartNum, RqstQty, RqstDate, Approved, Rejected, Delayed,
Shipped, Received, MfgrName FROM Requests LEFT JOIN Mfgrs ON Requests.MfgrID
= Mfgrs.MfgrID WHERE UserID = '{UserID}'
Yet, when I use the sorter to re-order the data in the grid, the entire
dataset is displayed, that is in this case, all records for all UserIDs are
displayed instead of the subset which was displayed prior to the sort.
Obviously, I'm missing something. Is there any way to maintain the
restricted context when using the sorter?
Thanks in advance.
|
|
|
 |
Alexey Alexapolsky
|
| Posted: 05/27/2002, 12:44 AM |
|
How did you add that UserID parameter ?
If from "data source" , did you specify that this parameter comes from
session, not URL ?
--
Alex
CodeCharge Developer
"Harald Blotand" <blotand@yahoo.com> wrote in message
news:acqp4s$vg7$1@news.codecharge.com...
> I have a grid in which most columns have sorters implemented. The grid
> itself normally only displays a subset of the data from the table. The
Data
> Source includes the following restriction:
>
> SELECT RequestID, PartNum, RqstQty, RqstDate, Approved, Rejected, Delayed,
> Shipped, Received, MfgrName FROM Requests LEFT JOIN Mfgrs ON
Requests.MfgrID
> = Mfgrs.MfgrID WHERE UserID = '{UserID}'
>
> Yet, when I use the sorter to re-order the data in the grid, the entire
> dataset is displayed, that is in this case, all records for all UserIDs
are
> displayed instead of the subset which was displayed prior to the sort.
>
> Obviously, I'm missing something. Is there any way to maintain the
> restricted context when using the sorter?
>
> Thanks in advance.
>
>
|
|
|
|
Harald Blotand
|
| Posted: 05/27/2002, 7:24 PM |
|
No problem when specifying "Session" instead of "URL".
Thanks, Alex.
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:acso4c$avn$2@news.codecharge.com...
> How did you add that UserID parameter ?
> If from "data source" , did you specify that this parameter comes from
> session, not URL ?
>
> --
> Alex
> CodeCharge Developer
>
>
> "Harald Blotand" <blotand@yahoo.com> wrote in message
>news:acqp4s$vg7$1@news.codecharge.com...
> > I have a grid in which most columns have sorters implemented. The grid
> > itself normally only displays a subset of the data from the table. The
> Data
> > Source includes the following restriction:
> >
> > SELECT RequestID, PartNum, RqstQty, RqstDate, Approved, Rejected,
Delayed,
> > Shipped, Received, MfgrName FROM Requests LEFT JOIN Mfgrs ON
> Requests.MfgrID
> > = Mfgrs.MfgrID WHERE UserID = '{UserID}'
> >
> > Yet, when I use the sorter to re-order the data in the grid, the entire
> > dataset is displayed, that is in this case, all records for all UserIDs
> are
> > displayed instead of the subset which was displayed prior to the sort.
> >
> > Obviously, I'm missing something. Is there any way to maintain the
> > restricted context when using the sorter?
> >
> > Thanks in advance.
> >
> >
>
>
|
|
|
|
|
