Column editor:select type not changing options

[Sunny]

Hi,

I am using editor of type select in one of the columns of my grid. Noticed some strange behavior while changing options , provided more details below:

Here is my JSON data returned for the Options:
_{var csPkList = [{"id":"35170","pack":"XXS","qty":1},{"id":"33125","pack":"XS","qty":1},{"id":"33225","pack":"S","qty":2},{"id":"33325","pack":"M","qty":2}]}

I have three columns with dataIndxs (id,pack,qty), having 'id' column as hidden one.
and here is how I defined editor on 'pack' column.
                 
                    _{dataIndx: 'pack',
                     editor : {
                  type: 'select',
                  labelIndx:'pack',
             valueIndx:'id',
             dataMap: ['qty'],
             options: function (ui) {
               return csPkList;
              }
              }}

When I change the select options in 'pack' column from XXS to S,  qty column gets updated from 1 to 2 and it works normally. But when I change options from XXS to XS or S to M, the options are not been changed, they are showing up previous values. Noticed this is because XXS and XS has same qty value, S and M has same qty value.

Can you please advice ?

[paramvir]

Could you please also provide colModel and dataModel so that I can check your scenario.

or it would be much appreciated if you could provide a jsfiddle

http://jsfiddle.net/kw77c0sg/2/

[Sunny]

Hi ,

I provided scenario in jsfiddle at this link: http://jsfiddle.net/kw77c0sg/5/

Added three columns :Pack,Qty, Id(hidden); Pack column has dropdown editor; To reproduce issue: select 'XXS' option in first row, 'S' option in second row. Try to change from XXS to XS in first row or from 'S' to 'M' in second row, it will go back to previous values.

Hope this helps to understand scenario. Please look and advice solution to resolve this.

Thanks.

[paramvir]

Yes, column.editor.dataMap is not working as expected.

I've submitted it to bug log, you would get the fix in next release ( around first week of August )

[Sunny]

Thank you. Can you make sure the fix will be available in 2.4 version as well ?

[paramvir]

you may use this workaround fix.

Code: [Select]

               beforeValidate: function(evt, ui){
                   var newRow = ui.rowList[0].newRow;
                   
                   if(ui.source=='edit' && newRow['id'] ){             
                       ui.source='cedit';
                   }
               },

http://jsfiddle.net/kw77c0sg/7/

[Sunny]

Thank you, that worked.

[Sunny]

Hi,

While I do copy/paste the cells in the column(that has select editor), the dependant columns are not being updated. Can you please advice.

I tried in one of your demo, cascading select lists: http://paramquery.com/pro/demos/edit_select, after I selected three different options in column(Shipping Via) for first 3 rows, then I copied 'Speedy Express' in to the other rows which didn't update the 'Shipping Via ID' column.

Attached screenshot.

[paramvir]

That is a known limitation of copy/paste w.r.t select lists.

Currently the only workaround is to update the related fields in beforeValidate event:

Code: [Select]

beforeValidate: function(evt, ui){
debugger;
if(ui.source==='paste'){
var rowList = ui.rowList;
for(var i=0;i<rowList.length;i++){
var row = rowList[i],
newRow = row.newRow,
rowData = row.rowData,
oldRow = row.oldRow;
if( newRow.ShipVia ){
newRow.ShipViaId = //lookup for ShipViaId in column.editor.options
oldRow.ShipViaId = rowData.ShipViaId;
}
}
}
},