Forum Discussion

msap's avatar
msap
Frequent Contributor
6 years ago

Grid:how to search and return for single row where two columns are compared from multiple records

any suggestions :In a Grid using Java script how to search and return return the row from Grid where two columns are compared from multiple records. compare both columns to avoid duplicate value fr...
msap's avatar
msap
Frequent Contributor

 RowIndex = Grid2.FindRowByMultipleValues(Columns, Values);

i changed the 2nd lin too :

Values=new  Array(COUNTRY,asa); 

instead Values=new  Array("COUNTRY","asa"); 

i tried this , still gives an error Unable to find the object FindRowByMultipleValues(null, null). 

 

SaravanaKumar_N's avatar
SaravanaKumar_N
Contributor
6 years ago

No, while declaring the variables, the values should be within the quotes...

 

Columns= new Array ("param1","param2");
Values=new Array("SUB","TEST");

 

But while finding, if you are using a variable name, avoid using the quotes...
RowIndex = Grid2.FindRowByMultipleValues(Columns, Values);

 

TestComplete manual has vast examples... the below is for Find method.

https://support.smartbear.com/testcomplete/docs/reference/test-objects/members/common-for-all/find-method.html#example

 

You can also refer w3school for JavaScript help...

https://www.w3schools.com/js/js_arrays.asp

  • msap's avatar
    msap
    Frequent Contributor
    6 years ago

    Thanks.. If I declare values in quotes, i get java run time error "sub" is not defined.

    I went through find methods and used the find row method. it works good. but currently i need to search the records that matches more than one columns in a  a row.

    So was using this method:FindRowByMultipleValues .

    I will check in w3 schools. Thanks  alot for responding.

    • msap's avatar
      msap
      Frequent Contributor
      6 years ago

      any other suggestions would be appreciated.

      for searching row giving two or more than two column values.