Guriddo » Topic: shows ‘undefined’ in grid when edittype=select

shows ‘undefined’ in grid when edittype=select

Guriddo
shows ‘undefined’ in grid when edittype=select

This topic has 7 replies, 2 voices, and was last updated 16 years, 8 months ago by tony.

Creator

Topic
October 19, 2009 at 11:59 pm #74400

sand123
Participant

when in colModel edittype set to 'select' and dataUrl points to external php script, in grid it shows all cells as 'undefined', but when I try to Add or Edit – it fills dropdown correctly in the form. When I just link to 3.5.2 version – it works, but when I use 3.5.3 – it does'nt. And response JSON arrays from external script (dataUrl) filled also correctly in both versions. Any idea?
Creator

Topic

Viewing 7 replies - 1 through 7 (of 7 total)

Author

Replies
October 20, 2009 at 2:55 am #89844

tony
Keymaster

Hello,

Your post

October 20, 2009 at 4:09 am #89847

sand123
Participant

colModel section (dataType in jqGrid.options set to JSON)

{

name:'id_tag',

index:'id_tag',

edittype:'select',

editoptions:{

dataUrl:'./lib/php/do.list.php?table=bak_tags'

},
formatter:'select'

}

raw GET response when open form for adding or editing

Acronis

APbackup

load data response. In grid, in column for 'id_tag' must be 'Acronis', but there 'undefined'. All other columns showed correctly

{
“page”:”1″,
“total”:1,
“records”:”1″,
“rows”:[

{

“id”:”1″,

“cell”:[“1″,”Acronis”,”MyServerName”]

}

]
}

<br />

1

<br />

October 21, 2009 at 2:36 am #89882

tony
Keymaster

Hello,

All work as expected. Just to analize the situation:

1. You set a edit type select – in this case we expect the data for the select to be get when we perform editiing via the dataUrl option.

2. In the same way you use the formatter select. These values should be in the grid options before you populate the data to the grid. The simple question is why? Just to think – in the case provided from you use another request to obtain the data – in the same time the grid uses his own request to populate the data, which request will be done first? – it is unknown. I think you understand this point. In order to work this you should

…

{ name: 'some',

October 21, 2009 at 6:00 am #89908

sand123
Participant

Thanks for answer – now it works! But I was confused – if there was error in colModel definition – why it works with 3.5.2 – while *ALL* other project files (html,js,php,mySQL db) are the same? And the second one: it's not comfortable (IMHO) to use param 'value' explicitly defined in colModel if I use external URL for dropdown values. May it be optionally allowed preloading these values when init grid: i.e, ajaxSetup: async->false, load data according to editUr(if 'value' parameter is not defined) and fill 'value' parameter, ajaxSetup: async->true, continue init grid

October 21, 2009 at 6:45 am #89909
sand123
Participant
And one more important thing (be patient, plz): edyttype=select works fine, BUT
- reload page
- select any row in grid and click [Edit] – edit form popup
- fields with edittype=select filled with values but they don't match values in this record – they always select 1st item in listbox
- close form and open again – on the same record – values selected correctly.
this situation reproduced all the time. in editOptions recreateForm = false
October 21, 2009 at 6:57 am #89910

sand123
Participant

version=3.5.3; if (before edit) open Add form and close (whatever save or not new record) – than also all forms next time filled correctly

October 21, 2009 at 9:14 am #89917

tony
Keymaster

Hello,

The bug is fixed in 3.6beta.

Regards

Tony
Author

Replies