Unexpected behavior with Keys/Values Column

[DaveBParticipant]

I have a grid with a customer name and a status ID. The status ID is a drop down that is linked to a separate data adapter that returns the possible customer status’. The adapter returns 1-Active, 2-Inactive, 3-New, however, although the grid displays the values correctly, the resulting drop down is filtered by the results that were returned in the grid, so if all the customers returned had a Status of 1, the only option in the drop down is Active(1). I would expect to also be able to select Inactive (2) or New (3). Is this the expected behavior? If so, is there a way to have the Key/Value drop down display all values that were returned in the dataAdapter that is used for the Drop Down?

Thanks in advance!

[DaveBParticipant]

also, if you need an example, you can use the Key/Values example and just add a couple of employees to the employee.xml file. Currently they all show in the drop down because the IDs for those employees also exist in the orders xml, but any employees that do no exist in the orders.xml will not display in the drop down.

[Peter StoevKeymaster]

Hi,

The data displayed in the Dropdownlist is based on the data displayed in the Grid. If you want to override the default Data Source of the DropDownList, take a look at this sample: http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/gridkeyvaluescolumnwitharray.htm?web

Best Regards,
Peter Stoev

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

[DaveBParticipant]

Thank you Peter, that was exactly what I was looking for.

[Author]

Posts