How to iterate/loop through a "User Defined Variable" - set with JMeter?

Question

Is there any possibility to iterate or loop through a "User Defined Variables" - set like it's possible with a CSV data set (WHILE-COUNTER-CSV Data Set Config)?

I want to fire a JDBC request (Select Statement) for each variable contained in the "User Defined Variables" - Set. It works fine with a CSV file, but i can't figure out how I can loop through a variables set. Is that even possible? I have various scenarios, where I want to loop through a "User Defined Variables" - set.

May I know the issue with using CSV Dataset Config? I don't think there is way to iterate through all UDVs — Naveen Kumar R B
– Naveen Kumar R B, Commented Feb 16, 2017 at 8:56
I don't want to use CSV's because of multiple reasons: - Im afraid that too much CSV reads have an negative impact on performance of the test - Information isn't centralized in the Testplan, instead I always have to open the CSV files to look for something - — VolJin
– VolJin, Commented Feb 16, 2017 at 9:13

Dmitri T · Accepted Answer · 2017-02-16 15:35:55Z

In order to be able to iterate the User Defined Variables with ForEach Controller you just need to follow simple naming convention like:

var_1=someValue
var_2=someOtherValue
var_3=someMoreValue
etc.

However if you would like to keep the original variable names you can create an extra set of JMeter Variables which can be consumed by the ForEach Controller using the next steps:

Let's assume you have the following User Defined Variables:

and you want to use their values in ForEach controller

Add JSR223 Test Element (Sampler, Pre/Post Processor, etc) somewhere in your script and put the following code in its "Script" area

import org.apache.jmeter.threads.JMeterVariables;

int counter = 1;

JMeterVariables tempVars = new JMeterVariables()

vars.entrySet().each { entry -> 
    def name = entry.getKey()
    if (!name.equals("JMeterThread.last_sample_ok") && !name.equals("JMeterThread.pack") && !name.equals("START.HMS") && !name.equals("START.MS") &&
        !name.equals("START.YMD") && !name.equals("TESTSTART.MS")) {
        tempVars.put("tempVar_" + counter, entry.getValue())
        counter++;
    }
}

vars.putAll(tempVars);

After script finishes you should have 3 more JMeter Variables

Once you have them - you can use ForEach Controller configured like:
So you will be able to use ${current} (or whatever you put into the "Output variable name" in the JDBC Request

See Groovy Is the New Black article to learn more about using Groovy in JMeter tests.

Man Ionut · Accepted Answer · 2017-02-16 09:30:42Z

-5

You can't just iterate within the User defined variables list. From a security perspective you shouldn't be allowed to do that.

You should stick to csv files.

References:

answered Feb 16, 2017 at 9:30

Man Ionut

3182 silver badges9 bronze badges

5 Comments

VolJin Over a year ago

Thank you for your answer. Ok so I need to implement it with CSV's. So do you think it's valid to say, that using UDV's is faster than using CSV data sets, because the CSV hast to be read and the read information has to be stored as a JMeter variable, where UDV's are directly defined JMeter variables?

Man Ionut Over a year ago

I understand your point, but the added latency wouldn't decrees your performance much (under 2%) if the file is located on the same machine. I consider it an acceptable loss.

Man Ionut Over a year ago

And the queries/ values are much easier to update within a csv file.

VolJin Over a year ago

I'm with you, it's an acceptable loss. To workaround this affection, I could read all CSV files and data from the database, like described in the question, in my preparation thread group (where i also restore db backups and so on) before the actual test thread group. Or isn't it a good idea to create a large amount of UDV data?

Man Ionut Over a year ago

You can chose each way. Reading from file works ok if you have under 10 k rows but that sometimes gets really hard to update.

Collectives™ on Stack Overflow

How to iterate/loop through a "User Defined Variable" - set with JMeter?

2 Answers 2

Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related