Executing Multiple Queries Using the DataSource

You can use the same DataSource instance to execute multiple parameterized object queries or SQL queries with different parameters, repeatedly, in the same event-handler method. If the DataSource restrictions or SQL queries use binding expressions with parameters, you can change the parameter value(s) and re-run the query. For example:

DataSource ds = ...
ds.addRestriction(Restrictions.eq("wr", "status", "${parameters['status'}"));
ds.addParameter("status", "", DataSource.DATA_TYPE_TEXT);

ds.setParameter("status", "Created");
List createdRequests = ds.getRecords();

ds.setParameter("status", "Requested");
List createdRequests = ds.getRecords();