How to check for a row value for paginated records ?

Hi,



You need to move through pages (click the link/button/whatever which moves you to the next page) and use the Find method on each page to find your invoice by its number. Once Find returns an object with Exists equal to True, work with this object.

Thanks Jared. Please have a look at the following code,I am able to compare Invoice# as text and I need to click the link coming in some other cell corresponding to that row, which I am ..

PropArray = Array("Link")

 ValuesArray = Array("500.00")

  ' Specifies the property values

     'ValuesArray(0) = "Link"

       'ValuesArray(1) = "500.00"

 

          Set obj = pagefn.Find(PropArray, ValuesArray, 20000)



I guess the depth is 20,000,I mean to take that going thro' all the child objects.obj.Exists ,but returns false.



Am I missing something here ?

Hi,



Is the link you want to click located in the same table row as the invoice#? If it is, just obtain the corresponding row cell as it is described in the "Parsing HTML Tables" help topic.

That's done Jared .Thanks But if I want to click the pagination links,that's also working,but once I reference the table object to try &  get the rows and cells ,VBScript error 'Unspecified Error' comes up.I checked exists property,returns true ,but rows.length is throwing the 'Unspecified error exception'.Please review the function below  for your review.I use this function to loop thro,after getting page and table.First page is ok,if data is not there,it clicks the Next pagination link,from there the above error related to tableobj appears



Function LoopCells(tableobj,matchtext)



          if        tableobj.exists  Then

             Log.Message("tableobj exists ")

             Log.Message(tableobj.rows.length) ' This gives error

          end if



       For i = 1 To tableobj.RowCount-1

          

          'Sys.Process("iexplore").Page("*").Form("DefaultFormName").Panel(0).Panel(2).Panel(0).Panel(1).Table("SearchHdr").Cell(3, 0).Table(0).Cell(0, 0).Panel(0).Panel(0).Table(2).rows.item(i).cells.length

          Set row=tableobj.rows.item(i)  

          'MsgBox(tableobj.rows.item(i).cells.length)

          For j = 0 To Row.cells.length - 1

            ' get the cell

            Set cell = row.cells.item(j)

              

                      Log.Message "Cell " + ": " + Cell.innerText

                      if (Cell.innerText=matchtext) Then

                      Result = CBool(1 + 1 = 2)

                      LoopCells=Result

                      exit function

                      else

                        Result = CBool(1 + 1 = 5)

                        LoopCells=Result

                      end if

    Next

       Next

      

End Function

Hi,



Can you post here an image of this exception? In which exact line does it occur?

With ref. to what I said ".I
use this function to loop thro,after getting page and table.First page
is ok,if data is not there,it clicks the Next pagination link,from
there the above error related to tableobj appears"

I did the mistake of getting the page and table and referencing it same when I move to the next page ,so I am checking whether data I want exists after getting again the page and table,I also do a wait and refresh of the page(going by one of your recommendations in a post).

My thought process is ,if the table is not created dynamically(html source doesn't show that),why would one need to create the page and table again to reference the same.Looks like the object is destroyed when it goes to the next page .Just wanted to check this is correct?



And one more thing.. I am trying to write a generic function ,based on data to be found ,it would go thro' paginated records and initiate a click action either on a button/link which can be on any cell on a row.

How do I get that ,unless otherwise I pull up the type specified in an excel? Can this be done like get the cells in that row,based on excel value,then  either click the link/button ?Just get the excel value and use Link() /  Button() ??

Hi,

Looks like the object is destroyed when it goes to the next page .Just wanted to check this is correct?

Yes, this happens because the page is reloaded.

I am trying to write a generic function ,based on data to be found

Use the Find method, search by text.

Thanks Jared,Can you post a small code sample/link to a sample ?Because I am not sure of the properties/values to be passed in Find method for link/button.For button,object finder reveals a Image.Is there a way to get the objectType ? I saw the objectType in ObjectTree .

Hi,



To get the object type, use the objectType property. As for finding links and buttons, you can try using innerText to address them by captions without using object types at all. This way, you can create code which will click any object with the specified text.

Sorry Jared,I do not get that by using innerText of the cell and link,they are different so can't match by looping thro' table cells.

Looks like I need to write different functions for each object type.Earlier if the # is a text it works.

' this is for the link

Sys.Process("iexplore").Page("*").Form("DefaultFormName").Panel(0).Panel(2).Panel(0).Panel(1).Table(1).Cell(1, 0).Panel(0).Table(0).Cell(3, 0).Table(0).Cell(0, 0).Panel(0).Panel(3).Table(0).Cell(1, 0).Table(0).Cell(4, 2).Table("HeaderResultsTable_DocumentNumberRN_3").Cell(0, 0).Table("HeaderResultsTable_PoNum_3_xc_").Cell(0, 2).Link("HeaderResultsTable_PoNum_3")



'This for the cell that shows the number as link

Sys.Process("iexplore").Page("*").Form("DefaultFormName").Panel(0).Panel(2).Panel(0).Panel(1).Table(1).Cell(1, 0).Panel(0).Table(0).Cell(3, 0).Table(0).Cell(0, 0).Panel(0).Panel(3).Table(0).Cell(1, 0).Table(0).Cell(4, 2)



As shown in attachment,I trying to select radio button corresponding to link of 100026,but in another form it is in text,that works fine.

InnerText when output is different for the cell and the link.

The function for looping thro' table looks like cannot be generalized across forms which have different objecttypes.

I tried find() with ObjectType as attribute and Link as value and depth as 2000.It returns last column of the table.



Please guide