.I’m filling combos with data obtained via AJAX using dataUrl & buildSelect.
Previously (version 4.4), I used to retrieve the values when filling the grid and everything worked perfectly: The value was displayed in the grid, matched to corresponding combo in edit form and the key was posted. That behavior changed some time ago.
According to the docs of formatter:select:
the data should contain the keys but the values will be displayed in the grid.
This works, but only if the values of the combo are set before loading the grid, for example in editoptions:
{value:”1:One;2:Two”}
Using formatter:select with dataUrl produce blanks fields when grid is loaded. Since I didn’t open the edit form the formatter didnt’t have values to match.
I could use a promise to load the grid after all data sources for the combos are filled, but I’ll have to change all the grids loading.
There’s any workaround?
Thanks in advance!
I tested code in version 5.1.
The code works almost the same with one exception. After posting the key to the database, the key is displayed in the grid (instead of the value). As a solution, I’m going to swap the key with the value in afterSubmit event so it’s displayed in the grid correctly and I don’t have to change my original queries to the database
Hello Will,
I’m already using that configuration: removing key property and setting id:0 in jsonReader. That only fix the issue with main id of the row. I also reported that issue on github:
https://github.com/tonytomov/jqGrid/issues/800
The problem with the combo is still present. I prepared a demo using version 5.1.1:
http://jsfiddle.net/d26hzhu6/16/
Edit any row, Change city to London and save changes. You’ll notice that id 1 is sent to server but also displayed on the grid (instead of the text London)
Thanks in advance.
Hello,
Without formatter select the post in grid is what you post to the server.
From one side you return the text for the select in grid, but you post the value. Having formatter select will solve your problem.
The link you mentioned is before 3 years and the change is caused by other important bugs of posting and comparing data.
Another solution what we can do for you is to define a new event similar to afterSubmit where you can change the posted values to the grid (not to the server), but I think with formatter select is a more elegant solution.
More over in buildSelect function you have a possibility to update the values for the select in colModel.
Kind Regards,
Will
Guriddo Support Team
Copyright 2014 TriRand LtdAll Rights ReservedRSS
Back to Top
