Variable in filter not working

[Neville]

Have a grid that I want to filter by the user that is logged in. Cannot get it to work...but when I tell it to prompt for a value and I enter the value manually then the filter works.
How can one display the value of a session variable at a point so I can see if it is picking up the variable?

Thanks

[GGandhi]

Re: Variable in filter not working

have you seen video m44 in version 11, that should help.

[Neville]

Re: Variable in filter not working

Hi Gandhi,

Many thanks for your help.
I have watched the video but I am using v12. I have set up the filter using the ide and all seems fine. The problem is that the grid returns no records, but if I set it up to force the user to enter a value then the filter works.
Now I am of the opinion that the session variable is not being set properly.
How can I see what the value of the sessions var is as the grid is opened.
Hope this makes sense
Thanks

[GGandhi]

Re: Variable in filter not working

session variables are set by the server when you login. so you have two options.
1> publish and check whether it is working, or
2> dim a session variable in the script so the script has something to work with and comment out that part of the code when you are satisfied to publish.

[Neville]

Re: Variable in filter not working

Hi Gandhi
Where would I put that code to see what the value of the session var is as or just before the grid opens

Thanks

[peteconway]

Re: Variable in filter not working

You can do it with session variables these days.

in your Xbasic functions use something like this
function getLoggedInUsersID as c (e as p)
dim user as c
user = A5ws_GetCurrentUser()
if user = "" then
response.redirect("http://..login.a5w")
end if
e.control.CurrentUserID = user ' this is the control in the UX that the will give its value to an argument of the same name like CurrentUserID

end function


Create an ajax callback to getLoggedInUsersID execute the code in you javascript actions -

Execute the getLoggedInUsersID javascript action in both onRenderComplere and onSynchronize Dialog.

Your SQL should be set to filter against the CurrentUserID Argument.