Key/value filter problem with server-side filtering

[ettemlevestParticipant]

I have a server-side filtering (paging, sorting) grid that has a Key/value column. It’s a status field that gets values from the database and on the client side the browser translates the key values to human readable text. I have to translate the label field to various languages. I used the example from the grid-list-filter-with-key-value-column.htm demo file. The displaying works fine but when it comes to filtering there’s a problem. When I filter the status column the grid sends wrong data (filterdatafield0) to the server.

Status source and dataadapter:

var statuses = [
 { value: 'vacant', label: 'Vacant' },
 { value: 'closed', label: 'Closed' },
 { value: 'under_construction', label: 'Under construction' },
]
, statusSource = {
  datatype: 'array',
  datafields: [
    { name: 'value', type: 'string' },
    { name: 'label', type: 'string' },
  ],
  localdata: statuses
}
, statusAdapter = new $.jqx.dataAdapter(statusSource, { autoBind: true });

Dataadapters datafields:

datafields: [
{ name: 'status', type: 'string' },
{ name: 'statusTranslated', type: 'string', value: 'status', values: { source: statusAdapter.records, value: 'value', name: 'label' },
...
]

Column definition:

{
  text: 'Status', datafield: 'status', displayfield: 'statusTranslated',
  filtertype: 'list', filteritems: new $.jqx.dataAdapter(statusSource),
  createfilterwidget: function (column, htmlElement, editor) {
    editor.jqxDropDownList({ displayMember: 'label', valueMember: 'value' });
  }
}

Example post data sent to the server:

statusTranslatedoperator and
filtervalue0             Vacant
filterid0                vacant
filtercondition0         EQUAL
filteroperator0          1
filterdatafield0         statusTranslated
filterscount             1
groupscount              0
pagenum                  0
pagesize                 100
recordstartindex         0
recordendindex           100

In the example demo file there’s a filter event listener when I apply it to my grid this is the created data object:

filtercondition0 EQUAL
filterdatafield0 status
filterid0        vacant
filteroperator0  1
filtervalue0     Vacant
statuszoperator  and

The server gets the displayfield name instead of the datafield. My goals is to send this kind of data to the server:

statusoperator           and
filtervalue0             <strong>vacant</strong>
filtercondition0         EQUAL
filteroperator0          1
filterdatafield0         <strong>status</strong>
filterscount             1
groupscount              0
pagenum                  0
pagesize                 100
recordstartindex         0
recordendindex           100

Is there something that I missed? How can I achieve that the post data contain the status as filterdatafield and the key value as filtervalue?

[Peter StoevKeymaster]

The filterdatafield is always the column’s data field or the display field if it’s different from the data field. By using the adapter’s formatData callback function, you can send additional params if you wish.

Regards,
Peter Stoev

[Author]

Posts