Just want to capture login username to be able to use in grid query

[clankford]

I just want to be able to capture the username when you log into web database so that I can use in the filter when loading a grid. I do not need to lookup any additional information from a table or anything, just simply the user name.

Preferably if you can point me too a function/option already built in. But if code is only way please advise.

Thank you for your time.

[Peter.Greulich]

Re: Just want to capture login username to be able to use in grid query

You need to redirect to an intermediary a5w page before going to your real page. So create a page and point the security settings to go to that page after login.

Then on that page you could put code like this:

<%a5 
session.UserName = A5ws_GetCurrentUser()
%>

Then you can use the session variable (session.UserName) in the grid filter. You'll have to assign that var to an argument and filter on the argument.

[clankford]

Re: Just want to capture login username to be able to use in grid query

Peter, I'm having trouble entering the "filter" in the Grid. If I understand correctly, I need to enter an argument in the filter field, along with an argument in "Define Arguments" section?

If this is the case, can you maybe advise how to write these arguments?

Thanks

[clankford]

Re: Just want to capture login username to be able to use in grid query

Sorry Peter, I think I got the define argument. I believe my problem is that I have not been able to place the code you provided above in the right place.

If at all possible, can you advise how to setup an intermediary page you mention above. And probably equally important how do I add a button or function on this intermediary page to redirect to the navigation pane to then open the grid that will be using this variable?

Hopefully this question makes sense...

Thanks again, Casey

[Peter.Greulich]

Re: Just want to capture login username to be able to use in grid query

If I understand correctly, I need to enter an argument in the filter field, along with an argument in "Define Arguments" section?

Correct.

Define your argument - using the name of the session variable.
Then define your filter using the argument - e.g.

UserName = :UserName

where the first UserName is the field name and the second :UserName (preceded with the colon) is the argument.

[Peter.Greulich]

Re: Just want to capture login username to be able to use in grid query

If at all possible, can you advise how to setup an intermediary page you mention above. And probably equally important how do I add a button or function on this intermediary page to redirect to the navigation pane to then open the grid that will be using this variable?

1. Create an a5w page. Let's say you name it "Initialize.a5w".
2. Go to source view.
3. Delete all the default HTML on the page - we don't need it. The page is only being used to execute some xbasic; we're not using the page to render anything.
4. Put code in the page similar to this:

<%a5 
session.UserName = A5ws_GetCurrentUser()
response.redirect("Your_real_target_page_name.a5w")
%>

From the web controlpanel, go to web security/web security configuration/Login Options/Redirect page after login...

Select the "Initialize.a5w" page.

Save, publish and test.

[clankford]

Re: Just want to capture login username to be able to use in grid query

Peter! Thank you for your patience with me on this.....The additional code you provided for the page redirect did the trick!

My grid loads up properly per the user ID that is logged in.

This has been a major stumbling block for me over the last week. All the rest of the functionality in Alpha five has pretty much sold me and will most likely be getting with our IT Director to purchase license.

I know this may sound basic, but this is major for me in opening up a plethora of development ideas for corporate applications.

I may have some additional questions that I'm seeking a couple pointers and I should be good to go.....

Thanks again my friend.

-Carsell (Casey)

[Peter.Greulich]

Re: Just want to capture login username to be able to use in grid query

Glad to hear that it helped Casey. Not sure why Alpha has never made this clear. But if you don't know the "secret", it can be a major stumbling block, as you say.