Forum Stats

  • 3,826,277 Users
  • 2,260,618 Discussions
  • 7,896,861 Comments

Discussions

get row count of filtered view object in backing bean

Abdelrahman ElGiar
Abdelrahman ElGiar Member Posts: 44 Green Ribbon
edited May 26, 2022 8:07AM in JDeveloper and ADF

Hello ,

what's the best practice to filter view object and get row count in bean ?

ex : i have 3 tables

first table master , second table detail , third table detail for the detail .

I need to get the row count of the third table that filtered with the first table pk

when i use third_itertaor.getRowSetIterator().getRowCount(); show only count of rows that detailed for second itertaor .

when i use third_itertaor.getViewObject().getRowCount(); show all rows in the table

i need to count third table rows that detailed for the current row of first table.

thanks.

my Jdev ver : 12.2.1.2.0

Answers