Help with Open a Grid Component - Link vs Filter - and how to pass link or filter parameter from a Textbox

[mixter]

Hi,

This problem has eaten up more than half my day and I really could use some guidance please...

I have a UX, that is unbound (has no Data Binding)

there are 2 sets of a Textbox next to a Button
that look like this
20_FrontEnd_OpenByFields.png

The idea is to open a Grid, and link or filter on the value shown in the Textbox next to the button.

The first Textbox field properties Type is Character, and the second Textbox Type is Numeric

I have also set Default Values in each of the Textboxes, as shown in the picture attachment above.


The click event for each button is set to Action Javascript: Open a Grid component

I have tried using both Link and Base Filter method for opening the grid component.

And it only works... with default values

So if I do NOT type in any value into the related Textbox, then the grid opens (filtering on default value)



As soon as I try typing in a value into either textbox (even if I type the same default value) then the Open a Grid component returns "No Records in query"



So I tried it again using Base Filter (instead of Link) and the exact same behaviour....

Default values work fine, the grid opens and returns rows

But if I type in a value into a textbox then the grid fails to return any rows.


The weirdest behaviour was when I used Base Filter as the method of opening the grid, set up like this
BaseFilterVehicleID.png

Default value works fine, but if I try and type a value into the Textbox and then click the button, the grid totally fails, and the SQL shows that the Textbox parameter was not even passed across... as you can see in this SQL error message

41_iVehicleNull_OpenUsingFilter.png


Another weird behaviour...

If I click in a Textbox and type the exact same default value again
then click the button, the linked grid fails

If if I click in a Textbox and type the exact same default value again, but I only over-type one single character of the default value
then click the button, the linked grid works fine.


I even tried using a Javascript function for each of the Link but that failed also, the grid doesn't render and returns no message

30_LinkUsingFunction.png


31_LinkFunction.png


What am I doing wrong here?

[GGandhi]

Re: Help with Open a Grid Component - Link vs Filter - and how to pass link or filter parameter from a Textbox

take a look:

http://screencast.com/t/rC5V1Dey
is this you are looking for?

edit: I noticed you wanted to find out when you set up a default value,
so here is that part.

http://screencast.com/t/v4tDBUl2

[mixter]

Re: Help with Open a Grid Component - Link vs Filter - and how to pass link or filter parameter from a Textbox

Thank you for that Gandhi, most appreciated!

You confirmed I am doing the right thing

Your videos are exactly what I've done.

Somehow I think my UX has gone haywire. I am going to scrap it and start fresh again with a new UX

To give you an idea of the frustration I've had today,

your second video with the default values...

I have that situation exactly.

and my linked/filtered grid does open correctly, with nicely filtered data when I click the button,
BUT only if I accept the default value (and don't touch it with my keyboard)

If I type anything in the Textbox (i.e. type over the default value)
then I get zero result set.

Even if I type in the exact same default value.


I will scrap this UX and start again fresh... I have made a lot of changes to this UX along the way and something is not right.

I will post back here with my results!


P.S. There was only one very minor difference in your video


The only thing different I noticed was one minor thing

Your builder (Alpha V11) put double quotes around your numeric parameter, and mine (Alpha V12) did not put any quotes around my numeric parameter

my Base Filter was being entered by the builder as

iVehicle ={idvehicle}

when I change it to

iVehicle ="{idvehicle}"

it works *slightly* better, for the fact that I no longer get the SQL Server error

However I still get zero results filtered in the grid (unless I accept the default value in the Textbox, and then it works fine)

[GGandhi]

Re: Help with Open a Grid Component - Link vs Filter - and how to pass link or filter parameter from a Textbox

just want to remind you that I mentioned this is taken from alphasports and the id is character field.
if you do not succeed post back I will redo with numeric data.
(I did not want to mess with my tables so I did not work with my tables.)

[mixter]

Re: Help with Open a Grid Component - Link vs Filter - and how to pass link or filter parameter from a Textbox

Ah, OK thank you for clarifying that, about the ID in alphasports being Character data type.

So that clarifies the builder is working the way it should, with quotes (or not) around parameters, based on their data type.

I am thankful you confirmed I am doing the right thing.

I have this same linked grid technique working fine on several other UX.

It's just bizarre that on this particular UX, the Link/Filtered grid pops up perfectly when I click the button, using the default value in the Textbox,

but as soon as I type in anything, even the exact same default value, into the Textbox and click the button, the grid returns zero records

I will rebuild a new UX, and will post back here later. I have a feeling now that it will work correctly if I just start afresh.

[mixter]

Re: Help with Open a Grid Component - Link vs Filter - and how to pass link or filter parameter from a Textbox

Well I rebuilt my UX several times, and the exact same thing happened each time.

But I figured out what was going on...

It was OK if I targeted the grid to a Popup window

but it was NOT OK if I targeted the grid to the currently active Panel Card (which is what I wanted)

the solution was target the grid to another Panel Card and then set that Panel Card to be active

I posted about it here to save someone else running into the same problem:
msgboard.alphasoftware.com/alphaforum/showthread.php?110508