Assigning my own RowID to the Rows in V2

How do I give the Rows another RowID (e.g. the identity column from my database) in V2?

The method setRowValues() no longer exists in V2. This code no longer works:

var myRows = ["11111", "22222", "33333", "44444", "55555"];

Rick Jordan
October 12,
The correct method in v2 is setRowIndices, see example in /examples/quickref/grid.htm - line 428 :-)

In beta1 row indices can only contain symbols 0-9 (numeric), the final release will allow 0-9, A-Z, a-z starting with number.
Alex (ActiveWidgets)
October 12,

Thanks, I saw that, but I am not referring to hiding or re-ordering the rows. I am referring to setting the actual RowIDs as mentioned in this thread:


How can we do this in V2?
Rick Jordan
October 12,
Yes, it is the same thing - you just give the grid an array of indices to use instead of 0..(count-1).
Alex (ActiveWidgets)
October 12,

I must be missing something . . . sorry.

setRowIndices seems to perform a completely different function to the deprecated setRowValues. Try out the code below and you will see no rows are displayed (because rows 111,222,333,444 and 555 don't exist!).

var myData = [
        ["MSFT","Microsoft Corporation", "314,571.156", "32,187.000", "55000"],
        ["ORCL", "Oracle Corporation", "62,615.266", "9,519.000", "40650"],
        ["SAP", "SAP AG (ADR)", "40,986.328", "8,296.420", "28961"],
        ["CA", "Computer Associates Inter", "15,606.335", "3,164.000", "16000"],
        ["ERTS", "Electronic Arts Inc.", "14,490.895", "2,503.727", "4000"]

var obj = new AW.UI.Grid;
obj.setRowIndices( ["111", "222", "333", "444", "555"] );

As you say in the grid.htm example, the setRowIndices() method is used to re-arrange or hide rows, not set the RowIDs.

    re-arrange rows
    obj.setRowIndices([0,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19]);	// hide row 1

document.write(obj);([19,18,17,16,15,14,13,12,11,10,9,8,7,6,5,4,3,2,1,0]);	// reverse order

This is a VERY desirable function to have, I agree, but if I could associate the RowIDs with the data IDs in my SQL database (which is what I am trying to do) then filtering the data in the grid 'on the fly' will be so easy - I simply assemble a list of data IDs using a SQL SELECT statement and pass it to the grid using setRowIndices() and voila! - I have filtered my list.

Is this a good way of doing it and if so, what method do I use to set the RowIDs because, as I have indicated, setRowIndices() doesn't seem to work the way you describe. Please advise.

Rick Jordan
October 13,

when using custom indices you have to use them both in the grid and the data source:

var myData = [];

myData["111"] =	["MSFT","Microsoft Corporation", "314,571.156", "32,187.000"];
myData["222"] =	["ORCL", "Oracle Corporation", "62,615.266", "9,519.000"];
myData["333"] =	["SAP", "SAP AG (ADR)", "40,986.328", "8,296.420"];
myData["444"] =	["CA", "Computer Associates Inter", "15,606.335", "3,164.000"];
myData["555"] =	["ERTS", "Electronic Arts Inc.", "14,490.895", "2,503.727"];

var myColumns = ["Ticker", "Company Name", "Market Cap.", "$ Sales"];

var obj = new AW.UI.Grid;


obj.setRowIndices(["111", "222", "333", "444", "555"]);


obj.setSelectorText(function(i){return i});
//obj.setSelectorText(function(i){return this.getRowPosition(i)+1});


obj.onCellClicked = function(event, col, row){
    window.status = "row: " + row + " column: " + col;

In general, I think using cutom indices might be a very good idea if you split your application logic between client- and server-side. For example, server-side sorting or filtering would be just sending new row indices array and not the whole data set.
Alex (ActiveWidgets)
October 13,

That's incredible. This is going to make my application so much easier to write.

I appreciate it - thanks.
Rick Jordan
October 13,
My question is that this won't affect the performance? The myData array will have 5 or 555 rows?
July 19,

This topic is archived.

See also:

Back to support forum