Passing grid search criteria to a dialog window from an action button

[Roderick]

I've checked around and maybe its out there but I can't find it...

I have a standard "customer" grid with a search. If the user does not see the customer on the grid I've added an action button to open a dialog with the fields from the customer table. I would like to pass the search data over to the dialog in order to keep the user from re-typing the customer information.

Can someone point me in the right direction?

Note: I saw the videos about LINKING a dialog field to a grid and having it populate the field. The problem is that if you want to link multiple fields you must complete them all during the search and it narrows down the results. Is there an AND/OR option for linking?

[Roderick]

Re: Passing grid search criteria to a dialog window from an action button

I think I'm getting warmer. The answer lies somewhere in: {grid.Object}.getValue and {grid.Object}.setValue

I'm working on it and will post an answer for us beginner xbasic guys.

[Peter.Greulich]

Re: Passing grid search criteria to a dialog window from an action button

You're on the right track. BTW, {grid.Object}.getValue and {grid.Object}.setValue are JavaScript, not xbasic.

[Roderick]

Re: Passing grid search criteria to a dialog window from an action button

Still struggling...switched to a popup grid to keep things simple.

Thanks, Peter. It took quite a while to figure out my direction.

On my main grid onSearchSubmit: fname = {grid.Object}.getValue('S','CUSTOMER_FIRSTNAME');
On my popup grid onGridRender: {grid.Object}.setValue('G','CUSTOMER_FIRSTNAME',parent.fname); ....I've also tried just fname

I don't get an error but I don't get anything. Ha.

I put a debug(1) on server side CanSearch but fname is empty. I tried var fname but that doesn't work either.

[Roderick]

Re: Passing grid search criteria to a dialog window from an action button

I got it to work in a totally different way...

On the Server Side on CanSearch:


fname = ""
lname = ""
phone = ""
email = ""
username = ""

fname = e.SearchDataSubmitted.CUSTOMER_FIRSTNAME
lname = e.SearchDataSubmitted.CUSTOMER_LASTNAME
phone = e.SearchDataSubmitted.CUSTOMER_PHONE
email = e.SearchDataSubmitted.CUSTOMER_EMAIL
username = e.SearchDataSubmitted.CUSTOMER_USERNAME


Then on the grid in the fields Initial Value I just put "=fname", etc.

This will only work if the user actually clicks the Search button. If the user hits the enter key it does not set the variables. The work-around was to edit the Action Button javascript and add: {grid.Object}.submitSearchForm(); before popping the new grid open.

*** UPDATE
OK so it works great in the Working Preview but not in Firefox (even after publishing).
I'm stuck again!!

[kingcarol]

Re: Passing grid search criteria to a dialog window from an action button

I'm interested in what you are doing. I will be trying something similar with the search criteria soon. I am currently populating a dialog's initial values from a row in a grid by setting session variables based on data in the row before opening the dialog, and that's working nicely. When I get to the point of trying to populate a dialog with data from a search submitted, I would be trying to do it via session variables. Is it possible that's what you need to do? I see that there is info by Alpha in the CanSearch event about setting session variables.

[Roderick]

Re: Passing grid search criteria to a dialog window from an action button

Hey Carol,

I tried this in the Server Side CanSearch: Session.fname = e.SearchDataSubmitted.CUSTOMER_FIRSTNAME

the session.fname shows a value in debug(1)

then I tried

=session.fname in the Initial Value of the field in the pop-up grid but its not found.

When I try:

=fname it works in Working Preview but not in the browser after publishing.

Grrrrrrrr! I was up all night trying to figure it out.

[kingcarol]

Re: Passing grid search criteria to a dialog window from an action button

Well, that's irritating for you (and for me in future). When I was thinking ahead about doing something similar, I found myself wondering about the CurrentGridFilter() function that can be used when opening a report. And I wondered if that CurrentGridFilter() function is available to use as a filter for opening a child grid or dialog, also. And if it is, can pieces of it be accessed for setting default values in the child? Someone far more savvy than me might be able to provide insight about this whole concept.

[kingcarol]

Re: Passing grid search criteria to a dialog window from an action button

I just did a search for CurrentGridFilter in the Alphapedia and it IS indicating that it can be used to open a child grid, too. But I know that doesn't help with your problem with initial values. There's not a lot of info about what is contained in the CurrentGridFilter and how to get at it. Perhaps that can be seen with debug.

[peteconway]

Re: Passing grid search criteria to a dialog window from an action button

You need to do it the other way around. You need to start at the dialog and push the values to your grid (embedded the dialog)
{dialog.EmbeddedGrid_NAMEOFGRID}.gridBaseFilterSet(FIELD IN THE DIALOG, '',''); - The problem here is the Dialog2 began life as a servant to the grid - even today most of the functions that take it past that point are either feature packs or Subscriber benefits - so if like me you don't have a subscription you have a basic product you have to do it yourself and that's not a bad thing in he long run - I can't help you beyond that as the tools are not available in the standard product. You may want to contact Martin Heller and ask him. Here is something I found in the wiki (WOW) http://wiki.alphasoftware.com/How+to...dBaseFilterSet - it does work - just need to think i through.

[Roderick]

Re: Passing grid search criteria to a dialog window from an action button

Pete, thanks for the help.

I had to find a workaround in order to keep moving forward but it is something that I will need to revisit in a couple of days. Plus, once this is up and running I want to go back and polish it all

I'm not 100% on what you said. You said to start with the dialog and push to the grid but to embed the dialog?

I do have a subscription. Where should I start looking?