How to get last row of table or row count in web application (oracle jde) which has an event rule method for building table data

How to get the row count or click the last row toggle in this oracle jde web application . the[<tr,> ]component is dynamic as we scroll towards the last row So the find children activity is not giving exact row count . I need help is extracting the row count?

Hi @kevinj

Extract the data as datatable by using extract datatable activity. Then output of extract datatable activity is datatable variable, let’s name it as Extract_dt.

Then you can take the count by
Extract_dt.Count

Hope it helps!!

@mkankatala I tried using extract data table but it can extract only 1 row data. No data is getting extracted from table.

Okay scroll down until the last row and send me the screenshot. @kevinj

@mkankatala

what is the button doing?
grafik

@ppr It imports and other option exports data to excel

Perfect, so it is a oracle Form application ( Java extension has been installed)

You can check within the UiExplorer

  • text information of the scroller (surprising it has one, in a lot of cases)
  • the elementstructure of the rows

We implemented a flow like the following and it did work:

  • send page-down
  • read / store scroller bar text
  • repeat as the scroller bar text has changend
  • stop when reached the end
  • work with last rows items

@ppr the ui explorer is not able to get the scroller bar text. As i tried to indicate the scroller bar. Is this correct way I am implementing or please be specified.

feel free to share with us screenshots from scroller, check for all components of the scroller

Please update any applications details especially when above made assumptions are not right

So it was like scrapping the record number . Then splitting it into 2 items . 2nd item subtracted by 1 is our row index . Like that i was able to find the last row index of the table

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.