How to do approver cannot see inbox again after do checking?
Confluence User - 12 Oct, 2020
Im trying to do something like this;
Few PIC can approve one request at the same time and they share the same inbox.
If approver 1 already checked and submitted, he cannot see the request in inbox again to avoid duplicate checking by same approver. Can give me some idea to do this?
I tried to use bean shell to control permission but i think the code is wrong as when i click the hyperlink to do checking it says "You have no permission".
Connection con = DatabaseConnection.getConnection();
final String queryCheck = "SELECT * FROM tablename WHERE approver_email = ? AND running_number = ?";
final PreparedStatement ps = conn.prepareStatement(queryCheck);
ps.setString(1, approver_email);
ps.setString(2, running_number);
final ResultSet resultSet = ps.executeQuery();
if(resultSet.next()) {
return false;
}
else {
return true;
}
Thank you.
beanshell;permission;datalist