Forum Discussion

David91's avatar
David91
Frequent Contributor
5 years ago

Variable table findrow method

Please i need help with create variable table method findrow.. i found in TC community code:   def search_in_table(name): table = Project.Variables.yourTableVar table.Reset() counter...
  • Reshail's avatar
    Reshail
    5 years ago

    Okay so I dont know what table.reset does I've never really used it. What I would do in your case is ( If you have your column number fixed which is not a great idea btw)

     

    function FindDavid(){
    table = Project.Variables.yourTableVar

    for(var i=0;  i<table.RowCount; i++){

    var cell = table.cell(i,0) //whatever your column number is

    if(cell.contentText == "David"){
    return i;
    }

    }
    }

     

    Try this and let me know.

Reshail's avatar
Reshail
Contributor
5 years ago

Okay so I dont know what table.reset does I've never really used it. What I would do in your case is ( If you have your column number fixed which is not a great idea btw)

 

function FindDavid(){
table = Project.Variables.yourTableVar

for(var i=0;  i<table.RowCount; i++){

var cell = table.cell(i,0) //whatever your column number is

if(cell.contentText == "David"){
return i;
}

}
}

 

Try this and let me know.

  • BenoitB's avatar
    BenoitB
    Community Hero
    5 years ago

    As using the word Table instead of Array i suspect is about DB table (so the reset and the isEOF).

    Do you want to search in DB table or in array ?

     

    On array, you have native Javascript functions that does all the job:

     

    function TestFind() {
  const jungle = [ 
                   { name: "frog", threat: 0 },
                   { name: "monkey", threat: 5 },
                   { name: "gorilla", threat: 8 },
                   { name: "lion", threat: 10 }
                 ];

  // break the object down in order to use .includes() or .indexOf()
  const names = jungle.map(el => el.name); // returns ['frog', 'monkey', 'gorilla', 'lion']
  Log.Message(names.includes("gorilla")); // returns true
  Log.Message(names.indexOf("lion")); // returns 3 - which corresponds correctly assuming no sorting was done
  
  // methods we can do on the array of objects
  Log.Message(jungle.find(el => el.threat == 5)); // returns object - {name: "monkey", threat: 5}
  Log.Message(jungle.filter(el => el.threat > 5)); // returns array - [{name: "gorilla", threat: 8}, {name: 'lion', threat: 10}]
}

     

    It comes from this very good article here:

    https://alligator.io/js/array-search-methods/

     

     

     

    • sonya_m's avatar
      sonya_m
      SmartBear Alumni (Retired)
      5 years ago

      Awesome job Benoit, Reshail! Thank you for the efforts!

       

      David91 Please mark the best answer as a solution or let us know if you need more help with this 🙂