New SDBQuery filter methods in Javascript workflow and Java API
When you use the query object to query data, which is the SDBQuery in Java API or the query object retrieved through the db.getQuery method in the Javascript workflow engine. If you want to add a query criteria according to a field, you used to have to do this:
SDBQuery q=...//existing query
SDBQuery subQuery=new SDBQueryFull(worker);
subQuery.go(queryFieldId);
subQuery.filter("filterConditionString");
q.filter(subQuery,false);
We now provide you with a series of convenience methods like SDBQuery.filter(int fieldId, String filterValue). All existing filter methods you can now add an int argument as the query field, so you no longer have to create a subquery to filter a query on another field. Now you only need to do this:
SDBQuery q=...//existing query
q.filter(queryFieldId,"filterConditionString");
This should save you a few lines of code each time you filter something with our API.