jQuery Grid Plugin - jqGrid

Tony,

Thanks for your support, but I can't seem to get this to work.  Will a dataEvent ever fire when the grid is populated with local data?  I am using inline editting and managing all the data loading and storing ajax calls myself, thus using local data in the grid.  I'm trying to implement the above in a grid as a subgrid.  Here is the part of the subgrid code i'm using to try to do this:

colModel: [
                        {name:'id',index:'id', width:55},
                        {name:"condvar",index:"condvar",width:150, editable: true, edittype:"select", editoptions:{value:"bkflag:bkflag;bkchapter:bkchapter;proptype:proptype", dataEvents :[{type:'change', fn:function(e){
                                                                                                                    alert("yo");
                                                                                                                    var thisval = $(e.target).val();
                                                                                                                    alert(thisval);
                                                                                                                    lookupField(thisval, subgrid_table_id, row_id);
                                                                                                                    }}]}
                        },

The issue is that the dataEvent never fires, thus the alerts in there to test that.  Is there any way to simply add the onChange property to the select box? This really is the last hurdle I need to get past to finish this project.. Please help

Thanks

Jeff

Hi Tony

I have followed your example as per your post on 19/12/2009 (17:04hrs).

I have put in the code as you suggested for inline editing & it works ok. However, when adding a new record & I select the first dropdown, the 2nd dropdown doesnt load. It must be because I am specifying the wrong element to be updated(because my column definition is specific for inline editing as as use the rowId)

What can I do so that in my col definition that it will work for both Form Editing(when adding a record) & inline Editing(when editing a record) ?

Also one other thing, when I put in this code as you suggested

my 2nd column did not update(I got no error in firebug).

So what i did to make this work, I did this: 

any thoughts on this other question?

thanks Tony!

Dear all,

I tried to implement dynamic select dropdown on toolbar searching, but I cann`t populate subcategory dropdown.

Can you show me where is something wrong?

here is my code:

{name:'Country'      , index:'Country'      , width:100 , editable:true, editoptions:{size:20, maxlength:'40'}, editrules:{required:true}, formoptions:{elmprefix:"(*)"}, sortable:true, stype:'select', search:true, searchoptions:{dataUrl:'filterselect/filterselectcountry.php',
          dataEvents: [ {
                type: 'change',
                fn: function(e) {
                var thisval = $(e.target).val();
                // do what yoou need
                $.get('filterselect/filterselectcity.php?country='+thisval, function(data)
                { var res = $(data).html();
                $("#City").html(res);
                }); // end get
                } //end func
          } ] // end type, dataevents
          }},

{name:'City'      , index:'City'      , width:70, editable:true, editoptions:{size:15}, editrules:{required:true}, formoptions:{elmprefix:"(*)"}, sortable:true, stype:'select', search:true, searchoptions:{dataUrl:'filterselect/filterselectcity.php?City=initialid'}}

And here is  filterselectcity.php

<?php
include '../config/connections.php';
$City     = $_GET['City']; //some variable

echo "<select>
<option value=''>All</option>";
if ($City <> '')
{$query="SELECT * FROM table WHERE City = '$City' GROUP BY City";}
else
{$query="SELECT * FROM table GROUP BY City";}
$result = $db->query($query);
$numresult=$result->num_rows;
for ($i=0; $i<$numresult; $i++)
    {
    $row = $result->fetch_assoc();
       echo "<option value='$row[City]'>$row[City]</option>";
    }
echo "</select>";
?>

Thank you for your assistance.

Best Regards,

Candra

Dear OlegK,

It works. Thank you

Best regards

Candra

Hello Candra,

I am not sure, but do you tried to reset the filter inside of dataInit?

Best regards
Oleg