Edit user record in Security Framework with latest v11 update

[dfricke10]

This pertains to the latest update in v11. I have a dialog to edit the user information stored in my table and the corresponding user info in the Security Framework. I'm opening the dialog from a button in a grid which contains a list of the current users. I have the dialog pulling the user info from my table, but it's pulling the security data from the user defined in the onDialogInitialize event which is hard coded in the script.

My question is how to insert the variable there to pull the security data based on the record opened in that dialog from the grid.

Make sense?

Thanks in advance for any help.

[dfricke10]

Re: Edit user record in Security Framework with latest v11 update

Here's the debugging info. The data from the regular table is correct. But the script is pulling the security data for 1001, which is the record sample specified in the default script. What would I enter in the script to make it relative to the record I'm opening?Screen shot 2011-12-08 at 2.00.45 PM.png

[dfricke10]

Re: Edit user record in Security Framework with latest v11 update

Let's try this a different way.

What would go in the [dim id as c = "1001"] line to pull the ID from the grid?



function onDialogInitialize as v (e as p)

'---------- Simulate a user value passed to the dialog for user with a primary key of 1 c = "1001"
dim id as c = "1001"
'---------- Set up variable to populate the 'UserRoles' radio control
dim e.rtc.UserRoles as c

'---------- Use security function to populate the variable
e.rtc.UserRoles = a5ws_GetGroupsDialog()

if e.rtc.UserRoles = "" then
e.javascript = "alert('The Security Framework is not enabled.');"
exit function
end if


'To edit this action, place insertion point anywhere in the command, then click the 'Action Scripting' button'.
ExecuteServerSideAction("Populate Dialog from Tables::LoadUser")

'To edit this action, place insertion point anywhere in the command, then click the 'Action Scripting' button'.
ExecuteServerSideAction("Load Web Security Values::LoadSecurity")





'Inside e:
'e.tmpl = Component definition
'e.rv = Request variables
'session = Session variables
'e.rtc = Runtime calculations - you can use this to store data to be passed to other server side events
'e.arguments = SQL::Arguments object with values for each of the arguments defined in this component. To read a value from arguments: e.arguments.find("argumentName").data

'You can set the initial value of any field by setting the property
'e.control.<fieldname>
'For example:
'e.control.firstname = "Fred"
'e.control.lastname = "Jones"

'To set the value of a field in a repeating section, you must use "_A5INSTANCE" and the instance number as a suffix on the fieldname.
'For example:
'e.control.firstname_A5INSTANCE2 = "Bob" 'sets the value in the 2nd row of the repeating section.

'To specify any javascript that you want to execute set the e.javascript property. For example:
'e.javascript = "alert('hello');"

'You can set 'state' variables in this event. The value of any state variables will be available in all subsequent ajax callbacks.
'To set a state variable:
'e._set.myvar1 = "value1"
'e._set.myvar2 = "value2"

end function

[dfricke10]

Re: Edit user record in Security Framework with latest v11 update

So... Where are the rest of the videos for this new component. Seems like no one has used it yet. The last video says there are more videos.

[Jowell]

Re: Edit user record in Security Framework with latest v11 update

If I understand correctly your question, you have to select the Primary Key of the security record by customizing the load security action script -> When in Xbasic, press the action scripting button and choose edit action. Do not forget either to have a good publication of your security files (I was initially confused by the fact that the working preview has got other security files than the live preview ...)

On the other hand, you need to have initially saved in your table the username or ulink or guid somewhere (the populate table action will retrieve this data), so that the load security action finds a key to select further the security record.

I made yesterday a few grids using these new action scripting and I had no problem. I used build 3841.

[Garry Flanigan]

Re: Edit user record in Security Framework with latest v11 update

I am also haviing problems.
My security users table is in sql and the primary key is "UserId".
So from my calling grid I have a button and in the onClick event have the action "Open a Web Page or PDF File" with the Page URL as:

user_modify.a5w?id={Userid}

In my new dialog (as per the v11 video) in the onDialogInitialize event I have the default script and in ExecuteServerSideAction("Populate Dialog from Tables::LoadUser") I use the variable "id". When I test this in "Working Preview" with a valid UserId it works.
But when I call try it from the button I get the error:

"Populate Dialog from Tables Action did not run because of an error.
Variable for Primary Key values not found. Variable name: id"

Any help most appreciated.

[bea2701]

Re: Edit user record in Security Framework with latest v11 update

If you want pass sessions vars into the dialog you have to publish first. Then call your session var from a javascript in captial letters.
This will not work <UserID> this is correct <USERID>

[Garry Flanigan]

Re: Edit user record in Security Framework with latest v11 update

Eric, I forgot about the capital letters bit - doh!!
Unfortunately did not solve my problem.
What method do you use to open the dialog on a selected record?

[Garry Flanigan]

Re: Edit user record in Security Framework with latest v11 update

The solution for me was in the server-side event onDialogInitialize where I did as follows:

dim id as c = e.rv.USERID

My only issue now is that in Version 2466-3883 it is not displaying UserRoles properly - I get a phantom group of all the existing groups which is selected and cannot then select other groups?

Anyone else seeing this?

[Rida Alhasan]

Edit user record in the Security Framework

.
Hi David,
I'm using the same way of editing existing users (both Personal and Security data) and have run into the same issue: the Dialog2 component works with the hardcoded id but not when the id is passed into the Dialog2 component. When I pass an id into the Dialog2 component, it correctly retrieves the data from my table (the Personal data) but does not retrieve anything from the system's Security table (the Security data).

How did you solve the issue?


Regards,
Felix
.

[Ferenju]

Re: Edit user record in Security Framework with latest v11 update

Rida,
I am having the same problem.
Could you please create a video showing your solution?

Thanks for your time.

[Rida Alhasan]

Re: Edit user record in Security Framework with latest v11 update

.
Eddie,
I've sent you a private e-mail.



Regards,
Felix
.

[Rida Alhasan]

Edit user record in Security Framework with latest v11 update

.
Hi Eddie,
I did not understand clearly your email. Could you please re-post it and, if possible, attach an image(s) of the webpage where you modify/delete a user?



Regrads,
Felix
.