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!

  • 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

  • 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

      Thanks..It worked !!

    • tech321's avatar
      tech321
      Contributor

      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
        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?