saving of deleted rows only returns one row

[scheppi]

Hello,

i worked into Sigma.Grid since a couple of days now. Everything is working quite fine, but one feature:
I work with remote paging and remote sort functions and when i delete more than one row, only the last deleted row is being sent to the server by the save function. do I have to update all records into the deletedRows Array before sending manually ?

here are my definitions:

var colsOption=[ {id: 'chk' ,isCheckColumn : true, editable:false }, {id: 'GID' , header: "G-Nr." , width :60, fieldName: 'GID' }, {id: 'Investor' , header: "Investor" , width :200, fieldName: 'IName'  }, {id: 'Kunde' , header: "Nutzer" , width :200, fieldName: 'Firma'  }, {id: 'PName' , header: "Produkt" , width :200, fieldName: 'PName'  }, {id: 'KBeginn' , header: "Nutzungs Beginn" , width :130, fieldName: 'KBeginn'}, {id: 'KEnde' , header: "Nutzungs Ende" , width :130, fieldName: 'KEnde'}, {id: 'Miete' , header: "Nutzer Vergütung" , width :100, fieldName: 'Miete'}, {id: 'IWert' , header: "Invest Summe" , width :120, fieldName: 'IWert'}, {id: 'IBeginn' , header: "Invest Beginn" , width :120, fieldName: 'IBeginn'}, {id: 'IEnde' , header: "Invest Ende" , width :100, fieldName: 'IEnde'}, {id: 'Dividende' , header: "Auszahlung an Investor" , width :120, fieldName: 'Dividende'}, {id: 'Nebenkosten' , header: "Nebenkosten" , width :100, fieldName: 'Nebenkosten'}         ]; var dsOption= { uniqueField : 'no' , fields :[ {name : "GID"}, {name : "Investor"}, {name : "Kunde"  }, {name : "PName"}, {name : 'KBeginn' ,type: 'date' }, {name : 'KEnde' ,type: 'date' }, {name : 'Miete' ,type: 'float' }, {name : 'IWert' ,type: 'float' }, {name : 'IBeginn' ,type:'date'  }, {name : 'IEnde' ,type:'date'  }, {name : 'Dividende' ,type:'float'  }, {name : 'Nebenkosten' ,type:'float'  } ], recordType : 'object' } var gridOption={ id : "grid1", loadURL : "/cgi-bin/en-storage/crm.pl", saveURL : "/cgi-bin/en-storage/crm.pl", container : 'grid1_container', dataset : dsOption , columns : colsOption, pageSize : 10 , pageSizeList : [1,5,10,15,20,100,1000,10000], resizable : true, remotePaging : true, remoteSort : true, autoLoad : true, resizable : true, selectRowByCheck : true, toolbarContent : 'nav | pagesize | reload | del save | print | state' }
<div id="grid1_container" style="height:259px"> </div> <script type="text/javascript"> var mygrid=new Sigma.Grid(gridOption); mygrid.addParameters("view","inv"); Sigma.Util.onLoad( Sigma.Grid.render(mygrid)); </script>

as you can see, nothing special.
by the way i also tried first without checkasselected but didn't change anything.
Response (debug-output) attached as screenshot...

[scheppi]

as you can see in the screenshot as a debug-output i first display amount of elements in array {"param"}->{"_gt_json"}[0])->{deletedRecords}, followed by database unique identifier ID.
then i do the same for {"param"}->{"_gt_json"}[0])->{updatedRecords}, but this array has no elements at all.
afterwards i write the sql-query to delete the records and at last the "normal" json output follows.

As i do write my server side code in perl, please do not mind the syntax. it's a bit different to php, but i can read even your php hints.

[scheppi]

As i worked out in the meantime, all arrays in returned dataset always contain only one record. It must be a misconfiguration of the grid.

Now i played around with changing some configs, but as soon as I change recordType from object to array I dont get anymore data into my grid.
Where can I find more information about the different communication depending on recordType option in the dataset variable ?

please help !

[scheppi]

ok, i give in.
whatever i config for recordType : 'object' or recordType : 'array' the only changes are bracket types.
no multiple row-updates are possible.

[Daniel Odulo]

I finally solved this problem, after many hours of research.

The problem comes from setting the uniqueField property on the dsOption.

First off, you have it set incorrectly. You have it set to "no", but that field does not exist in your definition. In your example, it should be set as follows:
uniqueField : "GID"

Second, setting it to field name, in my experience, produced the same problem - only the last modified row would get sent tot he server.

I found 2 workable solution, (in my deployment):
1) Remove uniqueField setting all together.
2) Set it to  unique field index, instead of name. In your example it would be uniqueField : 0

Here's a link to the relevant documentation:
file:///C:/Users/Daniel%20Odulo/Documents/My%20Webs/Sigma%20Grid/sigma_grid2.4_release/docs/sigma_dataset.html#config_fields