How to save jdbc response and iterate to next request?

Gatling (Open-Source)
1

I am using Gatling ver. 2.1.7. I want to iterate IDs which I got from sql query.

Below SQL statement will fetch 100 IDs, I want to iterate those 100 IDs. How do I do that?

here is the code,

    val dbStatement = System.getProperty("dbStatement", """SELECT ID_ aID FROM MYTable WHERE ID_ IN(some query) LIMIT 100""")
    val dbQuery = jdbcFeeder("jdbc:mysql://" + dbUrl +":3306/test", dbUsername, dbPassword, dbStatement)

    val scn = scenario("Get Total assets")
        .feed(dbQuery)
        .exec(http("Fetching tests using IDs")
        .get("""/api/assets/${aID}/test""")
        )



Thank you.