Guriddo » Topic: sorting: zero values not sorted

sorting: zero values not sorted

Guriddo
sorting: zero values not sorted

This topic has 6 replies, 2 voices, and was last updated 12 years, 3 months ago by lili5058.

Creator

Topic
February 6, 2014 at 12:03 am #81522

lili5058
Participant

My colModel has the following definition for a column:

{name:overrdAmt, width:25, formatter:'currency', formatoptions:{decimalPlaces:0,prefix:'$',defaultValue:' '}, sortable:true, sorttype:'currency', align:'right',editable:true, edittype:'text', editrules:{number:true}, cellattr:amountOverrideCellAttr},

some of the values are 0 (zero), but when I sort, 0 values are not included. I tried sorttype: int and well as float, but doesn't seem to matter.

Am I missing something?
Creator

Topic

Viewing 6 replies - 1 through 6 (of 6 total)

Author

Replies

February 7, 2014 at 11:35 am #101788

tony

Keymaster

Hello,

We missed a lot of things that we need to know.

By example – are you using local data or server side obtaining a data.

If you are in second kase you will need to check your server side code when a sort is on.

I need a full grid setup and simple data in order to see where the problem was.

Kind Regards

February 7, 2014 at 4:23 pm #101789

lili5058

Participant

Sure, of course. Here is the info you need. I'm getting the data from the server, but switching to local data with the loadone:true. There is a bit of Grails code in the following snippets, FYI.

Full grid setup:

		var billGrid;<br />
var selRowId = null;<br />
var colModelNames = [${colModelNames}];<br />
// [ &#039;serviceName&#039;, &#039;CI_NAME&#039;,&#039;CI_TYPE&#039;,&#039;UDDS&#039;, &#039;amount&#039;, &#039;ovrrdAmount&#039;, &#039;isCmdbDataValid&#039;,&#039;billingCodeCmdb&#039;,&#039;ovrrdBillingCode&#039;,&#039;isBillingCodeValid&#039;,&#039;billYorN&#039;, &#039;isSplitBilling&#039;, &#039;isNonCI&#039;]<br />
var emptyMsgDiv = $(&#039;<div class="noRows">There are no unposted rows</div>&#039;);<br />
$(function(){<br />
var targetPage = 1;<br />
billGrid = $("#list").jqGrid({<br />
url:"${createLink(controller:&#039;physicalBilling&#039;, action:&#039;getBillData&#039;, id:billing.id)}",<br />
datatype: &#039;json&#039;,<br />
mtype: &#039;GET&#039;,<br />
colNames:[ &#039;SEO Service billed&#039;, &#039;Service Name (CI) billed&#039;,&#039;CI Type&#039;,&#039;UDDS&#039;, &#039;Calculated Amount&#039;, &#039;Override Amt&#039;, &#039;CMDB Data Is Valid&#039;,&#039;CMDB Billing code&#039;,&#039;Billing Code Override&#039;,&#039;Billing Code is Valid&#039;,&#039;Bill?&#039;, &#039;Split&#039;, &#039;isNonCI&#039;],<br />
colModel :[<br />
{name:colModelNames[0], width:60, sortable:true, sorttype:&#039;text&#039;},<br />
{name:colModelNames[1], width:70, editable:true, edittype:&#039;text&#039;,<br />
editoptions:{readonly:&#039;readonly&#039;}, formatter:formatCiName, unformat:unformatCiName},<br />
{name:colModelNames[2], width:50, sortable:true, sorttype:&#039;text&#039;},<br />
{name:colModelNames[3], width:30, sortable:true},<br />
{name:colModelNames[4], width:30, sortable:true, sorttype:&#039;currency&#039;, align:&#039;right&#039;, formatter:&#039;currency&#039;,<br />
formatoptions:{decimalPlaces:0,prefix:&#039;$&#039;}},<br />
{name:colModelNames[5], width:25, formatter:&#039;currency&#039;,<br />
formatoptions:{decimalPlaces:0,prefix:&#039;$&#039;,defaultValue:&#039; &#039;}, sortable:true, sorttype:&#039;currency&#039;, align:&#039;right&#039;,<br />
editable:true, edittype:&#039;text&#039;, editrules:{number:true}, cellattr:amountOverrideCellAttr},<br />
{name:colModelNames[6], width:30,  align:&#039;center&#039;,<br />
formatter:overrideOrInvalidContent, cellattr:overrideOrInvalidCellAttr},<br />
{name:colModelNames[7], width:50, sortable:true},<br />
{name:colModelNames[8], width:50, editable:true, sortable:true},<br />
{name:colModelNames[9], width:25, align:&#039;center&#039;,<br />
formatter:overrideOrInvalidContent, cellattr:overrideOrInvalidCellAttr},<br />
{name:colModelNames[10], width:15, align:&#039;center&#039;, sortable:true,<br />
formatter:overrideOrInvalidContent, cellattr:overrideOrInvalidCellAttr,editable:true,<br />
edittype:&#039;select&#039;,editoptions:{value:{&#039;y&#039;:&#039;yes&#039;,&#039;n&#039;:&#039;no&#039;}} },<br />
{name:colModelNames[11], hidden:true},<br />
{name:colModelNames[12], hidden:true}<br />
],<br />
width: &#039;1000&#039;,<br />
height: &#039;100%&#039;,<br />
pager: &#039;#pager&#039;,<br />
rowNum:20,<br />
rowList:[10,20,50,100,500],<br />
viewrecords: true,<br />
gridview: true,<br />
loadonce: true,<br />
footerrow : true,<br />
rowTotal:1000,<br />
sortname:&#039;CI_NAME&#039;,<br />
ignoreCase:true,<br />
subGrid: true,<br />
//jsonReader: {repeatitems: false},<br />
subGridRowExpanded: function(subgrid_id, row_id) {<br />
var subgrid_table_id;<br />
subgrid_table_id = subgrid_id+"_t";<br />
jQuery("#"+subgrid_id).html("");<br />
jQuery("#"+subgrid_table_id).jqGrid({<br />
url:&#039;${createLink(controller:&#039;billableServiceItem&#039;, action:&#039;getDetails&#039;)}&amp;id=&#039; + row_id,<br />
datatype: "json",<br />
colNames: [&#039;CI Validation Notes&#039;,&#039;Billing Code Validation Notes&#039;,&#039;Base CI Data&#039;],<br />
colModel: [<br />
{name:"valnotes",index:"valnotes",width:200, cellattr:detailsFormatter},<br />
{name:"billval",index:"billval",width:200, cellattr:detailsFormatter},<br />
{name:"cidetails",index:"cidetails",width:400,formatter:ciDetailsFormatter},<br />
],<br />
height: &#039;100%&#039;,<br />
});<br />
function ciDetailsFormatter(cellvalue, options, rowObject){<br />
var ciObj = jQuery.parseJSON(cellvalue);<br />
var ciObjStr = "";<br />
for (var prop in ciObj){<br />
if (ciObj.hasOwnProperty(prop)){<br />
ciObjStr = ciObjStr + prop + ": " + ciObj[prop] + ", ";<br />
}<br />
}<br />
return &#039;<span>&#039; + ciObjStr + &#039;</span>&#039;;<br />
};<br />
function detailsFormatter(rowId, val, rawObject, cm){<br />
return &#039;class="wrapTableCell"&#039;;<br />
};<br />
},<br />
editurl:"${createLink(controller:&#039;billableServiceItem&#039;, action:&#039;editPerformed&#039;)}",<br />
caption: &#039;Physical Items to be billed&#039;,<br />
onSelectRow: function(rowId, status, e){<br />
selRowId = rowId;<br />
var selRowData = billGrid.getRowData(selRowId);<br />
if (selRowData.isSplitBilling == "n"){<br />
$("#createSplitBtn").removeAttr(&#039;disabled&#039;);<br />
$("#deleteSplitBtn").attr(&#039;disabled&#039;, &#039;disabled&#039;);<br />
} else {<br />
$("#createSplitBtn").attr(&#039;disabled&#039;, &#039;disabled&#039;);<br />
$("#deleteSplitBtn").removeAttr(&#039;disabled&#039;);<br />
}<br />
$("#editRowBtn").removeAttr(&#039;disabled&#039;);<br />
if (selRowData.isNonCI == &#039;true&#039;){<br />
$("#refreshBtn").attr(&#039;disabled&#039;, &#039;disabled&#039;);<br />
} else {<br />
$("#refreshBtn").removeAttr(&#039;disabled&#039;);<br />
}<br />
},<br />
onPaging : function(){<br />
disableButtonsForNoSelectedRow();<br />
},<br />
loadComplete: onLoadComplete,<br />
}).navGrid(&#039;#pager&#039;, {add:false, del:false, edit:false, refresh:false, search:true},{},{},{},{},{});<br />

100

101

102

var billGrid;

var selRowId = null;

var colModelNames = [${colModelNames}];

// [ 'serviceName', 'CI_NAME','CI_TYPE','UDDS', 'amount', 'ovrrdAmount', 'isCmdbDataValid','billingCodeCmdb','ovrrdBillingCode','isBillingCodeValid','billYorN', 'isSplitBilling', 'isNonCI']

var emptyMsgDiv = $('<div class="noRows">There are no unposted rows</div>');

$(function(){

var targetPage = 1;

billGrid = $("#list").jqGrid({

url:"${createLink(controller:'physicalBilling', action:'getBillData', id:billing.id)}",

datatype: 'json',

mtype: 'GET',

colNames:[ 'SEO Service billed', 'Service Name (CI) billed','CI Type','UDDS', 'Calculated Amount', 'Override Amt', 'CMDB Data Is Valid','CMDB Billing code','Billing Code Override','Billing Code is Valid','Bill?', 'Split', 'isNonCI'],

colModel :[

{name:colModelNames[0], width:60, sortable:true, sorttype:'text'},

{name:colModelNames[1], width:70, editable:true, edittype:'text',

editoptions:{readonly:'readonly'}, formatter:formatCiName, unformat:unformatCiName},

{name:colModelNames[2], width:50, sortable:true, sorttype:'text'},

{name:colModelNames[3], width:30, sortable:true},

{name:colModelNames[4], width:30, sortable:true, sorttype:'currency', align:'right', formatter:'currency',

formatoptions:{decimalPlaces:0,prefix:'$'}},

{name:colModelNames[5], width:25, formatter:'currency',

formatoptions:{decimalPlaces:0,prefix:'$',defaultValue:' '}, sortable:true, sorttype:'currency', align:'right',

editable:true, edittype:'text', editrules:{number:true}, cellattr:amountOverrideCellAttr},

{name:colModelNames[6], width:30, align:'center',

formatter:overrideOrInvalidContent, cellattr:overrideOrInvalidCellAttr},

{name:colModelNames[7], width:50, sortable:true},

{name:colModelNames[8], width:50, editable:true, sortable:true},

{name:colModelNames[9], width:25, align:'center',

formatter:overrideOrInvalidContent, cellattr:overrideOrInvalidCellAttr},

{name:colModelNames[10], width:15, align:'center', sortable:true,

formatter:overrideOrInvalidContent, cellattr:overrideOrInvalidCellAttr,editable:true,

edittype:'select',editoptions:{value:{'y':'yes','n':'no'}} },

{name:colModelNames[11], hidden:true},

{name:colModelNames[12], hidden:true}

],

width: '1000',

height: '100%',

pager: '#pager',

rowNum:20,

rowList:[10,20,50,100,500],

viewrecords: true,

gridview: true,

loadonce: true,

footerrow : true,

rowTotal:1000,

sortname:'CI_NAME',

ignoreCase:true,

subGrid: true,

//jsonReader: {repeatitems: false},

subGridRowExpanded: function(subgrid_id, row_id) {

var subgrid_table_id;

subgrid_table_id = subgrid_id+"_t";

jQuery("#"+subgrid_id).html("");

jQuery("#"+subgrid_table_id).jqGrid({

url:'${createLink(controller:'billableServiceItem', action:'getDetails')}&id=' + row_id,

datatype: "json",

colNames: ['CI Validation Notes','Billing Code Validation Notes','Base CI Data'],

colModel: [

{name:"valnotes",index:"valnotes",width:200, cellattr:detailsFormatter},

{name:"billval",index:"billval",width:200, cellattr:detailsFormatter},

{name:"cidetails",index:"cidetails",width:400,formatter:ciDetailsFormatter},

],

height: '100%',

});

function ciDetailsFormatter(cellvalue, options, rowObject){

var ciObj = jQuery.parseJSON(cellvalue);

var ciObjStr = "";

for (var prop in ciObj){

if (ciObj.hasOwnProperty(prop)){

ciObjStr = ciObjStr + prop + ": " + ciObj[prop] + ", ";

}

return '' + ciObjStr + '';

};

function detailsFormatter(rowId, val, rawObject, cm){

return 'class="wrapTableCell"';

};

},

editurl:"${createLink(controller:'billableServiceItem', action:'editPerformed')}",

caption: 'Physical Items to be billed',

onSelectRow: function(rowId, status, e){

selRowId = rowId;

var selRowData = billGrid.getRowData(selRowId);

if (selRowData.isSplitBilling == "n"){

$("#createSplitBtn").removeAttr('disabled');

$("#deleteSplitBtn").attr('disabled', 'disabled');

} else {

$("#createSplitBtn").attr('disabled', 'disabled');

$("#deleteSplitBtn").removeAttr('disabled');

}

$("#editRowBtn").removeAttr('disabled');

if (selRowData.isNonCI == 'true'){

$("#refreshBtn").attr('disabled', 'disabled');

} else {

$("#refreshBtn").removeAttr('disabled');

}

},

onPaging : function(){

disableButtonsForNoSelectedRow();

},

loadComplete: onLoadComplete,

}).navGrid('#pager', {add:false, del:false, edit:false, refresh:false, search:true},{},{},{},{},{});

Sample data from the server:

{"total":398,"page":"1","records":398,"rows":[{"id":128650,"cell":{"serviceName":"Physical Hosting-Tape Library Frame (Storage)","CI_NAME":"ACD-CALL-LOGGER-1","CI_TYPE":"Server-Appliance","UDDS":"A-06-5043","amount":50,"ovrrdAmount":null,"isCmdbDataValid":"yes","billingCodeCmdb":"A-06-5043","ovrrdBillingCode":null,"isBillingCodeValid":"y","billYorN":"y","isSplitBilling":"n","volumeName":null,"isNonCI":false}},{"id":128570,"cell":{"serviceName":"Physical Hosting-Tape Library Frame (Storage)","CI_NAME":"ACD-CALL-LOGGER-2","CI_TYPE":"Server-Appliance","UDDS":"A-06-5043","amount":50,"ovrrdAmount":null,"isCmdbDataValid":"yes","billingCodeCmdb":"A-06-5043","ovrrdBillingCode":null,"isBillingCodeValid":"y","billYorN":"y","isSplitBilling":"n","volumeName":null,"isNonCI":false}},{"id":128607,"cell":{"serviceName":"Physical Hosting-Tape Library Frame (Storage)","CI_NAME":"ACD-REMOTE-1","CI_TYPE":"Server-Appliance","UDDS":"A-06-5043","amount":50,"ovrrdAmount":null,"isCmdbDataValid":"yes","billingCodeCmdb":"A-06-5043","ovrrdBillingCode":null,"isBillingCodeValid":"y","billYorN":"y","isSplitBilling":"n","volumeName":null,"isNonCI":false}},{"id":128521,"cell":{"serviceName":"Physical Hosting-Tape Library Frame (Storage)","CI_NAME":"ACD-REMOTE-2","CI_TYPE":"Server-Appliance","UDDS":"A-06-5043","amount":50,"ovrrdAmount":null,"isCmdbDataValid":"yes","billingCodeCmdb":"A-06-5043","ovrrdBillingCode":null,"isBillingCodeValid":"y","billYorN":"y","isSplitBilling":"n","volumeName":null,"isNonCI":false}},{"id":128335,"cell":{"serviceName":"Physical Hosting-Firewalll (Network)","CI_NAME":"ADAMS","CI_TYPE":"Network-Firewall","UDDS":"A-06-0170","amount":50,"ovrrdAmount":null,"isCmdbDataValid":"yes","billingCodeCmdb":"10004827.001.99","ovrrdBillingCode":null,"isBillingCodeValid":"y","billYorN":"y","isSplitBilling":"n","volumeName":null,"isNonCI":false}}

{"total":398,"page":"1","records":398,"rows":[{"id":128650,"cell":{"serviceName":"Physical Hosting-Tape Library Frame (Storage)","CI_NAME":"ACD-CALL-LOGGER-1","CI_TYPE":"Server-Appliance","UDDS":"A-06-5043","amount":50,"ovrrdAmount":null,"isCmdbDataValid":"yes","billingCodeCmdb":"A-06-5043","ovrrdBillingCode":null,"isBillingCodeValid":"y","billYorN":"y","isSplitBilling":"n","volumeName":null,"isNonCI":false}},{"id":128570,"cell":{"serviceName":"Physical Hosting-Tape Library Frame (Storage)","CI_NAME":"ACD-CALL-LOGGER-2","CI_TYPE":"Server-Appliance","UDDS":"A-06-5043","amount":50,"ovrrdAmount":null,"isCmdbDataValid":"yes","billingCodeCmdb":"A-06-5043","ovrrdBillingCode":null,"isBillingCodeValid":"y","billYorN":"y","isSplitBilling":"n","volumeName":null,"isNonCI":false}},{"id":128607,"cell":{"serviceName":"Physical Hosting-Tape Library Frame (Storage)","CI_NAME":"ACD-REMOTE-1","CI_TYPE":"Server-Appliance","UDDS":"A-06-5043","amount":50,"ovrrdAmount":null,"isCmdbDataValid":"yes","billingCodeCmdb":"A-06-5043","ovrrdBillingCode":null,"isBillingCodeValid":"y","billYorN":"y","isSplitBilling":"n","volumeName":null,"isNonCI":false}},{"id":128521,"cell":{"serviceName":"Physical Hosting-Tape Library Frame (Storage)","CI_NAME":"ACD-REMOTE-2","CI_TYPE":"Server-Appliance","UDDS":"A-06-5043","amount":50,"ovrrdAmount":null,"isCmdbDataValid":"yes","billingCodeCmdb":"A-06-5043","ovrrdBillingCode":null,"isBillingCodeValid":"y","billYorN":"y","isSplitBilling":"n","volumeName":null,"isNonCI":false}},{"id":128335,"cell":{"serviceName":"Physical Hosting-Firewalll (Network)","CI_NAME":"ADAMS","CI_TYPE":"Network-Firewall","UDDS":"A-06-0170","amount":50,"ovrrdAmount":null,"isCmdbDataValid":"yes","billingCodeCmdb":"10004827.001.99","ovrrdBillingCode":null,"isBillingCodeValid":"y","billYorN":"y","isSplitBilling":"n","volumeName":null,"isNonCI":false}}

February 10, 2014 at 3:19 pm #101794

tony

Keymaster

Hello,

I have just tested your example. By the way there are alot of code which is missing.

I need to delete a lot of code and not sure if this is ok.

Now to the question – in my enviroment everthing work fine. The sorting is fine.

Maybe you will need give me a more data to test.

Your data for the field does not contain 0 (zero), but null which is quiet different.

February 10, 2014 at 5:10 pm #101798

lili5058

Participant

Here is some different data. One cell has ovrrdAmount: 0, most have null, some have a few different values.

Is there a way to upload screenshots? Unfortuately the site is not publicly available so I can give a link.

[

{

“id”: 128650,

“cell”: {

“serviceName”: “Physical Hosting-Tape Library Frame (Storage)”,

“CI_NAME”: “ACD-CALL-LOGGER-1”,

“CI_TYPE”: “Server-Appliance”,

“UDDS”: “A-06-5043”,

“amount”: 50,

“ovrrdAmount”: null,

“isCmdbDataValid”: “yes”,

“billingCodeCmdb”: “A-06-5043”,

“ovrrdBillingCode”: null,

“isBillingCodeValid”: “y”,

“billYorN”: “y”,

“isSplitBilling”: “n”,

“volumeName”: null,

“isNonCI”: false

}

{

“id”: 128570,

“cell”: {

“serviceName”: “Physical Hosting-Tape Library Frame (Storage)”,

“CI_NAME”: “ACD-CALL-LOGGER-2”,

“CI_TYPE”: “Server-Appliance”,

“UDDS”: “A-06-5043”,

“amount”: 50,

“ovrrdAmount”: null,

“isCmdbDataValid”: “yes”,

“billingCodeCmdb”: “A-06-5043”,

“ovrrdBillingCode”: null,

“isBillingCodeValid”: “y”,

“billYorN”: “y”,

“isSplitBilling”: “n”,

“volumeName”: null,

“isNonCI”: false

}

{

“id”: 128607,

“cell”: {

“serviceName”: “Physical Hosting-Tape Library Frame (Storage)”,

“CI_NAME”: “ACD-REMOTE-1”,

“CI_TYPE”: “Server-Appliance”,

“UDDS”: “A-06-5043”,

“amount”: 50,

“ovrrdAmount”: null,

“isCmdbDataValid”: “yes”,

“billingCodeCmdb”: “A-06-5043”,

“ovrrdBillingCode”: null,

“isBillingCodeValid”: “y”,

“billYorN”: “y”,

“isSplitBilling”: “n”,

“volumeName”: null,

“isNonCI”: false

}

{

“id”: 128521,

“cell”: {

“serviceName”: “Physical Hosting-Tape Library Frame (Storage)”,

“CI_NAME”: “ACD-REMOTE-2”,

“CI_TYPE”: “Server-Appliance”,

“UDDS”: “A-06-5043”,

“amount”: 50,

“ovrrdAmount”: null,

“isCmdbDataValid”: “yes”,

“billingCodeCmdb”: “A-06-5043”,

“ovrrdBillingCode”: null,

“isBillingCodeValid”: “y”,

“billYorN”: “y”,

“isSplitBilling”: “n”,

“volumeName”: null,

“isNonCI”: false

}

{

“id”: 128335,

“cell”: {

“serviceName”: “Physical Hosting-Firewalll (Network)”,

“CI_NAME”: “ADAMS”,

“CI_TYPE”: “Network-Firewall”,

“UDDS”: “A-06-0170”,

“amount”: 50,

“ovrrdAmount”: null,

“isCmdbDataValid”: “yes”,

“billingCodeCmdb”: “10004827.001.99”,

“ovrrdBillingCode”: null,

“isBillingCodeValid”: “y”,

“billYorN”: “y”,

“isSplitBilling”: “n”,

“volumeName”: null,

“isNonCI”: false

}

{

“id”: 128532,

“cell”: {

“serviceName”: “Physical Hosting-Tape Library Frame (Storage)”,

“CI_NAME”: “ADIX (HD-ACD)”,

“CI_TYPE”: “Server-Appliance”,

“UDDS”: “A-06-5043”,

“amount”: 500,

“ovrrdAmount”: null,

“isCmdbDataValid”: “yes”,

“billingCodeCmdb”: “A-06-5043”,

“ovrrdBillingCode”: null,

“isBillingCodeValid”: “y”,

“billYorN”: “y”,

“isSplitBilling”: “n”,

“volumeName”: null,

“isNonCI”: false

}

{

“id”: 128311,

“cell”: {

“serviceName”: “Physical Hosting-Full”,

“CI_NAME”: “ADRIC”,

“CI_TYPE”: “Server-Physical-RackMount”,

“UDDS”: “A-06-7171”,

“amount”: 253,

“ovrrdAmount”: null,

“isCmdbDataValid”: “yes”,

“billingCodeCmdb”: “A-06-7171”,

“ovrrdBillingCode”: null,

“isBillingCodeValid”: “y”,

“billYorN”: “y”,

“isSplitBilling”: “n”,

“volumeName”: null,

“isNonCI”: false

}

{

“id”: 128701,

“cell”: {

“serviceName”: “Physical Hosting-Tape Library (Storage)”,

“CI_NAME”: “ADRICR”,

“CI_TYPE”: “NONE”,

“UDDS”: null,

“amount”: null,

“ovrrdAmount”: 20,

“isCmdbDataValid”: “yes”,

“billingCodeCmdb”: null,

“ovrrdBillingCode”: “A”,

“isBillingCodeValid”: “n”,

“billYorN”: “y”,

“isSplitBilling”: “n”,

“volumeName”: null,

“isNonCI”: true

}

{

“id”: 128603,

“cell”: {

“serviceName”: “Physical Hosting-Full”,

“CI_NAME”: “ADX-MASTER1”,

“CI_TYPE”: “Server-Physical-RackMount”,

“UDDS”: “A-06-4190”,

“amount”: 237,

“ovrrdAmount”: null,

“isCmdbDataValid”: “yes”,

“billingCodeCmdb”: “10004986.002”,

“ovrrdBillingCode”: null,

“isBillingCodeValid”: “y”,

“billYorN”: “y”,

“isSplitBilling”: “n”,

“volumeName”: null,

“isNonCI”: false

}

{

“id”: 128278,

“cell”: {

“serviceName”: “Physical Hosting-Full”,

“CI_NAME”: “ADX-MASTER2”,

“CI_TYPE”: “Server-Physical-RackMount”,

“UDDS”: “A-06-4190”,

“amount”: 237,

“ovrrdAmount”: null,

“isCmdbDataValid”: “yes”,

“billingCodeCmdb”: “10004986.002”,

“ovrrdBillingCode”: null,

“isBillingCodeValid”: “y”,

“billYorN”: “y”,

“isSplitBilling”: “n”,

“volumeName”: null,

“isNonCI”: false

}

{

“id”: 128480,

“cell”: {

“serviceName”: “Physical Hosting-Full”,

“CI_NAME”: “ALLIGATOR”,

“CI_TYPE”: “Server-Physical-RackMount”,

“UDDS”: “A-06-7180”,

“amount”: 237,

“ovrrdAmount”: 112,

“isCmdbDataValid”: “yes”,

“billingCodeCmdb”: “10004791.103”,

“ovrrdBillingCode”: null,

“isBillingCodeValid”: “y”,

“billYorN”: “y”,

“isSplitBilling”: “n”,

“volumeName”: null,

“isNonCI”: false

}

{

“id”: 128681,

“cell”: {

“serviceName”: “Physical Hosting-Full”,

“CI_NAME”: “ALLIGATOR”,

“CI_TYPE”: “Server-Physical-RackMount”,

“UDDS”: “A-06-7180”,

“amount”: 237,

“ovrrdAmount”: 125,

“isCmdbDataValid”: “yes”,

“billingCodeCmdb”: “10004791.103”,

“ovrrdBillingCode”: “A-06-4089”,

“isBillingCodeValid”: “n”,

“billYorN”: “y”,

“isSplitBilling”: “y”,

“volumeName”: null,

“isNonCI”: false

}

{

“id”: 128305,

“cell”: {

“serviceName”: “Physical Hosting-Full”,

“CI_NAME”: “AMBROSIA”,

“CI_TYPE”: “Server-Physical-RackMount”,

“UDDS”: “A-06-4281”,

“amount”: 302,

“ovrrdAmount”: 0,

“isCmdbDataValid”: “yes”,

“billingCodeCmdb”: “A-06-4281”,

“ovrrdBillingCode”: “D000243”,

“isBillingCodeValid”: “y”,

“billYorN”: “y”,

“isSplitBilling”: “n”,

“volumeName”: null,

“isNonCI”: false

}

{

“id”: 128274,

“cell”: {

“serviceName”: “Physical Hosting-Full”,

“CI_NAME”: “AMENHOTEP”,

“CI_TYPE”: “Server-Physical-RackMount”,

“UDDS”: “A-06-4029”,

“amount”: 237,

“ovrrdAmount”: null,

“isCmdbDataValid”: “yes”,

“billingCodeCmdb”: “A-06-4029”,

“ovrrdBillingCode”: null,

“isBillingCodeValid”: “y”,

“billYorN”: “y”,

“isSplitBilling”: “n”,

“volumeName”: null,

“isNonCI”: false

}

{

“id”: 128448,

“cell”: {

“serviceName”: “Physical Hosting-Full”,

“CI_NAME”: “AMUN”,

“CI_TYPE”: “Server-Physical-RackMount”,

“UDDS”: “A-06-4029”,

“amount”: 237,

“ovrrdAmount”: null,

“isCmdbDataValid”: “yes”,

“billingCodeCmdb”: “A-06-4029”,

“ovrrdBillingCode”: null,

“isBillingCodeValid”: “y”,

“billYorN”: “y”,

“isSplitBilling”: “n”,

“volumeName”: null,

“isNonCI”: false

}

{

“id”: 128604,

“cell”: {

“serviceName”: “Physical Hosting-Full”,

“CI_NAME”: “ANTIGONISH”,

“CI_TYPE”: “Server-Physical-RackMount”,

“UDDS”: “A-06-4026”,

“amount”: 286,

“ovrrdAmount”: null,

“isCmdbDataValid”: “yes”,

“billingCodeCmdb”: “10003130.700”,

“ovrrdBillingCode”: null,

“isBillingCodeValid”: “y”,

“billYorN”: “y”,

“isSplitBilling”: “n”,

“volumeName”: null,

“isNonCI”: false

}

{

“id”: 128436,

“cell”: {

“serviceName”: “Physical Hosting-Full”,

“CI_NAME”: “ANUBIS”,

“CI_TYPE”: “Server-Physical-RackMount”,

“UDDS”: “A-06-4029”,

“amount”: 237,

“ovrrdAmount”: null,

“isCmdbDataValid”: “yes”,

“billingCodeCmdb”: “A-06-4029”,

“ovrrdBillingCode”: null,

“isBillingCodeValid”: “y”,

“billYorN”: “y”,

“isSplitBilling”: “n”,

“volumeName”: null,

“isNonCI”: false

}

{

“id”: 128509,

“cell”: {

“serviceName”: “Physical Hosting-Full”,

“CI_NAME”: “ARIAL”,

“CI_TYPE”: “Server-Physical-RackMount”,

“UDDS”: “A-06-7173”,

“amount”: 237,

“ovrrdAmount”: null,

“isCmdbDataValid”: “yes”,

“billingCodeCmdb”: “A-06-7173”,

“ovrrdBillingCode”: null,

“isBillingCodeValid”: “y”,

“billYorN”: “y”,

“isSplitBilling”: “n”,

“volumeName”: null,

“isNonCI”: false

}

]

February 11, 2014 at 4:57 pm #101802

tony

Keymaster

Hello,

Here is your example

As far as I see the sort is fine. Note that 0 and null are treated as same way so it is possible that some zero

0 values are between the empty ones. Is this the problem?

Regards

P.S. To overcome this problem you can define a custon sorttype which return the original value

something like this:

{

name:colModelNames[5],

width:25,

formatter:'currency',

formatoptions:{decimalPlaces:0,prefix:'$',defaultValue:' '},

sortable:true,

sorttype:function(v){return v;}, // or what you want if the v is null

align:'right',

editable:true,

edittype:'text',

editrules:{number:true}

}

February 11, 2014 at 7:17 pm #101803

lili5058

Participant

Thank you for that answer. <img decoding="async" title="Smile" src="/blog/wp-content/forum-smileys/sf-smile.gif" alt="Smile" /><br />I didn&#039;t realized that 0 and null were treated the same, but it makes sense if you look at it closely (that fact that nulls appear blank make<br />it harder to see). This function does the trick for me.<br /><br />sorttype:function(v){<br />
if (v == null){<br />
return -1;<br />
}<br />
return v;<br />
}<br />

Thank you for that answer. <img decoding="async" title="Smile" src="/blog/wp-content/forum-smileys/sf-smile.gif" alt="Smile" /> I didn't realized that 0 and null were treated the same, but it makes sense if you look at it closely (that fact that nulls appear blank make it harder to see). This function does the trick for me. sorttype:function(v){

sorting: zero values not sorted

Search Forum

Recent Replies

Forum Statistics

UserOnline