Joget DX Available for Download

Check out Joget DX, the next generation successor to Joget Workflow for faster, simpler digital transformation.

Skip to end of metadata
Go to start of metadata

You have a requirement where a datalist needs to return a specific status based on the value of a column.

In this case, we want to return the status "Expired" or "Active" based on the date value in the datalist compared to the actual date.

Edit the datalist column where you want to return the status and select Bean Shell Formatter to enter the code below(Refer to Figure 2).

Figure 1


Figure 2


SQL
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;

SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");
try {
    Date date = formatter.parse(value);
    Calendar cal = Calendar.getInstance();
    if (date.before(cal.getTime())) {
        return "Expired";
    } else {
        return "Active";
    }
} catch (ParseException e) {
    e.printStackTrace();
}




  • No labels