Forum Discussion

nisgupta's avatar
nisgupta
Valued Contributor
6 years ago

Grid issue on web Applications

We are working on grid. We need to select the cell. But the testComplete Object Spy do not recognize this object as grid type . Attached the screenshot.    Is there any generic function that ca...
RUDOLF_BOTHMA's avatar
RUDOLF_BOTHMA
Community Hero

Wish I could help, but no.  Not familiar with it at all :smileysad:

nisgupta's avatar
nisgupta
Valued Contributor
6 years ago

RUDOLF_BOTHMA

 

I need to select the row based on multiple columns . The row is unique based on the multiple columns. Attached the screenshot.

 

 

  • cunderw's avatar
    cunderw
    Community Hero
    6 years ago

    The approach would still be the same as RUDOLF_BOTHMA mentioned. You will want to findall the children that represent a row in your grid, then find the individual elements, and if they match your criteria break our of the loop. 

    • RUDOLF_BOTHMA's avatar
      RUDOLF_BOTHMA
      Community Hero
      6 years ago

      Edit: Well, smartbear threw all of that away. Have to retype...

       

      Agreed cunderw

       

      Off the top of my head I'd do something like*:

       

      var columnoneitems = grid.FindAllChildren(columnoneindex, columnonesearchtext).toArray();
var columntwoitems = grid.FindAllChildren(columntwoindex,columntwosearchtext).toArray();
//columnthreeitems etc.
var iFoundTheRow = false;
var theRowIs = -1;

var i = 0;
var j = 0;
//you can probably improve this.  You just need an efficient way to find the intersect of the arrays.  There should be only one rowindex that exists in all the arrays
while(i<columnoneitems.length && iFoundTheRow==false)
{
while(j<columntwoitems.length&& iFoundTheRow==false)
{
if(columnoneitems[I].RowIndex = columntwoitems[j].RowIndex)
{
iFoundTheRow = true;
theRowIs = columnoneitems[I].RowIndex
}
j++
}
I++;
}

if(iFoundTheRow)
{
var theItem = grid.FindChild(rowindex,clickcolumnindex,clickfindtext)
if(theItem.Exists)
{
theItem.Click();
}
else
{
Log.Error("Item is having an existential crisis");
}
}
else
{
Log.Error("No such Row found");
}
      • RUDOLF_BOTHMA's avatar
        RUDOLF_BOTHMA
        Community Hero
        6 years ago

        Had a thought on this over the weekend...

         

        Performance considerations.  You could do grid.FindAll().toArray() for each text you are looking for, no matter which column they are in and add each FindAll to an array. If any of the arrays have a zero length, you can just break and say the record doesn't exist :smileysurprised:  If any of your arrays now has only one item, thats your row.  If not, do the same array logic to find the one rowindex that exists in all of them.  All about finding the shortcuts :smileyvery-happy:  Since that one text element is alredy in one of your collections, you don't need to do another find.  You just go to the element in the array where the element has the columnindex you want and click the parent.  Larger arrays perhaps, but definately less Finds.  You could try the first post's columnindex first approach with the second approaches array only requirement, thereby having smaller arrays but with the same , smaller Find work that the second approach uses.