[CLOSED] Projection of getRowsValues?

[ptrourke]

I have two grids - MyCategoryGrid and MyItemsGrid which display data from two database tables, MyCategory and MyItems. MyCategoryID is the PK in MyCategory and the FK In MyItems.

I have a function, ShowItems, that gets the selected items from MyCategoryGrid and shows all the associated MyItems in MyItemsGrid. I pass the selection using store.getRowsValues to get an Ext.data.Model, and pass that to a DirectMethod which takes it in as a Dictionary<string, string>[] MySelectedCategories. I then create a List<int> MySelectedCategoryIDList in C#:

ItemsJS = {
  ShowItems: function() {
    var MySelectedCategories = MyCategoryGrid.getRowsValues({selectedOnly: true});
    App.direct.GetItemsForCategory(MySelectedCategories);
  }
};

[DirectMethod]
void GetItemsForCategory(Dictionary<string,string>[] MySelectedCategories)
{
  List<int> mySelectedCategoryIDList = MySelectedCategoryIDList(MySelectedCategories);
  BindItemsGridForSelectedCategories(mySelectedCategoryIDList);
}

List<int> MySelectedCategoryIDList(Dictionary<string,string>[] MySelectedCategories) 
{
  List<int> MySelectedCategoryIDList = new List<int>();
  foreach (Dictionary<string,string> MyCategory in MySelectedCategories)
  {
    MySelectedCategoryIDList.Add(Int32.Parse(MyCategory["MyCategoryID"]));
  }
  return MySelectedCategoryIDList;
}

and pass that back to a stored procedure which returns the values for the MyItemsGrid.

I'd love to push the process of projecting the MyCategoryID column from MyCategoryGrid to a library function; say a

ItemsJS = {
  ShowItems: function() {
    var mySelectedCategoryIDList = MyCategoryGrid.getRowsValues({selectedOnly: true}).getColumnValues("MyCategoryID");
    BindItemsGridForSelectedCategories(mySelectedCategoryIDList)
  }
};

Is there such a function? (I can't find an appropriate method on the Sencha site or in the ext-all.js file).

Thanks!

[Baidaly]

Hello!

If I understood your correctly that you want to get just an array with selected IDs, you should use map function: http://docs.sencha.com/extjs/4.1.3/#...ray-method-map

MyCategoryGrid.getRowsValues({selectedOnly: true}).map(function(item) { return item['MyCategoryID']; })

[ptrourke]

Yes, you got the question right ... And I had forgotten about the map function. Thanks!

[ptrourke]

So, I switched my JS function over to use the JavaScript array map function, and it worked great on development under Chrome and IE 10.

When I moved it up to production to test in IE 8, I got an "Object doesn't support this property or method" error.

This is because IE8 doesn't support the map function.

Are you folks using it internally? If so, how are you getting it to work?

[See <http://stackoverflow.com/questions/7350912/is-the-javascript-map-function-supported-in-ie8>]

Thanks!

PTR

[Vladimir]

Please use Ext.Array.map function
http://docs-origin.sencha.com/extjs/...ray-method-map

[ptrourke]

Thanks, Vladimir! I was confused by the example above:

MyCategoryGrid.getRowsValues({selectedOnly: true}).map(function(item) { return item['MyCategoryID']; });

Obviously this is just the basic JavaScript map function. It looks like it should be done this way with Ext.Array.map:

Ext.Array.map(MyCategoryGrid.getRowsValues({selectedOnly: true}), function(item) { return item['MyCategoryID']; });

This is working fine in my development environment, so I assume I have the syntax right.

Thanks!

[Daniil]

Just IE8 doesn't have the map method in its arsenal for arrays.