mdinic
Posts: 1
|
| Posted: 12/02/2008, 12:35 PM |
|
Hi all, I'm sure I'm missing something basic here but I can't find it in the examples anywhere. I'm working with PHP+MySQL. I'm building a ticketing system. I only want to show the tickets created by the current authenticated user to the current user. The default grid always shows all tickets to everyone. I used the application builder to create the code, this works fine. Now I'm trying to figure out:
1) Where is the user ID I got from MySQL stored? Cookie, session? How do I access it from the Grid query so I can modify the WHERE clause to only show current users rows?
2) Application builder is amazing, love it. One thing is, I can't select which columns to display in the Grid. Even after I modify the query feeding the grid, it still displays old empty columns. Then when i delete them, it asks to remove the containers. This is all OK, I was just wondering is there is a "right" way to go about modifying the default Grids?
Thanks!
|
 |
 |
datadoit
|
| Posted: 12/02/2008, 1:14 PM |
|
> 1) Where is the user ID I got from MySQL stored? Cookie, session? How do I
> access it from the Grid query so I can modify the WHERE clause to only show
> current users rows?
In the VQB (Visual Query Builder) for your grid, choose the WHERE
section. In your WHERE section, add an entry for user_id equals UserID,
whose value is in the Session.
|
|
|
|
|
