1
0
-1

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.

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Hi, once a task is completed it will no longer be available in the user's inbox. How is your process designed such that the task is still in the inbox?

        CommentAdd your comment...