Flexigrid - Lightweight but rich data grid

[eluser]paulopmx[/eluser]
[quote author="ecarsted" date="1207632262"]Hi, Paulo

Looking at the code and stepping in with Firebug, (what a handy tool!),

I see that the correct thing to set is params, not param

Code:

if (p.params)
589 {
590 var nparam = {};
591 $.each(p.params, function() {
592 nparam[this.name] = this.value;
593 });
594 $.extend(param,nparam);
595 }
596

so now, I am setting

params: {wherestr:"where xxx"},

Thing is though, nparam is not being updated. Hmm, not sure how to fix it.

Eric

ps. Also, not sure how I would change this value on the fly based on user input in a set of form fields.[/quote]

Hi Eric,

You are correct, the proper setting is indeed params. but to configure it you use this format

Code:

params: [{name:'name',value:'paulo'},{name:'lname',value:'marinas'}]

I change it to this format, because using jQuery's serializeMethod uses this same format as well.

for attaching the grid to a form, it is a bit more complicated, but here's a rough idea.
Suppose you have a form like this:

Code:

<form id="formx"><input type="text" name="name" value="" /></form>

you add a setting to flexigrid like this

Code:

onSubmit: onsubmit

then create a function like this

Code:

function onsubmit() {
                var dt = $('#formx').serializeArray();
                $("#flex1").flexOptions({params:dt});
                return true;
            }

this will overwrite the initial value of p.params, so if you have initial value set in, then its probably better to add it to the form as well as hidden inputs.

note the return true in the function, because if you return false, the flexReload action will cancel, this is useful if you want to add a validation in your forms.

then also block the form's submit event to call flexReload instead like this:

Code:

$("#formx").submit(function(){$('#flex1').flexReload();return false;});