Hello,
I have been trying to create grid allowing the user to edit values in a grid. I followed documentation, particularly the example at:
https://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/gridkeyvaluecolumn.htm
Just like the example at that link, I want my users to be able to edit the value of the “customer” field using a dropdownlist type column editor.
I created a proof of concept at the following location:
https://jsfiddle.net/damerval/kt4usw6y/22/
I find that despite the dropdownlist column having a data source that contains thousands of options (my example uses a sample file which you can view here: https://res.cloudinary.com/damerval-private/raw/upload/v1563831100/code/customers.json), when I use the drop-down widget, only the options found in the grid itself (a little over 100 rows) are available for me to choose.
The behavior I expect is for the dropdownlist column to offer all the options contained in the data source I specified for it, not just those that happen to be present in the grid already.
Is my expectation wrong? And, more importantly, what do I need to do to achieve a behavior in line with my expectation?