donsafar
Posts: 90
|
| Posted: 02/18/2004, 10:55 PM |
|
I have a grid that displays trouble tickets. I have several conditions that I need to check based on security level and user group (organization he/she belongs to). I have been unable to figure our how to do this in the where clause, but I can identify the conditons in the before show row event. Conditions are. a user can view his own tickets. An admin can view his tickets and all other users in his group. The owner can view all tickets (these are identified by sec lvl 1,2,3). I just need to know how to hide the row if the conditions I am checking for are not true. I just have not been able to find the correct syntax. It would be nice if you could just say gridname.row.visible = false, but that doesn't work. I found in july of 2002 where codecharge said they would consider making this an enhancement. Anyone got any ideas on this.
_________________
Don Safar
|
 |
 |
peterr
Posts: 5971
|
| Posted: 02/18/2004, 11:25 PM |
|
Don,
I'm not sure if hiding individual grid rows would make sense. This could potentially desynchronize the number of records and number of pages shown in the navigator, the number of records shown on the page, etc.
I'm not sure, but that's the first things that comes to mind. It just doesn't seem "clean" to me.
Regarding your task, we perform similar, or more complex record selection logic in our own task management system by using the appropriate Where statement rather than hiding rows. In our case the Where statement is built and applied in one of the events ("Before Build Select", I think). I recommend that you build an appropriate Where statement programmatically. With little more work this should be possible.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Don Safar
|
| Posted: 02/19/2004, 8:58 AM |
|
Peter,
You are correct, I guess I was just tired after 18 hours at the computer. I
wrote the SQL statement that I needed using query analyzer then put the
where parameters in the "before build select" event. Only needed to a
session variable to get the sql results I needed. Works like a charm.
Thanks.
"peterr" <peterr@forum.codecharge> wrote in message
news:6403464fb9e7ba@news.codecharge.com...
> Don,
> I'm not sure if hiding individual grid rows would make sense. This could
potentially desynchronize the number of records and number of pages shown in
the navigator, the number of records shown on the page, etc.
> I'm not sure, but that's the first things that comes to mind. It just
doesn't seem "clean" to me.
>
> Regarding your task, we perform similar, or more complex record selection
logic in our own task management system by using the appropriate Where
statement rather than hiding rows. In our case the Where statement is built
and applied in one of the events ("Before Build Select", I think). I
recommend that you build an appropriate Where statement programmatically.
With little more work this should be possible.
> _________________
> Peter R.
> YesSoftware Support Representative
> http://support.codecharge.com
> Warning: I use Google and CCS Docs/Examples in most of my answers
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
|
