Talk:Plugin: Kanban Dashboard
From iDempiere en
i think plugin name and folder name should same. it's convention of *dempiere, so we can give rmap same pattern for all plugin.
class KanbanBoard.beforeSave do below code to check validate of virtual column.
String sql = "Select "+priorityRule+" FROM "+getAD_Table().getTableName(); if (DB.getSQLValue(get_TrxName(), sql) == -1) { log.saveError("Error", Msg.getMsg(Env.getCtx(), "KDB_InvalidPriority")); return false; }
because of DB.getSQLValue() method return -1 for both case sql exception and table have no record.
so this code will fail on case table have no record.
it can modify to
String sql = "Select "+priorityRule+" FROM "+getAD_Table().getTableName(); DB.getSQLValueEx(get_TrxName(), sql);