topic Re: Help with Null in dojo grid / store in ArcGIS JavaScript Maps SDK Questions

Help with Null in dojo grid / store

RobinWoodsong — Tue, 06 Sep 2011 15:27:25 GMT

We do a query and some of the fields for 'Company' have values and some don't. For the fields that don't have a value the grid displays Null and I would like to remove that or simply replace it with a blank space.

After the query but before the grid.setStore I have:

store.fetch({query: {Company:Null}});
// Process the items and update attribute
for (var i = 0; i < items.length; i++){
    var item = items;
    store.setValue(item, "Company", (" "));
}

// If the store has modified items (it should), call save with the handlers above.
if (store.isDirty()){
    store.save();
}

But it doesn't work and I don't know why. Any help appreciated.
Thanks,
Robin

Re: Help with Null in dojo grid / store

JohnGrayson — Tue, 06 Sep 2011 23:13:19 GMT

Robin,
[INDENT]try this:[/INDENT]

store.setValue(item, "Company", " ");

[INDENT]However, I would recommend you instead check out the 'formatter' and 'get' attributes of the '<th>' table element as they provide additional control of the displayed content in the cell. More information can be found here.
[/INDENT]
John

Re: Help with Null in dojo grid / store

RobinWoodsong — Wed, 07 Sep 2011 16:38:05 GMT

Thanks John! You pointed me in the right direction!

I attached a formatter to the field

<th field="COMPANY" width="150px" formatter='fixNull'>Company</th>

Then wrote a function to replace any null with an empty value.

function fixNull(companyName, rowIndex){
noValue = "";
if( dojo.string.trim(companyName) == "Null") { //company field was null so use noValue
var rowdata = this.grid.getItem(rowIndex);
return noValue;
} else {
return companyName;
}
}