Answered question

Populate multiple variables from one SQL query

I am trying to populate a list of Neoload variables from a single SQL query. Is there a way of doing this in Neoload?

If I have a query like "SELECT firstname, lastname, age, gender FROM users;" when I execute the query I retrieve one row of values such as "john,doe,49,male" and I want to use this to set the value in the respective neoload variables.

Dean C.
Dean C.

Dean C.

Level
0
1 / 100
point
christophe M.
christophe M.

christophe M.

Level
4
5000 / 5000
points
Team

You can use a SQL Variable, they are multi-valued.

Once the Query is defined for the variable "Users", then you can access the different columns with ${Users.firstname}, ${Users.lastname}, ${Users.age}...

Did you find this useful ?

No (0)

Yes (1)

100%

100% of users found this answer useful