Forum Discussion

MKV's avatar
MKV
Contributor
7 years ago

how to count the number of rows fetched in data source

Hi,

 

Is it possible to count the number of datas fetched in a data source in readyapi? Can it be stored in a variable to use in the next steps.

 

Thanks!

  • HimanshuTayal's avatar
    HimanshuTayal
    7 years ago

    Hi MKV

     

    Try below code:

    DSrowCount = testRunner.testCase.testSteps["DataSource"].rowCount
log.info DSrowCount

     

    Do Like/Accept it as Solution if it solves your query.

     

    Thanks,

    Himanshu Tayal

  • HimanshuTayal's avatar
    HimanshuTayal
    Community Hero
    7 years ago

    Hi MKV

     

    Try below code:

    DSrowCount = testRunner.testCase.testSteps["DataSource"].rowCount
log.info DSrowCount

     

    Do Like/Accept it as Solution if it solves your query.

     

    Thanks,

    Himanshu Tayal

    • MKV's avatar
      MKV
      Contributor
      7 years ago

      Thanks..It worked !!

    • tech321's avatar
      tech321
      Contributor
      6 years ago

      The problem is that the rowCount does not return the actual row count, in my case 200. I have to run my data source step manually first to create the rows and then rowCount will return the actual row count. When I try to automate this and I try to use: 

      def tst = testRunner.runTestStepByName("myDataSource")

      DSrowCount = testRunner.testCase.testSteps["myDataSource"].rowCount
      log.info DSrowCount

      it does not work. There are 200 rows in the datasource but the rowCount returns 1. Is there any way to make the rowCount return 200 instead of 1?

      Thanks 

      • nmrao's avatar
        nmrao
        Champion Level 3
        6 years ago
        tech321,

        Would you mind opening a fresh thread (the previous one was already closed ) with more details of the issue such as what steps does the test case has? Where do you need that row count? What type of data source are you using?