How to get the value (instead of the label) of a jqxDropDownList in a jqxGrid

[richardjansenParticipant]

I want the ‘value’ instead of the ‘label’. Just like a plain <select name=”status”><option value=”T”>Temp</option></select> I want the “T” and not the “Temp”.

jqxGrid columns snippet:

{
            theme: 'arctic',
            source: assortimentAdapter, 
            autoheight: true,
            editable: true,
            sortable: true,
            width: 1100,
            columns: [
                ...
                { text: 'Status', dataField: 'status', columntype: 'dropdownlist', editable: true, 
                    createeditor: function (row, value, editor) {
                        editor.jqxDropDownList({ source: artikelStatusAdapter, displayMember: 'label', valueMember: 'value' });
                    }
                }
            ]
        }

assortimentAdapter snippet:

var source = {
	datatype: 'json',
	datafields: [
		{name: 'id', map: 'id'},
		{name: 'status', map: 'status'}
	],
	url: url,
	updaterow: function (rowid, rowdata, commit) {
		console.log(rowdata.status); // Displays "Temp" instead of "T"!!
		$.ajax(url, {method: 'POST', data: rowdata, dataType: 'json'}).then(function(response) {
			commit(true);
		});
	}

statusAdapter snippet:

var adapter = new $.jqx.dataAdapter({
	datatype: 'array',
	datafields: [
		{name: 'value'},
		{name: 'label'}
	],
	localdata: [
		{value: 'P', label: 'Permanent'},
		{value: 'T', label: 'Temp'}
	]
});

Thanks,
Richard Jansen

[Peter StoevKeymaster]

Hi Richard Jansen,

As far as I see, your Grid column is not set up as a column which has Label and Value. Here’s an example: http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/gridkeyvaluescolumnwitharray.htm?arctic which demonstrates how this should be implemented.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[richardjansenParticipant]

Hi Peter

Thanks for your response. I based my code on that example you send. I don’t understand where and how to set the ‘value’ and ‘label’. I tried everthing. The example is too complex for helping me with my simple problem. Can you give me more hints or solution?

Thanks,
Richard Jansen

[Peter StoevKeymaster]

Hi Richard Jansen,

Sorry, we do not have a simpler example for creating a column with label/value pair. The column with DropDownList editor in the sample has displayfield and datafield which indicate the label and value in the data source.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[richardjansenParticipant]

I see now how it’s working and I’ve implemented that in my code. The weird thing is that I needed to add an extra dataField in the dataSource, according to the example. Now I have 2 fields: one for the code and 1 for the string from the seleceted dropdown option. Is this normal? Actually I only want the code.

Thanks,
Richard

[zokanziParticipant]

Hi @richardjansen;

Can you share me sample codes if possible.

Thanks…

[Author]

Posts