Joe
|
| Posted: 06/03/2004, 11:16 AM |
|
How can i use the Session to control the data source filter
Table Name= Information
I assign a Usr_ID to each user that signs up, i know also that when i session is created a UserID is created also,
I want to filter all recoreds based on their User_ID, now i know you can do this through Data Source, Then use expressions with sessions, but i have no luck any hint would be great thanks
|
|
|
 |
peterr
Posts: 5971
|
| Posted: 06/03/2004, 3:05 PM |
|
You can click on the "+" sign in the Data Source to create a parameter:
, then enter "UserID" as the Paramater Source and select "Session" as the Type.
The Field Name would need to be the database field that contains your user ids (Usr_ID) and the Field Type usually should be Integer.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
Joe
|
| Posted: 06/04/2004, 9:43 AM |
|
That worked Great! ! !
But now i have another one,I have a table call ProDetail, Which contains a field called SCAC, and i need them to data source filter with field called SCAC, Which is in the Information Table along with all of the other users Information, I have tried to set the Field as SCAC and the Parameter Source to UserID and Type to Session but nothing, i have also tried Field as SCAC and Parameter Source as SCAC but again no luck, am i doing something wrong????? Thanks Again Peter
|
|
|
|
peterr
Posts: 5971
|
| Posted: 06/04/2004, 5:29 PM |
|
Yes, comparing two different fields shouldn't work. Your best bet may be to create a new SCAC session variable when users login, so that later you can use it when needed.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
peterr
Posts: 5971
|
| Posted: 06/06/2004, 11:52 PM |
|
Joe,
Please contact our support at http://support.codecharge.com or send me a PM as I have a question for you.
Thanks
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Rosario
Posts: 54
|
| Posted: 06/13/2005, 1:05 PM |
|
I , I tried following the example Posted: 06/03/2004, 3:05 PM using bolth the UserID as well as the CCGetUserID and It still dose not sort. The Field name is INPUT_BY , that matches the user id that is logged in. When the user logs in, is still bulls up all records. What could i be missing?
|
|
|
|
Rosario
Posts: 54
|
| Posted: 06/13/2005, 1:10 PM |
|
Also on the same page i get the session id to display the name of the person logged in in a lable via :
'Custom Code @63-73254650
' -------------------------
TASKSearch.Label1.Value =CCGetUserID()
' -------------------------
'End Custom Code
So i guess the session is ok, just the way i am trying to sort records is hosed.
|
|
|
|
|
