Grid using lookup dataset

[dragontoungeParticipant]

Would someone please point me at an example of jqGrid showing how to populate the grid using one JSON based dataAdapter but linking one column to a second JSON based dataAdapter. I don’t want to edit the column and thus don’t need to populate a dropdown.

For example, if I was using a dataAdapter containing a ‘record’ like this ‘{“firstname” : “John”, “lastname” : “Doe”, “stateid” : “CA”}’ to populate the grid, how could I use a second dataAdapter containing ‘records’ like ‘{“stateid” : “CA”, “name” : “California”}’ to fill in the grid so it displayed “John”, “Doe”, “California”.

Thank you

[dragontoungeParticipant]

After some additional experimentation it seems possible to use the ‘cellsrenderer’ function to fill in the column with the correct value BUT when that column name is dragged to the grouping line the resulting groupings show the ID again and not the value (i.e. using the example above they groupings show “CA”, not “California”).

So, now please provide any example of how to achieve the design above, or how to affect the text that is displayed in the grouping lines.

Thank you

[Peter StoevKeymaster]

Hi dragontounge,

Example: http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/foreignkeycolumn.htm?arctic and http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/gridkeyvaluecolumn.htm?arctic

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[Author]

Posts