Forum Discussion

rmnrdi's avatar
rmnrdi
Contributor
7 years ago

Check for values in database before test runs

I'm trying to set up a test that will check for certain values in our database before the other tests in the project run.

 

Basically, I want to stop the test if certain values aren't in the database. 

 

I tried setting up an if...then for the data table I created so I can just say IF this returns all the values THEN keep going. 

 

The problem is, when I'm setting up the IF statement the data table isn't recognized.

 

Anyone else do this for desktop testing? How did you over come this?

 

Thanks,

Rob

  • Can you clarify what you mean by the data table isn't being recognized?  How is your data table set up? Is it a variable or a store?

     

    If it's a variable when you select the value for the if statement you would want to make sure to select table data.

     

    If it's a store you could do a simple checkpoint on it. 

  • cunderw's avatar
    cunderw
    Community Hero

    Can you clarify what you mean by the data table isn't being recognized?  How is your data table set up? Is it a variable or a store?

     

    If it's a variable when you select the value for the if statement you would want to make sure to select table data.

     

    If it's a store you could do a simple checkpoint on it. 

    • rmnrdi's avatar
      rmnrdi
      Contributor

      I actually just created a variable and stuck my query in it.

       

      I can now compare the output of the query to a known value.

       

      Thanks.