check a box with button onclick event on a UX

[bob9145]

A checkbox control based on a variable with multiple choices. Trying to check two of the 5 boxes with a button's onclick event.

{dialog.object}.setValue('checkboxes[]',['checkbox1','checkbox2'],true);

This is not working. What am I missing?

[Steve Workings]

Re: check a box with button onclick event on a UX

Probably fun with case sensitivity. Try this:

{dialog.Object}.setValue('CHECKBOXES[]',['checkbox1','checkbox2']);

I think the control reference must be in all uppercase - regardless of the case management in you actual control name. And the choices you're trying to set must match, so if your choice is Checkbox1 and you specify checkbox1 it won't work.

[bob9145]

Re: check a box with button onclick event on a UX

Thank you Steve,
I'll give it a try at halftime!
Game Over! Great half time show, but that was about it. lol

Back to business:
The checkboxes are case sensitive so they need to be exact. The control name seems to work either way, however keeping it in caps rings some bells as being a best practice. Not positive about that however.

This effort to manipulate checkboxes was in order to manipulate security groups dynamically for a user in my app.
I started with the UX security template to edit a user, and tried to get to the userroles control to accomplish this programatically.

{dialog.Object}.setValue('CHECKBOXES[]',['checkbox1','checkbox2']); worked on a checkbox control with a static list, however it did not work in the template with the checkbox being populated by security groups and set as checked according to the current users group assignment. Well it did create some erratic behavior it cleared the check mark of any checked groups.


Since the template uses action scripting it has been difficult to understand. I did manage a work around however. Once I understood how to use setValue with a checkbox array.

I manually populated the control choices with e.rtc.UserRoles = comma_to_crlf("group1,group2") vs a5ws_GetGroupsDialog()
This populated the control choices variable UserRoles with the specific groups I needed.

I converted the ondialoginitialize ExecuteServerSideAction("Populate Dialog from Tables::LoadUser") to xbasic

I then removed:

groups=[UserRoles] from the rtc.fieldmap. So although group1, and group2 are checkbox chioces populated with the UserRoles variable they are not selected,although in this scenario group one would have been checked when populated by the template because these users are all assigned to group1.

I then put {dialog.Object}.setValue('UserRoles[]',['group1','group2']); in a on focus event of another textbox field in the control group that I know will be populated by the user. This checks the two boxes.

Why two groups? I already know that these users are a member of group1, and need to be added to group2. However validating and saving the security groups clears any existing assignments in security. I am not sure exactly why this is because I do not know how to expose, or am not recognizing the code that handles this. So again as a work around I just reassign both groups.

Now last problem, I need this to be invisible to the user. However I can't make the control hidden as far as I know because that only applies to a textbox field. So I just hide the row, and the label.

This works but doesn't seem secure to me at all. This is the work of a challenged, but determined programmer!
I would like to understand this fully, since it is a frequent requirement of my app.

for now it works
Second group assigned: Check!

Bob

[Davidk]

Re: check a box with button onclick event on a UX

This works on a checkbox control named 'checkedbox1' a stored value and a display value. Here, the stored value is used to check 2 of the checkboxes in the control.

{dialog.object}.setValue('checkbox1[]',['1','2'],true);

[Steve Workings]

Re: check a box with button onclick event on a UX

OK, now I have one that won't work. Anyone see a problem with this?

{dialog.Object}.setValue('Property_Type_Ckboxes[]',['Hotel - Office','Office for sale - Office']);

Yes, the values match the choices in the controls just fine.

Thanks.

[Davidk]

Re: check a box with button onclick event on a UX

You don't say if you have both a Display Value and Stored Value set for this checkbox. If just a Display Value, then your .setValue works... since the stored valued is the same as the display value.

If you have a Stored Value that is the same as your Display Value, then the setValue works.

If you have a Stored Value that is different than the Display Value, then you must supply the Stored Value in the .setValue method.

[bob9145]

Re: check a box with button onclick event on a UX

Looks correct, using that exactly working for me in a onFocus event. Where are you using it?

[Steve Workings]

Re: check a box with button onclick event on a UX

Single value David. Not a separate stored value.

Bob - I'm applying this from a callback. But to debug, I put it right on a test button. Still no joy.

[Davidk]

Re: check a box with button onclick event on a UX

There must be something else going on that you've not detailed here. The same javascript from both client and server side work.

[Steve Workings]

Re: check a box with button onclick event on a UX

Only difference might be that the checkbox list is populated dynamically from a table.

And yup, I just build a test with static values, then applied this, and it worked just fine.

So, it appears the difference is that it won't work if the checkbox choices is populated from a table? Makes no sense.

Wait - I think I have it. My population query is now this, that appears to work.

SELECT rtrim(concat(rtrim(Description), ' - ', Type)) FROM Property_Types ORDER BY Description

I had this:

SELECT concat(rtrim(Description), ' - ', Type) FROM Property_Types ORDER BY Description

Lemme plug this into the bigger project, see how it flies.

[Davidk]

Re: check a box with button onclick event on a UX

My tests were with Static and Dynamic SQL selections. The only part that was unknown was how your sql statement was put together. Both of your SELECT statements work on my data. The only issue would be if your table values had extraneous spaces in them... which would have shown up in the displayed checkbox selections... and would explain why your .setValue wouldn't work. Fixing your data, as in your 2nd SELECT, allows the .setValue to find a match.

[Steve Workings]

Re: check a box with button onclick event on a UX

Yup, rtrim() on the expression did the job. What I also discovered was that customer's SQL 2008 is handling that differently than my SQL 2012. Love my job.