Dialog2 V11 how to read dialog values from an embedded object

[gamma]

Hi,

I have a dialog. This dialog contains a Dropdown, a button and a Grid as an embedded object. The embedded Object is defined that it appears " When the button is clicked"
The Grid of the embedded Object depends on the value selected from the dropdown box: This value is an SQL Argument.

I found that under Controls>select Embedded Object>Component Definition> Override settings>Override settings> I can set the arguments like

Arguments[1].value = value1
Arguments[2].value = value2

This works fine if it is a hard coded value string. But how can I enter the value of the dropdown box here?
I am looking for somthing like:

Arguments[1].value = {dialog.object}.getValue('Dropdown1')
Arguments[2].value = {dialog.object}.getValue('Dropdown2')

The above code does not work. Can anybody tell me how I can accomplish this?
Thank you

[Selwyn Rabins]

Re: Dialog2 V11 how to read dialog values from an embedded objekt

i have not tried to set up a test case to duplicate your situation, but i think you might be taking the wrong approach.

since you are only showing the embedded Grid when a button is pressed (rather than when the dialog is initially rendered), you could just as easily have added a standard button to the dialog and then used action javascript to define the button action to open a grid and shows the grid in a div on the dialog. (when you use action javascript to open a grid you can specify the target for the child grid - the default is a pop-up window, but it can also be a div)

the benefit of using this approach is that you can easily set the Grid link or filter to dynamically reference the values in the dropdown box. you will not need to write any code.



2. use a button on

[gamma]

Re: Dialog2 V11 how to read dialog values from an embedded objekt

Hi Selwyn,

Thank you once again for your help!
Could it be that a part of your answer is missing?:

2. use a button on

But I have the same situation with your suggestion as with the embedded grid, the "Open Grid Genie" is the same.

- in the onClick() Event I added a new Action "open Grid Component�
- I selected the Grid and this dialog is the same as with the embedded object.

I can't use the "link" or for that matter the �filter� or �Order� option for my purpose, as I am not trying to link, order or filter (to) a column of the Grid. The selected grid is build upon a stored procedure, I need to set the e.arguments for this call. But if I set the e. arguments either in the onSelect() Event of the dropdown or in the onClick() event of the button, they do no longer exist in the onSQLSelectQuery function of the grid. It seems that even if it is not an embedded object per definition the dialog components (dropDowns) have a totally different "e" as the grid.

This was also the main reason why I wanted to use above mentioned Override function but I can't figure out how to enter here the values of the 2 Dropdowns but it works fine if I hardcode the values at this point (which of course is not what I want to do.

So thank you for your suggestion anyway!

[gamma]

Re: Dialog2 V11 how to read dialog values from an embedded objekt

Hi Selwyn,

a funny thing happens when I add a button to a dialog and call it "zur�ck" (German for "Back"). The Button text does not seem to like the "�" and changes the whole thing straight away to "Zur�ƒ�’�†�€™�ƒ�€š�‚¼ck" and whenever I click on the "Button Text" field again, e.g. to change the text the system hangs (I configured the Alpha5.exe process to create a dump file straight away when the process hangs, so it is sending info to the dump file currently the whole time) and each time when it recovers the button text gets longer. the second time round its "zur�ƒ�’�†�€™�ƒ�€ â�‚��„��ƒ�’â�‚�� �ƒ¢â�€š¬â�€ž¢�ƒ�’�†�€™�ƒ¢â�€š¬�…¡�ƒ�’â�‚�š�ƒ�€š�‚¼ck" and so on.

I tried the same thing in a different dialog and the same thing happened. Can you reproduce this? When I write "Zuruek" instead or anything else without ��� (reproduceable for all three), all is OK.
Thanks!

[Selwyn Rabins]

Re: Dialog2 V11 how to read dialog values from an embedded objekt

try using <a5:r>back</a5:r> for the button text.
then go to the language definitions property and add this entry

back=zur�ck

[Selwyn Rabins]

Re: Dialog2 V11 how to read dialog values from an embedded objekt

Perhaps this video will help


http://www.ajaxvideotutorials.com/Ji...BEDDEDGRID.swf

[gamma]

Re: Dialog2 V11 how to read dialog values from an embedded objekt

Hi Selwyn,

Happy new year!
I was on holidays for a while now, so I only could reply now.

try using <a5:r>back</a5:r> for the button text.
then go to the language definitions property and add this entry
back=zur�ck

Above works fine, thank you!
Thank you as well for the video and it sounds simple enough but sadly

{dialog.EmbeddedGrid_G1}.gridFilterSet('','',field1 +'|||c|arg_field1\n'+field2+'|||c|arg_field2');

does not work for me.

It works fine if I actually use the arguments in the Query>Stored Procedure> SQL Statement like

EXEC [SP_myStoredProcedure] @field1 = :field1, @field2 =:field2

, then I am able to add the two arguments to the SQL argument. But if I only use a dummy SQL statement in order to retrieve the column headers to be able to select the fields (see http://msgboard.alphasoftware.com/al...472#post593472 ), this does not work although I defined the SQL arguments under Grid>Query>define Arguments e.arguments.XML does not contain anything

<SQLArguments>
</SQLArguments>

and I cannot add anything in this way. Even more, I noticed if I use the arguments in the SQL statement I can only add new arguments with your code but if arg_field1 and arg_field2 are already existent, it does not change the value of these arguments.

So I have a bit of an problem here as I need to proceed as in above mentioned thread but then I cannot use your example. I do not understand why it matters what lies behind the stored procedure call. The only thing that should matter is what is returned to Alpha Five, which is a table no matter if done with a simple Select statement or complicated T-SQL as Stored procedure definition.

Thank you for your help!

[Selwyn Rabins]

Re: Dialog2 V11 how to read dialog values from an embedded objekt

are you running the pre-release build, or the official release?

this syntax will only work in the pre-release build as the {dialog.embeddedGrid_G1} placeholder would not be translated into a real object name otherwise.
{dialog.EmbeddedGrid_G1}.gridFilterSet('','',field1 +'|||c|arg_field1\n'+field2+'|||c|arg_field2');

{dialog.embeddedGrid_G1} placeholder is just a shortcut for the real object name, which would be

window['G1_GridObj'].gridFilterSet(......).

I can tell you with 100% certainty that the gridFilterSet() method works exactly as shown.

[gamma]

Re: Dialog2 V11 how to read dialog values from an embedded object

Hi Selwyn,

the last patch I installed was the pre-release from 2011-12-16. I saw that there was a new patch yesterday so I exited A5 and installed it. After finishing installation I debugged the code as shown in your video and Alpha5 crashed while I was adding an argument see:
A5_crash_duringDebugging_dump_20120111.JPG
I have a dump file if you’re interested in it, but it is too large to send by mail.
Anyway, I could not reproduce the crash, after starting Alpha 5 and debugging again it worked just as you said. Thank you.

One thing I noticed was, that although I was able to change the arguments and the correct data was shown in the embedded grid. When I clicked on "Export to Excel" the data exported was the data from the initially loaded embedded grid and not the one currently shown. Does it not export the data presented in the UI but get the data new from the database? But even so it should still know the correct SQL arguments. Do I have to handle the export myself when using stored procedures or embedded grids? If so, do you have an example how to do that? How can I debug the Excel export?

Thank you!

[gamma]

Re: Dialog2 V11 how to read dialog values from an embedded object

Hi Selwyn,

when I put this dialog as a page of my tabbed UI and open the page I get an Error and the onClick Event no longer works. Even when I put an alert() as first thing in my click event this is not fired.
Here is the Error: A5_error_tabui_embGrid_20120116.JPG
But as soon as I comment out the filter set method of the embedded grid

//{dialog.EmbeddedGrid_G1}.gridFilterSet('','',selectedYear +'|||c|year');

it works fine.

Do you know why this is? And do you have a solution?
Thank you!

[gamma]

Re: Dialog2 V11 how to read dialog values from an embedded object

Hi,

does anybody know what the problem is with the above post #10? I only have the problem when the dialog is opend within the Tabbed UI.
Please help. Thank you!

[Selwyn Rabins]

Re: Dialog2 V11 how to read dialog values from an embedded object

In the command below, the placeholder '{dialog.EmbeddedGrid_G1}' is a special type of placeholder.
Support for this type of placeholder was only introduced in a very recent patch.
Internally, the placeholder is resolved to the 'real' object name.

So for example, when you write this:

{dialog.EmbeddedGrid_G1}.gridFilterSet('','',selectedYear +'|||c|year');

Alpha Five converts that (at run time) to:

window['{dialog.componentname}_G1_GridObj'].gridFilterSet('','',selectedYear +'|||c|year');

When support for this new type of placeholder was introduced (in a very recent update), the placeholder was only decoded into the 'window' syntax
shown above if the Dialog was loaded when the page was loaded. There was no support for decoding the placeholder
when the Dialog was loaded VIA AN AJAX CALLBACK (as is the case when the Dialog is loaded from a tabbed UI).

So the reason you are getting an error in the tabbed UI, is that the placeholder is not getting resolved. Therefore javascript is seeing
this '{dialog.EmbeddedGrid_G1}', which it tries to interpret as a JSON object. Of course, this is not a JSON object, hence the error message.

So, the solution is

a) don't use the special placeholder '{dialog.EmbeddedGrid_G1}'. Instead, resolve the embedded grid object name yourself by using this
in your code:
window['{dialog.componentname}_G1_GridObj'].gridFilterSet('','',selectedYear +'|||c|year');

or b), download the latest pre-release build, in which we have fixed the issue.

[gamma]

Re: Dialog2 V11 how to read dialog values from an embedded object

Hi Selwyn,

thank you so very much!
The latest build I found on the pre-release website, was from "Jan-25-2012 9:04 am (build 2384-3863)" so I used option a) and that works fine.
Thank you again.