Edit value cleared when sorting colum

[matus_b]

Hi
after sorting column with edited values, values get lost.

public class GridEditByCellSample extends ShowcasePanel {
    private static final String DESCRIPTION = "<p><b>Click</b> on any cell to start editing. Use <b>Tab</b>, <b>Shift-Tab</b>," +
        "<b>Up Arrow</b>, and <b>Down Arrow</b> to move between cells.</p><p>Press <b>Enter</b> to save the current row" +
        "and dismiss the editors, or <b>Esc</b> to discard changes for the current cell and dismiss" +
        "the editors.</p>";

    public Canvas getViewPanel() {

        final ListGrid countryGrid = new ListGrid();
        countryGrid.setWidth(550);
        countryGrid.setHeight(224);
        countryGrid.setShowAllRecords(true);
        countryGrid.setCellHeight(22);
        // use server-side dataSource so edits are retained across page transitions
        countryGrid.setDataSource(CountryXmlDS.getInstance());

        ListGridField countryCodeField = new ListGridField("countryCode", "Flag", 40);
        countryCodeField.setAlign(Alignment.CENTER);
        countryCodeField.setType(ListGridFieldType.IMAGE);
        countryCodeField.setImageURLPrefix("flags/16/");
        countryCodeField.setImageURLSuffix(".png");
        countryCodeField.setCanEdit(false);

        ListGridField nameField = new ListGridField("countryName", "Country");
        ListGridField continentField = new ListGridField("continent", "Continent");
        ListGridField memberG8Field = new ListGridField("member_g8", "Member G8");
        ListGridField populationField = new ListGridField("population", "Population");
        populationField.setType(ListGridFieldType.INTEGER);
        populationField.setCellFormatter(new CellFormatter() {
            public String format(Object value, ListGridRecord record, int rowNum, int colNum) {
                if (value == null)
                    return null;
                try {
                    NumberFormat nf = NumberFormat.getFormat("0,000");
                    return nf.format(((Number) value).longValue());
                } catch (Exception e) {
                    return value.toString();
                }
            }
        });
        ListGridField independenceField = new ListGridField("independence", "Independence");
        countryGrid.setFields(countryCodeField, nameField, continentField, memberG8Field, populationField, independenceField);

        countryGrid.setAutoFetchData(false);
        countryGrid.setCanEdit(true);
        countryGrid.setEditEvent(ListGridEditEvent.CLICK);
        countryGrid.setEditByCell(true);
        countryGrid.setAutoSaveEdits(false);

        setRecordsToTheGrid(countryGrid);
        return countryGrid;
    }

    private void setRecordsToTheGrid(ListGrid grid) {
        final ListGridRecord record1 = new ListGridRecord();
        record1.setAttribute("pk", "0");
        record1.setAttribute("countryCode", "US");
        record1.setAttribute("countryName", "Test Country 1");

        final ListGridRecord record2 = new ListGridRecord();
        record1.setAttribute("pk", "1");
        record2.setAttribute("countryCode", "US");
        record2.setAttribute("countryName", "Test Country 2");

        grid.setRecords(new ListGridRecord[] { record1, record2 });
    }

    public String getIntro() {
        return DESCRIPTION;
    }

    public static class Factory implements PanelFactory {
        private String id;

        public ShowcasePanel create() {
            GridEditByCellSample panel = new GridEditByCellSample();
            id = panel.getID();
            return panel;
        }

        public String getID() {
            return id;
        }

        public String getDescription() {
            return DESCRIPTION;
        }
    }

}

Tested on Firefox and SmartClient Version: v10.0p_2016-06-15/LGPL Development Only (built 2016-06-15) SmartClient Version: v10.0p_2016-06-15/LGPL Development Only (built 2016-06-15)

[Isomorphic]

You didn't include your DataSource. Behavior like this could occur if either the DataSource lacks a primaryKey field, the data lacks primaryKey values, or the DataSource is configured such that the save operation returns bad data or fails silently.

[matus_b]

yes, it worked after setting primary key to the DataSource.
Thanks