Hi Michael,

It's funny how the size shrinks when you remove the packages! :)

Please find attached the sample as described in my opening post.

Kind regards,

Nathan

Thanks Michael, that's very helpful. I should be able to wire that in now.

What can I do about:

1. the item not being selected in the list when you first click on the dropdown?
2. showing the display value of the combo not the key value?

Kind regards,

Nathan

Hi Michael,

thanks for the update.  I've looked at that sample and the combo's datasource is coming from the ViewBag rather than a URL.  When I try to implement the example, with the combo datasource pointing to the URL, the call to get the datasource (grid.data("igGridUpdating").options.columnSettings[1].editorOptions.dataSource;) returns null, stopping the array from being populated.  I guess it works in the online sample because the data exists already and not waiting to be initialised from the URL.

This is the code in full:

var yMlookup = [];
$(function() {
      var grid = $("#igGridCompartments"), comboDataSource = {};
      comboDataSource = grid.data("igGridUpdating").options.columnSettings[1].editorOptions.dataSource;
      //alert(comboDataSource);
      for (var i = 0; i < comboDataSource.length; i++) {
       yMlookup[comboDataSource[i].YMId] = comboDataSource[i];
      }
});

I'm assuming the reason this and the items not being selected initially is because the datasource doesn't get initialised until the first click of the combo?  Is there a way to force the combo to retrieve its datasource?

Kind regards,

Nathan

Hi Nathan,

For getting the text value to display in the cell, you will need to get the actual data of the combo.  Accessing the columnSettings like you are will only return the URL that is initially sent to the igCombo.

Please see a small code example below for what you need.

Column definition:

column.For(x => x.YMId).HeaderText("YM").FormatterFunction("yMlookup");

In java script:

function yMlookup(value) {
    var grid = $("#igGridCompartments");
    var combo = grid.igGridUpdating("editorForKey", "YMId");
    if (combo == null) {
        return value;
    }
    return combo.igCombo("dataForValue", value).YmNo;
}

For the initial value not being selected, you are correct.  I am still discussing this with someone on the dev team to find the best solution.

Hi Michael,

I've added the code as you've described but the combo keeps coming back as null, so it doesn't return the value.  I've attached the code to demonstrate.

Kind regards,

Nathan

So basically there's no point in using remote datasources to solve the requirement highlighted in the OP.  If I have to have the datasets locally to get the initial value what's the point of then having the same combos with a remote datasource.

I've ended up putting the data into arrays and feeding everything from them.

Thanks for your help.

Hi Nathan,

For the initial load, the combo will not be initiated or have their datasource set (since you are using cascading).  If you need to have the value displayed initially in the grid, you will need to include that in the initial data sent to the client and use that if combo is null.

For getting the values to display when selecting the combo, one of the developers has modified my sample and I have attached it for you.

If you need further assistance with this, please let me know.