How to count total no of rows when all rows are not visible

by | Last Updated On Sep 2, 2016 | Tips and Tricks in QTP | 14 comments

QTP blog reader Abhijeet has asked here for a way to get total no of rows irrespective of whether the rows are visible or not. I have also faced this problem once while working on a Siebel Application and have written a small piece of code for it.
I would like to reproduce the same code here for the  benefit of QTP community. Please make necessary changes according to the needs of your application.

  1. ' Name: gf_CountTotalRows
  2. ' Description:This function counts the total no of rows irrespective of whether the rows are visible or not
  3. ' Created By:Ankur Jain
  4. ' Variables:sRecordCounter,arrRecordCounter,str,plus,sTotal_Rows
  5. ' Environment Variable:Row_Count
  6. ' Parameters:uiname
  7. '****************************************************
  8. Public Function gf_CountTotalRows(uiname)
  9. 'Variable will contain the (statement) firstset of current no of records
  10. sRecordCounter=SiebApplication("micclass:=SiebApplication").SiebScreen("micclass:=SiebScreen").SiebView("micclass:=SiebView").SiebApplet("micclass:=SiebApplet","uiname:="&uiname).RecordCounter
  11. 'Splitting the variable to get the "+ "sign
  12. arrRecordCounter = Split(sRecordCounter)
  13. 'Storing the 4 member of array(ie the member which contains the + sign)
  14. str=arrRecordCounter(4)
  15. 'Capturing the "+" sign
  16. plus=Right(str,1)
  17. 'Loop to navigate till the last rowset
  18. Do while plus ="+"
  19.     SiebApplication("micclass:=SiebApplication").SiebScreen("micclass:=SiebScreen").SiebView("micclass:=SiebView").SiebApplet("micclass:=SiebApplet","uiname:="&uiname).SiebList("micclass:=SiebList").NextRowSet
  20.     sRecordCounter=SiebApplication("micclass:=SiebApplication").SiebScreen("micclass:=SiebScreen").SiebView("micclass:=SiebView").SiebApplet("micclass:=SiebApplet","uiname:="&uiname).RecordCounter
  21.     arrRecordCounter = Split(sRecordCounter)
  22.     str=arrRecordCounter(4)
  23.     plus=Right(str,1)
  24. Loop
  25. 'sRecordCounter will contain the last set of current visible no of records
  26. sRecordCounter=SiebApplication("micclass:=SiebApplication").SiebScreen("micclass:=SiebScreen").SiebView("micclass:=SiebView").SiebApplet("micclass:=SiebApplet","uiname:="&uiname).RecordCounter
  27. arrRecordCounter = Split(sRecordCounter)
  28. ' sTotal_Rows will contain the Total No of records in string format
  29. sTotal_Rows=arrRecordCounter(4)
  30. Environment.Value ("Row_Count") = sTotal_Rows
  31. 'Finally to navigate back to the first row  set
  32. 'On error resume next 'The next statement works only when the no of rows are greater than visible no of rows
  33. if (Row_Count > 5) then
  34. SiebApplication("micclass:=SiebApplication").SiebScreen("micclass:=SiebScreen").SiebView("micclass:=SiebView").SiebApplet("micclass:=SiebApplet","uiname:="&uiname).SiebList("micclass:=SiebList").FirstRowSet
  35. End if
  36. End function

Related: Tips with QTP
               Tips with Siebel Add-in
               Tips with Oracle/Java Add-in

If you want to keep track of further articles on QTP. I recommend you to subscribe via RSS Feed. You can also subscribe by Email and have new QTP articles sent directly to your inbox.

Please use QTP forum for posting QTP questions.

You Should Read These 3 Related Articles Too!

14 Comments

  1. prasanna on Dec 19, 2011 at 14:54

    Hi
    How to count the rows(emails)in webtable.Am selcting webtable only one column will be added.plz post the code

    Reply
  2. jyotsna on Jun 26, 2010 at 07:05

    Hi
    This is Boby. I am new to this blog. I had a problem in “How to count total no of rows when all rows are not visible “. I am using QTP 10.0 and the default Add-ins like Active X,Visual Basic and Web Addins.please send me the code if possible.Appreciate your response.

    Reply
  3. Ankur on May 4, 2009 at 21:31

    @Anon:

    Here is the algo in a nutshell:

    1. Get the row count using GetRoProperty (We will call this as rowcount)
    2. Using a loop check for the existence for static heading2. Exit the loop as soon as you get the matching string.
    3. Note the position of static heading2 using a variable.
    4. Say it occurs at nth position
    5. The total no of rows below static heading1 would be (n-2) and total no of rows below static heading2 would be (rowcount-n)

    Please use QTP Forums for further questions

    Thanks!

    Reply
  4. Anonymous on May 4, 2009 at 21:11

    Hi Ankur
    Recently i have faced an interview and there they asked a question – On a web page there is one table of one column.
    the first row has one static heading and following rows have some dynamic values. again after these values there is another row with the static heading 2. again a set of rows containing dynamic values.
    Question is to count the no of rows under the respective headings individually.
    Could you please explain me how to do that.

    Thanks

    Reply
  5. Anonymous on Apr 30, 2009 at 05:12

    Hi raju,
    can I get your e-mail id. I have so many doubts in QTP frame works. I would like to ask you.
    Thanks in advance.

    Reply
  6. Anonymous on Feb 25, 2009 at 21:48

    Hi,

    I am Ram, Can some one tell me, how to get the row count for the WinObject? I donot see the Rowcount property for WinObject(“TableView”). I am working on outlook 2007 testing.

    any help is appreciated.

    Regards
    Ram

    Reply
  7. Ankur on Feb 4, 2009 at 01:14

    @Anon: As I have explained above. It is because of the fact that all rows were not visible and and were paginated.

    Otherwise QTP too has a straightforward way of counting rows

    Reply
  8. Anonymous on Feb 3, 2009 at 17:58

    why u need so much of code for finding the rowcount ,
    Just migrate to WinRunner u could do it tbl_get_rows_count 🙂

    Reply
  9. koraseeka on Nov 21, 2008 at 08:56

    Hi

    Gopal What u need
    tell me

    9866600371

    Reply
  11. koraseeka on Nov 21, 2008 at 08:52

    HI

    This raju from leading @MNC,
    regrading any QTP doubt and Testing information tell me
    I will solve to u.
    if ur in Hyderabad contact me
    9866600371
    I am expert in Frame works and Descritpive programming
    bye..

    Reply
  12. gopalreddypg on May 28, 2008 at 11:06

    Hi, dis is gopalreddy iam very intreststed by knowing the qtp information plz cooparate me

    Reply
  13. Soumya on Nov 23, 2007 at 11:10

    This can be used only if application hasd the records in a table format. But my application has the records in a pane where it is not recognised as a table but as a object.
    How can this be tackled?

    Reply
  14. sravanthi1047 on Oct 27, 2007 at 15:29

    Is there any facility like adding the new window ‘s objects to the Object Repository during the run time

    Reply

Submit a Comment

Your email address will not be published. Required fields are marked *