The Ragic Guide
Transforming the way your business works with IT software and cloud services
Follow us on Social Media!
Tips and Tricks
Applications
Case Studies
Data Drama
Talking Ragic
Facebook X YouTube
Product
Guide
About
Tips and Tricks
Applications
Case Studies
Data Drama
Talking Ragic

New SDBQuery filter methods in Javascript workflow and Java API

By Jeff Kuo

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.

Powered by Ragic! : #1 No Code tool for digitalizing your business processes
    Keeping business data on Excel is not only a big productivity drain, it's error prone and provides no adequate trail of audit. As your team grows, managing data with spreadsheets become increasingly painful.
    Create your first database now!

    Start Ragic for free

    Sign up with Google